A
Directory Structure

Specific topics covered in this appendix are:

• Understanding the 8.1.6 Database Directory Trees

• Windows NT Directory Structure

Understanding the 8.1.6 Database Directory Trees

When you install Oracle8i Enterprise Edition and the Oracle Parallel Server Option with the Typical installation option, all subdirectories are under a top level ORACLE_BASE that is of the form X:\ORACLE where X is any hard drive. If you install an OFA-compliant database using Oracle Universal Installer defaults, ORACLE_BASE is C:\ORACLE.

\ORACLE_HOME directories are located under ORACLE_BASE. The \ADMIN and \OPS directories are also located under ORACLE_BASE.

Windows NT Directory Structure

The following is the hierarchical directory tree of a sample OFA-compliant database for Oracle Parallel Server:

C:\ORACLE_BASE				C:\ORACLE is the default ORACLE_BASE directory
	\ORACLE_HOME			\ORA81 is the name of the Oracle home by default
		\BIN		Subtree for Oracle binaries
		\NETWORK		Subtree for Net8 configuration files, including TNSNAMES.ORA, LISTENER.ORA and SQLNET.ORA
		\OPS		Files created by Oracle Database Configuration Assistant
		\OPSM		\ADMIN subdirectory
			\ADMIN	Oracle Parallel Server OPS.SQL script 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 Oracle Parallel Server 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