Skip Headers

Oracle9i Administrator's Reference
Release 1 (9.0.1) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel and Sun SPARC Solaris

Part Number A90347-02
Go To Table Of Contents
Go To Index

Go to previous page Go to next page

Optimal Flexible Architecture

This appendix contains information on the Optimal Flexible Architecture (OFA) standard. The OFA standard is a set of configuration guidelines created to ensure fast, reliable Oracle databases that require little maintenance. This appendix contains the following sections:

Optimal Flexible Architecture

Oracle Corporation recommends that you implement the OFA standard when you install and configure Oracle9i.

OFA is designed to:

Characteristics of an OFA-Compliant Database

This section describes characteristics of a database that complies with the OFA standard.

File System Organization

The file system is organized to enable easy administration for issues such as:

Distributed I/O Loads

I/O loads are distributed across enough disk drives to prevent performance bottlenecks.

Hardware Support

In most cases, investment in new hardware is not required to take advantage of the OFA standard.

Safeguards Against Drive Failures

By distributing applications across more than one drive, drive failures affect as few applications as possible.

Distribution of Home Directories

The following items can be distributed across more than one disk drive:

Integrity of Login Home Directories

You can add, move, or delete login home directories without having to revise programs that refer to them.

Independence of UNIX Directory Subtrees

Categories of files are separated into independent UNIX directory subtrees so that files in one category are minimally affected by operations on files in other categories.

Supports Concurrent Execution of Application Software

You can execute multiple versions of application software simultaneously, enabling you to test and use a new release of an application before abandoning the previous version. Transferring to a new version after an upgrade is simple for the administrator and transparent for the user.

Separates Administrative Information for Each Database

The ability to separate administrative information on one database from that of another ensures a reasonable structure for the organization and storage of administrative data.

Uses Consistent Database File Naming

Database files are named so that:

Separation of Tablespace Contents

Tablespace contents are separated to:

I/O Loads Tuned Across All Drives

I/O loads are tuned across all drives, including drives storing Oracle data in raw devices.

Additional Benefits of OFA for Oracle9i Real Application Clusters

For Oracle9i Real Application Clusters Installations:

Optimal Flexible Architecture Implemented on UNIX

This section describes the naming strategy recommended by the OFA standard.

Mount Points

This section describes the naming conventions for mount points.

Create Mount Points

An installation of Oracle9i requires at least two mount points: one for the software and at least one for the database files. To implement the OFA recommendations fully, Oracle9i requires at least four mount points: one for the software and at least three for database files.

Mount Point Syntax

Name all mount points using the syntax /pm, where p is a string constant and m is a unique fixed-length key (typically a two-digit number) used to distinguish each mount point. For example: /u01 and /u02, or /disk01 and /disk02.

Naming Mount Points for Very Large Databases (VLDBs)

If each disk drive contains database files from one application and there are enough drives for each database to prevent I/O bottlenecks, use the syntax /pm/q/dm for naming mount points. Table F-1 describes the variables used in this syntax.

Table F-1 Syntax for Naming Mount Points  
Variable  Description 


A mount point name 


A string denoting that Oracle data is stored in this directory 


The value of the initialization parameter DB_NAME (synonymous with the instance sid for single-instance databases) 

For example, mount points named /u01/oradata/test and /u02/oradata/test allocate two drives for the Oracle test database.

Naming Directories

This section describes the naming conventions for OFA compliant directories.

Home Directory Syntax

Name home directories using the syntax /pm/h/u. Table F-2 describes the variables used in this syntax.

Table F-2 Syntax for Naming Home Directories  
Variable  Description 


A mount point name 


A standard directory name 


The name of the owner of the directory 

For example, /u01/app/oracle is the Oracle software owner home directory (also referred to as the Oracle base directory, the default directory used by the installer) and /u01/app/applmgr is an Oracle applications software owner home directory.

Placing home directories at the same level in the UNIX file system is advantageous because it allows the collection of applications owner login home directories on different mount points to be referred to using the single pattern matching string, /*/app/*.

Referring to Pathnames

Refer to explicit pathnames only in files designed specifically to store them, such as the password file, /etc/passwd, and the Oracle oratab file. Refer to group memberships only in the /etc/group file.

Software Directories

To help fulfill the OFA feature of simultaneously executing multiple versions of application software, store each version of the Oracle9i Server software in a directory matching the pattern /pm/h/u/product/v.

Table F-3 describes the variables used in this syntax.

Table F-3 Syntax for Naming Oracle9i Server Software Directories  
Variable  Description 


A mount point name 


A standard directory name 


The name of the owner of the directory 


The version of the software 

For example, /u01/app/oracle/product/9.0.1 indicates the Oracle9i parent directory. Set the ORACLE_HOME environment variable to this directory.

Naming Subdirectories

To facilitate the organization of administrative data, Oracle Corporation recommends that you store database-specific administration files in subdirectories matching the pattern /h/admin/d/a/, where h is the Oracle software owner's home directory, d is the database name (DB_NAME), and a is a subdirectory for each of the database administration files. Table F-4 describes the database administration file subdirectories.

Table F-4 Subdirectories for Database Administration Files  
Subdirectory  Description 


Ad hoc SQL scripts for a particular database 


Archived redo log files 


Audit files
(Set the AUDIT_FILE_DEST initialization parameter to the adump directory. Clean out this subdirectory periodically.) 


Background process trace files 


Core dump files 


Programs used to create the database 


Database export files 


Files recording the status and history of the database 


Instance parameter files 


User SQL trace files 

For example, the adhoc subdirectory has the pathname /u01/app/oracle/admin/sab/adhoc/ if the adhoc subdirectory is part of the database named sab.

Naming Database Files

The following naming convention for database files ensures that they are easily identifiable:

File Type  File Naming Convention 

Control files 


Redo log files 




The following table describes this syntax:

Variable  Description 


A mount point name described previously in this chapter 


A string distinguishing Oracle data from all other files (usually named ORACLE or oradata) 


The value of the initialization parameter DB_NAME (synonymous with the instance sid for single-instance databases) 


An Oracle tablespace name 


A two-digit string 


Do not store files other than control files, redo log files, or datafiles associated with database d in the path /pm/q/d

Following this convention, you could produce, for example, a datafile with the name /u03/oradata/sab/system01.dbf, making it easy to see the database to which the file belongs.

Separate Segments With Different Requirements

Separate groups of segments with different lifespans, I/O request demands, and backup frequencies across different tablespaces.

Table F-5 describes the special tablespaces that the Database Configuration Assistant (DBCA) creates for each Oracle database. If you manually create a database, you must create the required tablespaces. These tablespaces are in addition to those required for application segments.

See Also:

For Information on creating tablespaces manually, see the Oracle9i Database Administrator's Guide. 

Table F-5 Special Tablespaces  
Tablespace  Required  Description 



Data dictionary segments 



Temporary segments 



Rollback segments 



Miscellaneous user segments 



Index associated with data in the USERS tablespace 



Repository for Oracle Enterprise Manager 



Oracle interMedia segment 

Creating these special tablespaces is effective because data dictionary segments are never dropped, and no other segments that can be dropped are allowed in the SYSTEM tablespace. Doing this ensures that the SYSTEM tablespace does not require a rebuild due to tablespace free-space fragmentation.

Because rollback segments are not stored in tablespaces holding applications data, the administrator is not blocked from taking an application's tablespace offline for maintenance. The segments are partitioned physically by type, and the administrator can record and predict data growth rates without using complicated tools.

Naming Tablespaces

Name tablespaces descriptively using a maximum of eight characters. Although Oracle9i tablespace names can be 30 characters long, portable UNIX filenames are restricted to 14 characters. The recommended standard for a datafile basename is tn.dbf, where t is a descriptive tablespace name and n is a two-digit string. Because the extension plus the two-digit string occupy a total of six characters, only eight characters remain for the tablespace name.

Descriptive names enable the datafile to be associated with the tablespace that uses it. For example, the names GLD and GLX might be used for the tablespaces storing General Ledger data and indices, respectively.


Do not embed reminders of the word "tablespace" in your tablespace names. Tablespaces are distinguishable by context, and names do not need to convey information on type. 

Exploiting the OFA Structure for Oracle Files

Table F-6 describes the syntax used for identifying classes of files.

Table F-6 Directory Structure Syntax for Identifying Classes of Files  
Directory Structure Syntax  Description 


User data directories 


User home directories 


User application software directories 


Oracle applications software subtrees 


Oracle software subtrees 


Oracle Server release 9.0.1 distribution files 


sab database administrative subtrees 


sab database archived log files 


Oracle data directories 


sab database files 


sab database redo log files 

OFA File Mapping

Table F-7 shows a hierarchical file mapping of a sample OFA-compliant database, including each file mount point, application, database, and tablespace. The filenames indicate the file type (control, log, or data).

Table F-7 Hierarchical File Mapping for OFA Installation  
Directory  Description 


Root mount point 


User data mount point 1 


Subtree for application software 


Home for oracle software user 


Subtree for database administration files 


Subtree for support log files 


admin subtree for db_name1 database 


admin subtree for db_name2 database 


Online documentation 


Distribution files 


Oracle home directory for release 8.1.6 instances 


Oracle home directory for release 8.1.7 instances 


Oracle home directory for release 9.0.1 instances 


Home directory for a user 


Home directory for a user 


Subtree for Oracle data 


Subtree for db_name1 database files 


Subtree for db_name2 database files 


User data mount point 2 


Subtree for login home directories 


Home directory for a user 


Home directory for a user 


Subtree for Oracle data 


Subtree for db_name1 database files 


Subtree for db_name2 database files 


User data mount point 3 


Subtree for Oracle data 


Subtree for db_name1 database files 


Subtree for db_name2 database files 

File Mapping for a Multiple-Instance OFA Database

When using the Oracle9i Real Application Clusters, select one node to act as the Oracle administrative home for the cluster. The administrative home contains the administrative subtree. Create subdirectories for each instance accessing the database within the bdump, cdump, logbook, pfile, and udump directories of the ~/admin/d/ directory. Mount the admin directory for the administrative home as the admin directory for every instance. Table F-10 shows a sample directory structure.

Table F-8 Administrative Directory Structure for Dual-Instance Oracle9i Real Application Clusters  
Directory Path  Description 


Administrative directory for sab database 


Directory for miscellaneous scripts 


Log archive destination for all instances 


Archived redo log file 


Directory for background dump files 


Background dump destination for inst1 instance 


Background dump destination for inst2 instance 


Directory for core dump files 


Core dump destination for inst1 instance 


Core dump destination for inst2 instance 


Directory for creation scripts 


SQL script to create inst database 


Directory for exports 


January 20, 2000 full export dump file 


Directory for export parfiles 


Directory for import parfiles 


Directory for logbook entries 


Directory for inst1 instance reports 


V$PARAMETER report for inst1 instances 


Directory for inst2 instances reports 


V$PARAMETER report for inst2 instances 


DBA_USERS report 


Directory for instance parameter files 


Directory for inst1 instance parameters 


Instance parameters for inst1 instance 


Directory for inst2 instance parameters 


Instance parameters for inst2 instance 


Directory for user dump files 


User dump destination for inst1 instance 


User dump destination for inst2 instance 

Directory Structure

The following sections describe the directory structure for OFA compliant installations.

ORACLE Base Directory

The Oracle base directory is the root of the Oracle directory structure. When installing an OFA-compliant database using the Oracle Universal Installer, the default Oracle base directory is set to /pm/app/oracle. Table F-9 describes an Oracle base directory structure and content.

Table F-9 Oracle Base Directory Structure and Content  
Directory  Description 


Administrative files 


Online documentation 


Subtree for local Oracle software 


Oracle software 

Oracle Home Directory

If you install an OFA-compliant Oracle Server, the Oracle home directory is /pm/app/oracle/product/release_number. Table F-10 describes the Oracle home directory structure and content. Under UNIX, the Oracle home directory contains the subdirectories described in Table F-10, as well as a subdirectory for each Oracle product installed.

Table F-10 Oracle Home Directory Structure and Content  
Directory  Description 


Configuration Assistants 


Binaries for all products 


interMedia Text options 


Initialization files 


Installation-related files 


Oracle product libraries 


Java classes 


Spatial options 


Xerox Stemmer (for interMedia Text options) 


Oracle Net Services files 


Common files for all products 


Data gatherer files 


Core libraries 


Data options 


Oracle TRACE files 


PL/SQL files 


Precompiler files 


Server files and libraries required for the database 


SLAX parser files 


SQL*Plus files 

Examples of Product Subdirectories

Table F-11 shows examples of product subdirectories and their contents.

Table F-11 Examples of Product Subdirectories  
Directory  Description 


admin, doc, install, lib, log, mesg 


admin, demo, doc, install, lib, mesg 

Contents of Product Subdirectories

Table F-12 describes the subdirectories contained in the rdbms and sqlplus product subdirectories.

Table F-12 Contents of Product Subdirectories  
Directory  Description 


Administrative SQL and shell scripts (for example, catalog.sql, catexp.sql, and demo.sql


Special directories for other products 


Resource files 


Runtime terminal files 


Demonstration scripts and datafiles 


README files (for example, readmeunix.doc


Product installation scripts 


Product Java classes 


Product libraries and distributed make files 


Trace files and log files (for example, orasrv.log and *.trc files) 


U.S. message files and Multilingual Option (formerly National Language Support) message text and binary files (for example, oraus.msg and oraus.msb

File Naming Conventions in the admin Directory

Table F-13 shows the SQL scripts located in the rdbms/admin directory.

Table F-13 admin Directory, File Naming Conventions  
File  Description 


Creates catalog and data dictionary tables and views. The following files are run automatically during installation:

  • catalog.sql (for all installations)

  • catproc.sql (for all installations)

  • catclust.sql (for Oracle9i Real Application Clusters option installations)

  • catrep.sql (for all installations)

The catproc.sql file in turn runs the scripts for creating the standard PL/SQL packages, such as DBMS_SQL and DBMS_OUTPUT. 


Downgrade scripts 


Additional database packages 


Upgrade scripts 


Creates tables and views for database utilities 

Filename Extensions

Table F-14 describes filename extensions.

Table F-14 Filename Extensions  
Extension  Description 


Object file libraries; Ada runtime libraries 


Oracle audit file 


X11 font description file 


X11 bitmap file 


C source file 


SQL*Loader control file; Oracle Server control file 


SQL*Loader datafile 


Oracle Server tablespace file 


Export file 


ASCII text file 


Shell script file for setting environment 


C header file; also, sr.h is a SQL*Report Writer help file 


Java class archive 


UNIX manual page 


Output of SQL*Plus scrip 


Installation log files; Oracle Server redo log file 


Make file 


Multilingual Option message file (binary) 


Multilingual Option message file (text) 


Object module  


Oracle configuration file 


Installation prototype file 


Pro*C source file 


Pro*COBOL source file 


Printer driver file 


Bourne shell script file 


SQL script file 


Bourne shell script file 


SQL script file 


Trace file 


Bourne shell script file 


Uniform Terminal Definition file 


Zip file 

Go to previous page Go to next page
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Table Of Contents
Go To Index