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