Oracle7 Administrator's Reference for UNIX

Directory Structure

This section lists the directory structure and contents for an Oracle7 installation.

ORACLE_BASE Directory

ORACLE_BASE is the root of the Oracle directory structure. If you install an OFA-compliant database using the Oracle Installer defaults, $ORACLE_BASE is /mount_point/app/oracle.

admin administrative files
doc online documentation
product Oracle software

ORACLE_HOME Directory

If you install an OFA-compliant Oracle Server, the ORACLE_HOME directory is /mount_point/app/oracle/product/release_number. Under UNIX, the ORACLE_HOME directory contains the following subdirectories, as well as a subdirectory for each Oracle product:

bin binaries for all products
dbs initsid.ora and sql.bsq files, and database datafiles
lib Oracle product libraries
orainst master installation files and programs
rdbms server files and libraries required for the database
otrace Oracle TRACE
ows Oracle WebServer

Oracle Product Subdirectories

Product subdirectories may include the following, depending on the Oracle products available on your platform and the products you purchase:

dntpa SQL*Net version 2 DECnet Protocol Adapter
guicommon2 libraries, resource files, scripts, and message files used by several GUI products
lu62pa SQL*Net version 2 APPC/LU6.2 Protocol Adapter
network SQL*Net version 2
mod SQL*Module
ocommon libraries and SQL messages. All products depend on this directory, which is installed automatically
plsql PL/SQL version 2, procedural option
proada Pro*Ada
procob Pro*COBOL
profor Pro*FORTRAN
propas Pro*Pascal
pso install scripts from Oracle Parallel Server option
spxpa SQL*Net version 2 SPX/IPX Protocol Adapter
sqlplus SQL*Plus
svrmgr Server Manager
tcppa SQL*Net version 2 TCP/IP Protocol Adapter
tk2 link to the Toolkit II directory, guicommon/tk2

Contents of Product Subdirectories

Each product subdirectory contains the following subdirectories:

admin administrative SQL and shell scripts (for example, catalog.sql, catexp.sql, and demo.sql)
admin/* special directories for other products
admin/resource resource files
admin/terminal runtime terminal files
demo demonstration scripts and datafiles
doc README files (for example, readmeunix.doc)
install product installation scripts
lib product libraries and distributed makefiles
log trace files and log files (for example, orasrv.log and *.trc files)
mesg U.S. message files, and Multilingual Option (formerly National Language Support) message text and binary files (for example, oraus.msg and oraus.msb)

Examples of product subdirectories and their contents are:

proc install, demo, lib
rdbms install, lib, admin, doc, mesg, log
sqlplus install, demo, lib, admin
tcp install, lib

File Naming Conventions in the admin Directory

The rdbms/admin directory has the following SQL scripts:

cat*.sql creates catalog and data dictionary tables and views. The following files are run automatically during installation: catalog.sql (for all installations) catproc.sql (for procedural option installations) catparr.sql (for Parallel Server option installations)
dbms*.sql additional database packages
utl*.sql creates tables and views for database utilities

Filename Extensions

The filename extensions are:

.a object file libraries; Ada runtime libraries
.ada Ada source files
.aud Oracle audit file
.bdf X11 font description file
.bmp X11 bitmap file
.c C source file
.ctl SQL*Loader control file; Oracle Server control file
.dat SQL*Loader datafile
.dbf Oracle Server tablespace file
.dei ORCA de-installation script
.dmp Export file
.doc ASCII text file
.env shell script file for setting environment
.f FORTRAN source file
.h C header file; also, sr.h is a SQL*Report Writer help file
.ins ORCA installation script
.l UNIX manual page
.lis output of SQL*Plus scripts
.log installation log files; Oracle Server redo log files
.map Installer product component files
.mk make files
.msb NLS message file (binary)
.msg NLS message file (text)
.o object module
.ora init.ora file; lisnr.ora file; kbcus.ora file
.orc installation prototype files
.pad Pro*Ada source file
.pc Pro*C source file
.pco Pro*COBOL source file
.ppd printer driver file
.pfo Pro*FORTRAN source file
.prd product registration template file (for orainst)
.res Toolkit II resource file
.sh Bourne shell script file
.sql SQL* script files
.sys Bourne shell script file
.tab SQL* script file
.tut Bourne shell script file
.us orainst message file
.utd Uniform Terminal Definitions
.vrf Installer dependencies verification script

admin	administrative files
doc	online documentation
product	Oracle software

bin	binaries for all products
dbs	initsid.ora and sql.bsq files, and database datafiles
lib	Oracle product libraries
orainst	master installation files and programs
rdbms	server files and libraries required for the database
otrace	Oracle TRACE
ows	Oracle WebServer

dntpa	SQL*Net version 2 DECnet Protocol Adapter
guicommon2	libraries, resource files, scripts, and message files used by several GUI products
lu62pa	SQL*Net version 2 APPC/LU6.2 Protocol Adapter
network	SQL*Net version 2
mod	SQL*Module
ocommon	libraries and SQL messages. All products depend on this directory, which is installed automatically
plsql	PL/SQL version 2, procedural option
proada	Pro*Ada
procob	Pro*COBOL
profor	Pro*FORTRAN
propas	Pro*Pascal
pso	install scripts from Oracle Parallel Server option
spxpa	SQL*Net version 2 SPX/IPX Protocol Adapter
sqlplus	SQL*Plus
svrmgr	Server Manager
tcppa	SQL*Net version 2 TCP/IP Protocol Adapter
tk2	link to the Toolkit II directory, guicommon/tk2

admin	administrative SQL and shell scripts (for example, catalog.sql, catexp.sql, and demo.sql)
admin/*	special directories for other products
admin/resource	resource files
admin/terminal	runtime terminal files
demo	demonstration scripts and datafiles
doc	README files (for example, readmeunix.doc)
install	product installation scripts
lib	product libraries and distributed makefiles
log	trace files and log files (for example, orasrv.log and *.trc files)
mesg	U.S. message files, and Multilingual Option (formerly National Language Support) message text and binary files (for example, oraus.msg and oraus.msb)

proc	install, demo, lib
rdbms	install, lib, admin, doc, mesg, log
sqlplus	install, demo, lib, admin
tcp	install, lib

*cat.sql**	creates catalog and data dictionary tables and views. The following files are run automatically during installation: catalog.sql (for all installations) catproc.sql (for procedural option installations) catparr.sql (for Parallel Server option installations)
*dbms.sql**	additional database packages
*utl.sql**	creates tables and views for database utilities

.a	object file libraries; Ada runtime libraries
.ada	Ada source files
.aud	Oracle audit file
.bdf	X11 font description file
.bmp	X11 bitmap file
.c	C source file
.ctl	SQL*Loader control file; Oracle Server control file
.dat	SQL*Loader datafile
.dbf	Oracle Server tablespace file
.dei	ORCA de-installation script
.dmp	Export file
.doc	ASCII text file
.env	shell script file for setting environment
.f	FORTRAN source file
.h	C header file; also, sr.h is a SQL*Report Writer help file
.ins	ORCA installation script
.l	UNIX manual page
.lis	output of SQL*Plus scripts
.log	installation log files; Oracle Server redo log files
.map	Installer product component files
.mk	make files
.msb	NLS message file (binary)
.msg	NLS message file (text)
.o	object module
.ora	init.ora file; lisnr.ora file; kbcus.ora file
.orc	installation prototype files
.pad	Pro*Ada source file
.pc	Pro*C source file
.pco	Pro*COBOL source file
.ppd	printer driver file
.pfo	Pro*FORTRAN source file
.prd	product registration template file (for orainst)
.res	Toolkit II resource file
.sh	Bourne shell script file
.sql	SQL* script files
.sys	Bourne shell script file
.tab	SQL* script file
.tut	Bourne shell script file
.us	orainst message file
.utd	Uniform Terminal Definitions
.vrf	Installer dependencies verification script