A
Directory Structures

This appendix describes the default directory structures created when you install Oracle8i Enterprise Edition, Oracle8i Client, or Oracle Programmer, and Net8.

Specific topics discussed:

• Oracle8i Enterprise Edition Directory Structure
• Oracle8i Client Directory Structure
• Oracle Programmer Directory Structure
• Net8 Directory Structure

Oracle8i Enterprise Edition Directory Structure

ORACLE_BASE is the root of the Oracle directory tree.

Oracle Universal Installer places Oracle8i Enterprise Edition products into the \ORACLE_HOME, \ADMIN, and \ORADATA directories of ORACLE_BASE.

The \ADMIN and \ORADATA directories contain one or more \DB_NAME directories. DB_NAME is the unique name for a database and has the same value as the DB_NAME parameter in the INIT.ORA file.

Additional Information: See Chapter 4, "Multiple Oracle Homes and Optimal Flexible Architecture" for more information on Oracle homes and OFA. See especially "Directory Tree of a Sample OFA-Compliant Database" for a depiction of how the default OFA-compliant directory tree is organized.

The following sections describe the directories in ORACLE_BASE:

• ORACLE_HOME
• ADMIN
• ORADATA

 

ORACLE_HOME

If you install Oracle8i Enterprise Edition with the Typical installation type, the following directories are created. If you install additional Oracle products, other directories are also created.

Directory	Contents
\A2OWIZ	Oracle Migration Assistant for Microsoft Access files
\ASSISTANTS	Oracle assistants. \ASSISTANTS contains the following subdirectories:
\DBCA	Oracle Database Configuration Assistant files
\DBMA	Oracle Data Migration Assistant files
\IFA	Oracle INTYPE File Assistant files
\JLIB	Java files used by the assistants
\OWAST	Oracle Web Publishing Assistant files
\BIN	Executable files
\COM	Oracle COM Automation option files
\CTX	Oracle interMedia Text files. \CTX contains the following subdirectories:
\ADMIN	SQL scripts for installation and configuration, and header and body files for PL/SQL packages
\BIN	Executable files
\DEMO	Empty
\DOC	Release notes
\LIB	Library files
\MESG	Message files
\DATA	Data files
\LOG	Log file default directory
\MIGRATE	Migration scripts
\SAMPLE	Sample thesauri
\DATABASE	This is a legacy directory from previous releases. It contains an initialization parameter file that points to the new directory location for initialization parameter files.
\DBS	Oracle for Windows NT Performance Monitor files and other utility files
\DOC	HTML documentation library
\JAVAVM	Java Virtual Machine files. \JAVAVM contains the following subdirectories:
\DEMO	Sample programs
\INSTALL	SQL scripts
\JDBC	Java Database Connectivity (JDBC) drivers files. \JDBC contains the following subdirectories:
\ADMIN	Class files
\DEMO	Sample programs
\JLIB	Java files used by various applications
\MD	Oracle Spatial files. \MD contains the following subdirectories:
\ADMIN	SQL scripts
\DOC	Release notes
\LIB	Library files
\MSHELP	Help files
\NETWORK	Net8 files. \NETWORK contains the following subdirectories:
\ADMIN	Configuration files
\AGENT	Oracle Intelligent Agent files
\DOCS	Release notes
\JLIB	Java files used by Net8 assistants
\LOG	Log files (default location)
\MESG	Message files
\TNSAPI	Net8 Open API-related files
\TOOLS	Net8 assistant files
\TRACE	Trace files (default location)
\OCI	Oracle Call Interface files. \OCI contains the following subdirectories:
\INCLUDE	Header files
\LIB	Library files
\SAMPLES	Sample files
\OCOMMON	NLS files
\ODBORA32	Oracle ODBC files
\OO4O	Oracle Objects for OLE files. \OO4O contains the following subdirectories:
\CPP	Header files, library files, and sample files
\EXCEL	Microsoft Excel sample files
\IIS	Internet Information Server sample files
\MESG	Message files
\VB	Visual Basic sample files
\OPSM	Oracle Parallel Server option files
\ORACORE	Message files
\ORD	Data option files. \ORD contains the following subdirectories:
\ADMIN	SQL scripts
\AUD	Oracle interMedia Audio files
\IMG	Oracle interMedia Image files
\MESG	Message files
\TS	Oracle Time Series files
\VID	Oracle interMedia Video files
\VIR	Oracle Visual Information Retrieval files
\OTRACE	Oracle Trace files. \OTRACE contains the following subdirectories:
\ADMIN	Administration files, including SQL scripts
\LIB	Library files
\MESG	Message files
\PUBLIC	Header files
\PLSQL	SQL scripts, sample files, and message files for PL/SQL
\PRECOMP	Precompiler files. \PRECOMP contains the following subdirectories:
\ADMIN	Configuration files
\DOC	Release notes
\MESG	Message files
\RDBMS	Oracle Server files. \RDBMS contains the following subdirectories:
\ADMIN	Oracle database SQL scripts (including CATALOG.SQL and CATPROC.SQL). Use SQL scripts to create data dictionary tables and views, and other views used by Oracle software.  Additional Information: See Chapter 5, "SQL Scripts" in Oracle8i Reference.
\AQ	Advanced Queuing sample files
\EXTPROC	External procedure sample files
\LOADER	SQL*Loader sample files
\MESG	Message files
\XA	Oracle XA files
\SQLJ	Oracle SQLJ Translator files. \SQLJ contains the following subdirectories:
\DEMO	Sample programs
\DOC	Release notes, white papers, package descriptions, the SQLJ specification, and the Oracle SQLJ Developer's Guide and Reference
\LIB	Class files and a SQL script
\SQLPLUS	SQL*Plus files. \SQLPLUS contains the following subdirectories:
\ADMIN	SQL scripts for administering SQL*Plus
\DEMO	SQL scripts for sample tables
\DOC	Release notes
\MESG	Message files
\WMT	Oracle Wallet Manager files

ADMIN

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

The following table describes these subdirectories.

Directory	Contents
\ADHOC	Ad hoc SQL scripts
\BDUMP	Background process trace files (default location)
\CDUMP	Core dump files
\CREATE	Database creation files
\EXP	Database export files
\PFILE	Initialization parameter files
\UDUMP	User process trace files (default location)

ORADATA

Database files are stored in ORACLE_BASE\ORADATA\DB_NAME.

The following table describes the database files.

File	Description
CONTROL01.CTL	Control file 1
CONTROL02.CTL	Control file 2
INDX01.DBF	INDX tablespace data file
OEMREP01.DBF	Repository for Oracle Enterprise Manager
RBS01.DBF	RBS tablespace data file
SYSTEM01.DBF	SYSTEM tablespace data file
TEMP01.DBF	TEMP tablespace data file
USERS01.DBF	USERS tablespace data file
REDO01.LOG	Redo log file group 1, member 1
REDO02.LOG	Redo log file group 2, member 1
REDO03.LOG	Redo log file group 3, member 1
REDO04.LOG	Redo log file group 4, member 1

Oracle8i Client Directory Structure

ORACLE_BASE is the root of the Oracle directory tree.

Oracle Universal Installer places Oracle8i Client products into the \ORACLE_HOME directory of ORACLE_BASE.

The following section describes the ORACLE_HOME directory.

If you install Oracle8i Client with the typical installation type, the following ORACLE_HOME directories are created.

Directory	Contents
\A2OWIZ	Oracle Migration Assistant for Microsoft Access files
\ASSISTANTS	Oracle assistants. \ASSISTANTS contains the following subdirectories:
\IFA	Oracle INTYPE File Assistant files
\JLIB	Java files used by the assistants
\OWAST	Oracle Web Publishing Assistant files
\BIN	Executable files
\DBS	Message files and SQL scripts
\DOC	HTML documentation library
\JDBC	Java Database Connectivity (JDBC) drivers files. \JDBC contains the following subdirectory:
\ADMIN	Class files
\JLIB	Java files used by various applications
\NETWORK	Net8 files. \NETWORK contains the following subdirectories:
\ADMIN	Configuration files
\DOCS	Release notes
\JLIB	Java files used by Net8 assistants
\LOG	Log files (default location)
\MESG	Message files
\TNSAPI	TNS API files
\TOOLS	Net8 assistant files
\TRACE	Trace files (default location)
\OCI	Oracle Call Interface files. \OCI contains the following subdirectories:
\INCLUDE	Header files
\LIB	Library files
\SAMPLES	Sample files
\OCOMMON	NLS files
\ODBORA32	Oracle ODBC files
\OO4O	Oracle Objects for OLE files. \OO4O contains the following subdirectories:
\CPP	Header files, library files, and sample files
\EXCEL	Microsoft Excel sample files
\IIS	Internet Information Server sample files
\MESG	Message files
\VB	Visual Basic sample files
\ORACORE	Message files
\OTRACE	Oracle Trace files. \OTRACE contains the following subdirectories:
\ADMIN	Administration files, including SQL scripts
\LIB	Library files
\MESG	Message files
\PUBLIC	Header files
\PLSQL	Message files for PL/SQL
\PRECOMP	Precompiler files. \PRECOMP contains the following subdirectories:
\ADMIN	Configuration files
\DOC	Release notes
\MESG	Message files
\RDBMS	Oracle Server files. \RDBMS contains the following subdirectories:
\ADMIN	Administration files
\MESG	Message files
\SQLPLUS	SQL*Plus files. \SQLPLUS contains the following subdirectories:
\ADMIN	SQL scripts for administering SQL*Plus
\DEMO	SQL scripts for sample tables
\DOC	Release notes
\MESG	Message files

Oracle Programmer Directory Structure

ORACLE_BASE is the root of the Oracle directory tree.

Oracle Universal Installer places Oracle Programmer products into the \ORACLE_HOME directory of ORACLE_BASE.

If you install the Oracle Programmer with the Typical installation type, the following ORACLE_HOME directories are created.

Directory	Contents
\ASSISTANTS	Oracle assistants. \ASSISTANTS contains the following subdirectories:
\IFA	Oracle INTYPE File Assistant files
\JLIB	Java files used by the assistants
\BIN	Executable files
\DBS	Message files and SQL scripts
\DOC	HTML documentation library
\JDBC	Java Database Connectivity (JDBC) drivers files. \JDBC contains the following subdirectory:
\ADMIN	Class files
\JLIB	Java files used by various applications
\NETWORK	Net8 files. \NETWORK contains the following subdirectories:
\ADMIN	Configuration files
\DOCS	Release notes
\JLIB	Java files used by Net8 assistants
\LOG	Log files (default location)
\MESG	Message files
\TNSAPI	TNS API files
\TOOLS	Net8 assistant files
\TRACE	Trace files (default location)
\OCI	Oracle Call Interface files. \OCI contains the following subdirectories:
\INCLUDE	Header files
\LIB	Library files
\SAMPLES	Sample files
\OCOMMON	NLS files
\ODBORA32	Oracle ODBC files
\OO4O	Oracle Objects for OLE files. \OO4O contains the following subdirectories:
\CPP	Header files, library files, and sample files
\EXCEL	Microsoft Excel sample files
\IIS	Internet Information Server sample files
\MESG	Message files
\VB	Visual Basic sample files
\ORACORE	Message files
\OTRACE	Oracle Trace files. \OTRACE contains the following subdirectories:
\ADMIN	Administration files, including SQL scripts
\LIB	Library files
\MESG	Message files
\PUBLIC	Header files
\PLSQL	Message files for PL/SQL
\PRECOMP	Precompiler files. \PRECOMP contains the following subdirectories:
\ADMIN	Configuration files
\DEMO	Sample programs
\DOC	Release notes
\LIB	Library files
\MESG	Message files
\PUBLIC	Header files
\RDBMS	Oracle Server files. \RDBMS contains the following subdirectories:
\ADMIN	Administration files
\MESG	Message files
\SQLPLUS	SQL*Plus files. \SQLPLUS contains the following subdirectories:
\ADMIN	SQL scripts for administering SQL*Plus
\DEMO	SQL scripts for sample tables
\DOC	Release notes
\MESG	Message files

Net8 Directory Structure

This subsection describes the directory structure and content of Net8 files. If you find that you are missing any of the listed files, try reinstalling by using the Custom Installation option on your Oracle Universal Installer to locate and reinstall only those files.

When you use the typical installation option, Oracle Universal Installer places all Net8 products into subdirectories of ORACLE_HOME.

Directory Name	Contents
\NETWORK	Message files and subdirectories for Net8 products. \NETWORK contains the following subdirectories:
\ADMIN	Configuration files
\AGENT	OEM Intelligent Agent
\DOCS	Readme, Release notes
\JLIB	Java files used by Net8 assistants
\LOG	Log files placed here by default
\MESG	Message files
\TNSAPI	TNS API library file
\TOOLS	Help files
\TRACE	Trace files (default location)
\Names	Scripts to create OracleNames tables in the database, local cache files of Oracle Names information, and a list of Oracle Name Servers (SDNS.ORA)

---