E Directory Structure for Oracle Database 10g Real Application Clusters Environments

This appendix describes the directory structures for Real Application Clusters (RAC) software environments. The topics in this appendix are:

Understanding the Real Application Clusters Directory Structure
UNIX Directory Structures for Real Application Clusters
Windows Directory Structures for Real Application Clusters

Understanding the Real Application Clusters Directory Structure

When you install Oracle Database 10g with RAC, all subdirectories are under a top-level ORACLE_BASE. The ORACLE_HOME and admin directories are also located under ORACLE_BASE.

UNIX Directory Structures for Real Application Clusters

Table E-1 shows the hierarchical directory tree of a sample OFA-compliant database for RAC on UNIX-based systems:

Table E-1 Directory Structure for A Sample OFA-Compliant UNIX Environment

Root	Second-Level	Third-Level	Fourth-Level	Fifth-Level
$ORACLE_BASE				`/u01/app/oracle` The default ORACLE_BASE directory.
	ORACLE_HOME			`/product/10.1` The default name of the Oracle home.
	`/admin`			Administrative directory.
		`/db_unique_name`		Database unique name, the same as `dbname` when database name is eight or fewer characters in length.
			`/bdump` `/cdump` `/hdump` `/pfile` `/udump`	Dump destinations for database server.
	`CRS Home`			`/crs/10.1` The default name of the CRS home.
		`/bin`		Subtree for Oracle binaries.
		`/network`		Subtree for Oracle Net.

Windows Directory Structures for Real Application Clusters

Table E-2 shows the hierarchical directory tree of a sample OFA-compliant database for RAC on Windows-based systems:

Table E-2 Directory Structure for A Sample OFA-Compliant Windows Environment

Root	Second-Level	Third-Level	Fourth-Level	Fifth-Level
x:\oracle_base				`c:\oracle` The default `ORACLE_BASE` directory.
	\%ORACLE_HOME%			`\ora10.1` The name of the Oracle home by default.
	\%ORA_CRS_HOME%			`\crs10.1` The name of the CRS home by default.
		\bin		Subtree for Oracle binaries.
		\network		Subtree for Oracle Net configuration files, including `tnsnames.ora,` listener.ora and `sqlnet.ora.`
		\srvm		`\admin` subdirectory.
			`\`admin	The RAC script `clustdb.sql` and initialization parameter files for database creation
		\database		A directory from previous releases containing initialization files pointing to the new directory location for parameter files: `ORACLE_BASE\admin\db_name\pfile`.
	\admin			Subtree for RAC database administration files
		\db_name		`db_name` database administration files for the instance identified by `sid`.
			\adhoc	Ad hoc SQL scripts.
			\adump	Audit files.
			\arch	Archived redo log files.
			\bdump	Background process trace files.
			\cdump	Core dump files.
			\create	Programs used to create the database.
			\exp	Database export files
			\pfile	Initialization parameter files
			\udump	User SQL trace files