If you want to comply with Oracle's Optimal Flexible Architecture (OFA), then you do not want to place the database files in the
/u01 directory but in another directory, file system or disk such as
24.1. 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:
If you would install a second Oracle 10g Database 10g (10.1.0) on the same system, the Oracle home directory should be as follows:
If the Oracle 10g software is not owned by the user
oracle but by the user "
oraowner", then the path of the Oracle home directory would be:
The standard directory name for Oracle 10g is "
Oracle recommends to use mount points such as
/u02, and so on, complies with the OFA guidelines. But others can be used, for example:
The subtree for database files not stored in ASM disk groups should be named as follows:
The mount point
/u01 should be used for the Oracle software only.
/u04 and so on, should be used for the database files.
The db_name represents the
DB_NAME initialization parameter which is typically the same as the
SID name for single instance databases.