Optimal Flexible Architecture File Path Examples

Review examples of hierarchical file mappings of an Optimal Flexible Architecture-compliant installation.

This example shows an Optimal Flexible Architecture-compliant installation with three Oracle home directories and three databases, as well as examples of the deployment path differences between a cluster install and a standalone server install of Oracle Grid Infrastructure. The database files are distributed across three mount points: /u02, /u03, and /u04.

Note:

The Grid homes are examples of Grid homes used for an Oracle Grid Infrastructure for a standalone server deployment (Oracle Restart), or a Grid home used for an Oracle Grid Infrastructure for a cluster deployment (Oracle Clusterware). You can have either an Oracle Restart deployment, or an Oracle Clusterware deployment. You cannot have both options deployed at the same time.
Oracle Automatic Storage Management (Oracle ASM) is included as part of an Oracle Grid Infrastructure installation. Oracle recommends that you use Oracle ASM to provide greater redundancy and throughput.

Table C-2 Optimal Flexible Architecture Hierarchical File Path Examples

Directory	Description
`/`	Root directory
`/u01/`	User data mount point 1
`/u01/app/`	Subtree for application software
`/u01/app/oraInventory`	Central OraInventory directory, which maintains information about Oracle installations on a server. Members of the group designated as the OINSTALL group have permissions to write to the central inventory. All Oracle software installation owners must have the OINSTALL group as their primary group, and be able to write to this group.
`/u01/app/oracle/`	Oracle base directory for user `oracle`. There can be many Oracle Database installations on a server, and many Oracle Database software installation owners. Oracle software homes that an Oracle installation owner owns should be located in the Oracle base directory for the Oracle software installation owner, unless that Oracle software is Oracle Grid Infrastructure deployed for a cluster.
`/u01/app/grid`	Oracle base directory for user `grid`. The Oracle home (Grid home) for Oracle Grid Infrastructure for a cluster installation is located outside of the Grid user. There can be only one Grid home on a server, and only one Grid software installation owner. The Grid home contains log files and other administrative files.
`/u01/app/oracle/admin/`	Subtree for database administration files
`/u01/app/oracle/admin/TAR`	Subtree for support log files
`/u01/app/oracle/admin/db_sales/`	Admin subtree for database named “sales”
`/u01/app/oracle/admin/db_dwh/`	Admin subtree for database named “dwh”
`/u01/app/oracle/fast_recovery_area/`	Subtree for recovery files
`/u01/app/oracle/fast_recovery_area/db_sales`	Recovery files for database named “sales”
`/u01/app/oracle/fast_recovery_area/db_dwh`	Recovery files for database named “dwh”
`/u02/app/oracle/oradata /u03/app/oracle/oradata /u04/app/oracle/oradata`	Oracle data file directories
`/u01/app/oracle/product/`	Common path for Oracle software products other than Oracle Grid Infrastructure for a cluster
`/u01/app/oracle/product/19.0.0/dbhome_1`	Oracle home directory for Oracle Database 1, owned by Oracle Database installation owner account `oracle`
`/u01/app/oracle/product/19.0.0/dbhome_2`	Oracle home directory for Oracle Database 2, owned by Oracle Database installation owner account `oracle`
`/u01/app/oracle2/product/19.0.0/dbhome_2`	Oracle home directory for Oracle Database 2, owned by Oracle Database installation owner account `oracle2`
`/u01/app/oracle/product/19.0.0/grid`	Oracle home directory for Oracle Grid Infrastructure for a standalone server, owned by Oracle Database and Oracle Grid Infrastructure installation owner `oracle`.
`/u01/app/19.0.0/grid`	Oracle home directory for Oracle Grid Infrastructure for a cluster (Grid home), owned by user `grid` before installation, and owned by `root` after installation.
`/u01/app/oracle/product/19.0.0/client_1`	Oracle home directory for Oracle Database Client 1, owned by Oracle Database installation owner account `oracle`

Parent topic: Optimal Flexible Architecture