OFA directory structure

The easiest way to present the OFA structure is to lay it out in a table. Below the table, several explanations are provided to explain this structure.

In this document we consider the fact that OFA is a "Flexible" architecture. Therefore, we provide instructions but only advices and best practices each one is free to respect of not. Also the level of details until which OFA should be implemented can be defined by the customer according to its requirements.

Unix – Windows directory structure

Mount Point	Directory	Owner	Description
/u01 Unix Drive: Win.		root	The /u01 mount point contains the Oracle administration files (software, configuration and log files, scripts)
	/app [ UNIX/Linux only ]	root	Application directory (i.e oracle, mysql, sybase)
	[/app]/oracle	oracle	ORACLE_BASE, basis for all Oracle components
	[/app]/grid	grid	ORACLE_BASE, basis for all grid related configuration files
	[/app]/oracle/etc	oracle	Directory containing the following files. Soft links exist from /etc to each of these files : oratab oraInst.loc

Oracle - Binary structure

Database

Mount Point	Directory	Owner	Description
/u01	[/app]/oracle/product	oracle	Directory containing the Oracle software installations
	[/app]/oracle/product/12_1_0_2_170418_v0 [/app]/oracle/product/12_1_0_2_170418_v1 [/app]/oracle/product/12_2_0_1_BASE_v0	oracle	Bundle Patch 12.1.0.2.170418 without further one-off patches Bundle Patch 12.1.0.2.170418 with one or more additional one-off patches 12.2.0.1-Base-Release without further patches
	[/app]/oracle/product/18_3_0_0_RU180717_v0 [/app]/oracle/product/18_3_0_0_RU180717_JVM_v0		Release Update 18.3.0.0.180717 without further patches Release Update 18.3.0.0.180717 with Oracle JavaVM Component without further patches

Grid Infrastructure

Mount Point	Directory	Owner	Description
/u01	[/app]/11.2.0.3/grid	grid	GRID_HOME base location for storing the oracle grid infrastructure software (11.2.0.3)
	[/app]/11.2.0.4/grid	grid	GRID_HOME base location for storing the oracle grid infrastructure software ( 11.2.0.4)
	[/app]/grid		GRID_BASE, basis for all log diag files of Grid Infrastructure
	[/app]/11.2.0.4/grid/network/admin /[app]/11.2.0.4/grid/network/admin/listener.ora ➔ ${TNS_ADMIN}/listener.ora →		Listener Home directory for Grid Infrastructure To allow Oracle to view the listener configuration create a softlink from GRID_HOME/network/admin to ${TNS_ADMIN}

Administration structure

Database Admin structure

Mount Point	Directory	Owner	Description
/u01	[/app]/oracle/admin/SID [/app]/oracle/admin/SID/pfile [/app]/oracle/admin/SID/create	oracle	Oracle Admin directory for DB1 Oracle Conf. file (spfile,passwd) Oracle Activities scripts

DMK

Mount Point	Directory	Owner	Description
	[/app]/oracle/local/dmk [/app]/oracle/local/dmk_dbcreate [/app]/oracle/local/dmk_dbbackup	oracle	Database Management Kit – DMK Database Creation scripts Database Backup scripts
	[/app]/oracle/local/dmk_sql /app]/oracle/local/dmk_dbduplicate [/app]/oracle/local/dbmigr		Database Sql scripts

Oracle*Net

Mount Point	Directory	Owner	Description
	[/app]/oracle/network	oracle	Base directory for network configuration
	[/app]/oracle/network/admin		TNS_ADMIN, Oracle*Net configurations files (listener.ora, sqlnet.ora, ldap.ora, tnsnames.ora)Diagnostic Repository since 11g)
	[/app]/oracle/network/log	Oracle	Oracle*Net log files (replaced by the Automatic Diagnostic Repository since 11g)
	[/app]/oracle/network/trace	Oracle	Oracle*Net log files (replaced by the Automatic Diagnostic Repository since 11g)

Automatic Diagnostic Repository

Mount Point	Directory	Owner	Description
	[/app]/oracle/diag	oracle	All directories below are created automatically by Oracle
	[/app]/grid/diag	grid	All directories below are created automatically by Grid

Database file directories

Datafiles

Mount Point	Directory	Owner	Description
/u02- /u09 Drive: Win.	/oradata	Oracle	All directories below are created automatically by Oracle
	/oradata/DB1 /oradata/DB2	Oracle	Database files directory for DB1 Database files directory for DB2

Flash recovery area

Mount Point	Directory	Owner	Description
/u97 Drive: Win.	/flash_recovery_area – 10g /fast_recovery_area – 11g /fast_recovery_area – 12c	oracle	All directories below are created automatically by Oracle New naming convention “fast” instead “flash” starting with Oracle 11gR2
	/fast_recovery_area/DB1_SITE1 /fast_recovery_area/DB2_SITE1	Oracle	Flashback Recovery Area for DB1 Flashback Recovery Area for DB2

Backup

Mount Point	Directory	Owner	Description
/u98 Drive: Win.	[/app]/oracle/admin/DB1/backup	oracle	Physical location of the backup directory for DB1. This directory is soft linked to /u01/app/oracle/admin/DB1/back up. Directory only used if no FRA or no media manager is in use (backup disk)

Dump

Mount Point	Directory	Owner	Description
/u98 Drive: Win.	[/app]/oracle/admin/DB1/dmp	oracle	Physical location of the datapump exported files. This directory is soft linked to/u01/app/oracle/admin/DB1/d mp

Archive

Mount Point	Directory	Owner	Description
/u97 Drive: Win.	[/app]/oracle/admin/DB1/arch	oracle	Physical location of the archive directory for Oracle 10gR2 only Databases. This directory is soft linked to /u01/app/oracle/admin/DB1/arch For Oracle 11gR2 we recommend to use the FRA for archive log destination.

Block change tracking

Mount Point	Directory	Owner	Description
/u02- /u09 Drive: Win.	[/app]/oradata	oracle	Block change tracking file must be created into the same directory structure as the datafiles.

.