A
Directory Structure for Real Application Clusters Environments

Appendix A describes the directory structure for Oracle Real Application Clusters software environments. Specific topics covered in this appendix are:

Understanding the Real Application Clusters Directory Structure

When you install Oracle9i Enterprise Edition and Oracle9i Real Application Clusters, 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 A-1 shows the hierarchical directory tree of a sample OFA-compliant database for Real Application Clusters on UNIX platforms:

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

Root	Second-Level	Third-Level	Fifth-Level
$ORACLE_BASE			`/u01/app/oracle` The default ORACLE_BASE directory
	$ORACLE_HOME		`/product/9.2` The name of the Oracle home by default
		`/bin`	Subtree for Oracle binaries
		`/network`	Subtree for Oracle Net

See Also:

Oracle9i Administrator's Reference for your UNIX operating system for further information about the $ORACLE_HOME and /admin directories

Windows Directory Structures for Real Application Clusters

Table A-2 shows the hierarchical directory tree of a sample OFA-compliant database for Real Application Clusters on Windows NT and Windows 2000:

Table A-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%`			`\ora9.2` The name of the Oracle 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 Real Application Clusters script `clustdb.sql` and initialization parameter files for database creation
		`\database`		This is a legacy directory from previous releases. It contains initialization files that point to the new directory location for the initialization parameter files, `ORACLE_BASE\admin\db_name\pfile`.
	`\admin`			Subtree for Real Application Clusters 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

Shared Oracle Homes in Real Application Clusters

If the Oracle home location is shared (through NFS or any other equivalent facility) by each node, set up Oracle Intelligent Agent as follows:

Install Oracle Intelligent Agent for each node in its own Oracle home location, distinct from the shared Oracle home location.

Note:
You cannot install the Intelligent Agent in the same shared Oracle home location where your Oracle database is located.
Copy or link tnsnames.ora and listener.ora to each Oracle Intelligent Agent's Oracle home location from the shared Oracle home.
Before starting Oracle Intelligent Agent on each node, set the Oracle home location to Oracle Intelligent Agent's Oracle home.
Issue the agentctl start command. Ensure that the Agent, or the DBSNMP utility, is set up to run at system startup time.

See Also:
Oracle Intelligent Agent User's Guide for information about the Oracle Intelligent Agent

A Directory Structure for Real Application Clusters Environments