A
Directory Structures

This appendix describes the default directory structures created when you install Oracle8i components.

Specific topics discussed are:

• Oracle8i Directory Structure

• Oracle8i Client Directory Structure

• Filename Extensions

  See: Chapter 3, "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.Oracle Enterprise Manager Administrator's Guide for directory structures for those products.

Oracle8i Directory Structure

ORACLE_BASE is the root of the Oracle directory tree.

Oracle Universal Installer places Oracle 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. Database files are stored in ORACLE_BASE\ORADATA\DB_NAME.

See: Oracle8i Installation Guide for Windows NT for the database files stored in ORACLE_BASE\ORADATA\DB_NAME.

The following sections describe these directories in ORACLE_BASE:

• ORACLE_HOME

• ADMIN

ORACLE_HOME

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

Directory	Contents
\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
\CLASSES	Oracle Enterprise Manager files
\COM	Oracle COM Automation feature 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.
\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
LDAP	Directory Server files
\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
\ODBC	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 files
\ORACORE	Message files
\ORD	Data option files. \ORD contains the following subdirectories:
\ADMIN	SQL scripts
\AUD	Oracle interMedia Audio files
\IM	Oracle interMedia 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
\JLIB	Java libraries for Oracle options
\OTRACE	Oracle Trace files. \OTRACE contains the following subdirectories:
\ADMIN	Administration files, including SQL scripts
\DEMO	Sample programs
\LIB	Library files
\MESG	Message files
\PUBLIC	Header files
\OWM	Oracle Wallet Manager files*
\PLSQL	SQL scripts, sample files, and message files for PL/SQL
\PRECOMP	Precompiler 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.
\EXTPROC	External procedure 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
\SVRMGL	Server Manager files
\SYSMAN	Oracle Enterprise Manager files

*Not included if you install Oracle8i for Windows NT.

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)

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.

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

Directory	Contents
\ASSISTANTS	Oracle assistants
\BIN	Executable files
\DOC	HTML documentation library
\JAVAVM	Java Virtual Machine files
\JDBC	Java Database Connectivity (JDBC) drivers files
\JLIB	Java files used by various applications
\LDAP	Files used by directory client libraries
\LIB	Java VM and EJB jar files
\MSHELP	Help files
\NETWORK	Net8 files
\OCI	Oracle Call Interface files. \OCI contains the following subdirectories:
\INCLUDE	Header files
\LIB	Library files
\SAMPLES	Sample files
\OCOMMON	NLS files
\ODBC	Oracle ODBC files
\OLEDB	OLE DB files
\OO4O	Oracle Objects for OLE 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
\IM	Oracle interMedia files
\JLIB	Java libraries for Oracle options
\TRACE	Oracle Trace files
\OWM	Oracle Wallet Manager files
\PLSQL	Message files for PL/SQL
\PRECOMP	Precompiler files
\RDBMS	Oracle Server files
\RELNOTES	Release Notes
\SLAX	Message files
\SQLJ	SQLJ files
\SQLPLUS	SQL*Plus files

Filename Extensions

A description of filename extensions is shown below.

Extension	Description
.aud	Oracle audit file
.bmp	bitmap file
.c	C source file
.ctl	SQL*Loader control file; Oracle Server control file
.dat	SQL*Loader datafile
.dbf	Oracle Server tablespace file
.dmp	Export file
.doc	ASCII text file
.h	C header file; also, sr.h is a SQL*Report Writer help file
.jar	Java class archive
.lis	output of SQL*Plus scripts
.log	installation log files; Oracle Server redo log files
.mk	make files
.msb	NLS message file (binary)
.msg	NLS message file (text)
.o	object module
.ora	Oracle configuration files
.pc	Pro*C source file
.pco	Pro*COBOL source file
.sql	SQL* script files
.tab	SQL* script file
.trc	trace files

---