Creating Oracle Directories

For Oracle10g you only need to create the directory for $ORACLE_BASE:

su - root
mkdir -p /u01/app/oracle
chown oracle.oinstall /u01/app/oracle

But if you want to comply with Oracle's Optimal Flexible Architecture (OFA), then you don't want to place the database files in the /u01 directory but in another directory/filesystem/disk like /u02. This is not a requirement but if you want to comply with OFA, then you might want to create the following directories as well:

su - root
mkdir -p /u02/oradata/orcl
chown oracle.oinstall /u02/oradata/orcl

In this example, "orcl" stands for the name of the database which will also be the name of the instance. This is typically the case for single instance databases.


Optimal Flexible Architecture (OFA) for 10g R1 (10.1.0.2)

The OFA standard is a guideline created by Oracle to ensure reliable Oracle installations. For Oracle 10g Database, the OFA recommended Oracle home path has changed.

The home path for the first 10g (10.1.0) database installation on a system would be:

  /u01/app/oracle/product/10.1.0/db_1

If you would install a second Oracle 10g Database 10g (10.1.0) on the same system, the Oracle home directory would be as follows:

  /u01/app/oracle/product/10.1.0/db_2

If the Oracle10g software is not owned by the user oracle but by the user "oraowner", then the path of the Oracle home directory would be:

  /u01/app/oraowner/product/10.1.0/db_1
 /u01/app/oraowner/product/10.1.0/db_2

The standard directory name for Oracle10g is "app":

  /u01/app/oracle/product/10.1.0/db_1

Oracle recommends to use mount points such as /u01, /u02, etc. which complies with the OFA guidelines. But others can be used, for example:

  /disk_1/app/oracle/product/10.1.0/db_1

The subtree for database files not stored in ASM disk groups should be named as follows:

  /u02/oradata/<db_name_1>
 /u02/oradata/<db_name_2>
 /u03/oradata/<db_name_1>

 /u03/oradata/<db_name_2>

The mount point /u01 should be used for the Oracle software only. /u02, /u03, /u04 etc. should be used for the database files. The db_name stands for the DB_NAME initialization parameter which is typically the same as the SID name for single instance databases.

YOU CAN USE QUICK SEARCH ENGINE IN THE TOP FOR MORE DOWNLOADS OR DETAILS.