A
Directory Structure

Specific topics covered in this appendix are:

• Understanding the 8.1.3 Database Directory Trees
• Oracle8i Parallel Server Directory Structure

 

Understanding the Database Directory Trees

When you install Oracle8 Enterprise Edition and the Oracle8i Parallel Server Option, all subdirectories are no longer under a top level ORACLE_HOME directory. There is now a new top level directory called 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.

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

X:\ORACLE_BASE				C:\ORACLE is the ORACLE_BASE directory
	\ORACLE_HOME			\ORA81 is the name of the Oracle home by default
		\BIN		subtree for Oracle binaries
		\NETWORK		subtree for Net8
		\OPS		Files necessary for Oracle Database Configuration Assistant or manual configuration.
		\.		Files necessary for Oracle Database Configuration Assistant or manual configuration.
	\ADMIN\PARALLEL_SERVER			subtree for database administration files
		\DB_NAME1\SID1		DB_NAME1 database administration files for the instance identified by SID. The first DB_NAME is OP.
			\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
		\DB_NAME1\SID2	\...	DB_NAME1 database administration files for the instance identified by SID2. Subsequent DB_NAMEs after OP are O[A-O, R-Z].
		\DB_NAME2\SID1	\...	DB_NAME2 database administration files for the instance identified by SID1.

\DB_NAME is the unique name for a particular database and has the same value as the DB_NAME parameter in the INITDB_NAME.ORA file or INIT_COM.ORA file. DB_NAME distinguishes each of your databases in the \ADMIN and \ORADATA directories. \SID in the name associated with the instance and has the same values as INSTANCE_NAME in INITSID.ORA.

Oracle8i Parallel Server Directory Structure

The following sections describe the contents of the subdirectories of ORACLE_BASE:

• ORACLE_HOME
• ADMIN

 

 

Additional Information: See Chapter 6, "Using Multiple Oracle Homes", of the Oracle8i Enterprise Edition Getting Started.

ORACLE_HOME

If you install Oracle8 Enterprise Edition with the Typical installation type and with all of the available cartridges and options, the following directories are created. If you install additional Oracle products, other subdirectories are also created.

Directory	Contents
\A2OWIZ81	Oracle Migration Assistant for Microsoft Access files
\ASSISTANTS	Oracle8 assistants
\BIN	Executable files
\CTX	Oracle8 ConText Cartridge files. \CTX contains the following subdirectories:
\DATABASE	This is a legacy directory from previous releases. It contains initialization parameter files that point to the new directory locations for the database files.
\DBS	Oracle Toolkit II message files, SQL scripts, and other utility files
\DOC	HTML documentation library
\INSTALL	Files used by Oracle Universal Installer
\JLIB	Java files used by various applications
\MD	Oracle8 Spatial Cartridge files.
\MSHELP	Help files
\NETWORK	Net8 files.
\OCI	Oracle Call Interface files.
\ODBORA32	Oracle8 ODBC files
\OO4O	Oracle Objects for OLE files.
\OPS	Files necessary for Oracle Database Configuration Assistant or manual configuration. \OPS contains the following sub-directories:
\DBCA	*.TBL files for SETLINKS for configuration of Oracle8i Parallel Server using Oracle Database Configuration Assistant.
\MANUAL	Oracle8i Parallel Server SQL scripts, *.TBL files for SETLINKS, and initialization files for manual configuration of Oracle8i Parallel Server.
\OPSM	Oracle8i Parallel Server Option files
\ORACORE	Oracle8 database message files
\ORD	Object data cartridges files.
\OTRACE	Oracle Trace files
\PLSQL	SQL scripts, sample files, and message files for PL/SQL
\PRECOMP	Precompiler files
\RDBMS	Oracle8 Server files. The \ADMIN sub-directory contains Oracle8 database SQL scripts. Use SQL scripts to create data dictionary tables and views, and other views used by Oracle software.
\SQLPLUS	SQL*Plus files

ADMIN

Database administration files are stored in subdirectories of ORACLE_BASE\ADMIN\PARALLEL_SERVER\DB_NAME\SID.

The following table describes the subdirectories:

Directory	Contents
\ADHOC	Ad hoc SQL scripts
\ARCH	Archived redo log files
\BDUMP	Background process trace files
\CDUMP	Core dump files
\CREATE	Log files created from Oracle Database Configuration Assistant usages
\EXP	Database export files
\PFILE	Initialization parameter files
\UDUMP	User SQL trace files