HP OpenView System Administration Handbook [Electronic resources] : Network Node Manager, Customer Views, Service Information Portal, HP OpenView Operations

18.4 DATABASE files AND DIRECTORY LOCATIONS

Oracle recommends following a standard called

Optimal Flexible Architecture (OFA) for installation, configuration, location, naming and layout of the database objects, files and directories.

OFA is designed to:

• Organize large amounts of complicated software and data on disk to avoid device bottlenecks and poor performance

• Facilitate routine administrative tasks, such as software and data backup, which are often vulnerable to data corruption

• Facilitate switching between multiple Oracle databases

• Adequately manage and administer database growth

• Help eliminate fragmentation of free space in the data dictionary, isolate other fragmentation, and minimize resource contention

Refer to Appendix C, "Resources," for more information on OFA.

The installation of the database files follows the environment variables configured before installation of the database. During installation, a check to confirm the location of the files is performed. The following directories are under the directory path $ORACLE_HOME/product/<db_version>:

Bin Binary for all products

Dbs Database files, init<SID>.ora, and sql.bsq script

Lib Oracle product libraries

Orainst Installation files and programs

Rdbms Server files, scripts, and libraries required for the database

Plsql PL/SQL, procedural option

Sqlplus SQL*Plus

Network Oracle Net8 (in version 8.X)/SQL*Net ( in version 7.x)

Svrmgrl Server Manager

Admin Administrative scripts

Demo Demonstration scripts and data files

Doc README files

Install Product installation scripts

Lib Product libraries

Log Log files