A Optimal Flexible Architecture

 


Introduction

Oracle Corporation recommends the Optimal Flexible Architecture (OFA) standard for Oracle installations. The OFA standard is a set of configuration guidelines for efficient and reliable Oracle databases that require little maintenance.

OFA provides the following benefits:

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

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

  • Alleviates switching among multiple Oracle databases

  • Manages and administers database growth adequately

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

To switch to the OFA standard, modify the directory structure and relocate the database files.

 

OFA Compliant Installation

If the ORACLE_BASE environment variable is set during installation, an OFA installation is performed, and the PFS_HOME environment variable is set to
$ORACLE_BASE/admin/db_name/pfs.

The following is the directory structure of a sample Oracle9i Real Application Clusters Guard OFA compliant installation on UNIX platforms:

$ORACLE_BASE
$ORACLE_HOME
$ORACLE_HOME/pfs
$ORACLE_HOME/pfs/admin
$ORACLE_HOME/pfs/admin/bin
$ORACLE_HOME/pfs/admin/demo
$ORACLE_HOME/pfs/admin/doc
$ORACLE_HOME/pfs/admin/setup"
$ORACLE_HOME/pfs/admin/setup/pfssetup
$ORACLE_HOME/pfs/admin/setup/createpacks
$ORACLE_HOME/pfs/admin/setup/deletepacks
$ORACLE_HOME/pfs/admin/setup/template
$ORACLE_HOME/pfs/admin/setup/template/packs
$ORACLE_HOME/pfs/admin/setup/template/include
$ORACLE_HOME/pfs/admin/setup/template/pfile
$ORACLE_HOME/pfs/admin/setup/template/conf
$ORACLE_HOME/pfs/admin/setup/template/conf/savsetup.dat
$ORACLE_HOME/pfs/admin/setup/template/conf/<ORACLE_SERVICE>.conf
$ORACLE_HOME/pfs/admin/setup/template/output
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/packs
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/include
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/pfile
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/network
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/lib
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/lib/pfs_oracle
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/lib/pfs_internal
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/lib/pfs_cluster
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/mesg
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/mesg/avus.msg
$ORACLE_HOME/pfs/admin/setup/template/output/<ORACLE_SERVICE>/<ORACLE_SERVICE>.conf/sys
$ORACLE_HOME/pfs/admin/
$ORACLE_HOME/pfs/admin/<db_name>
$ORACLE_HOME/pfs/admin/<db_name>/dump
$ORACLE_HOME/pfs/admin/<db_name>/dump/bdump
$ORACLE_HOME/pfs/admin/<db_name>/dump/udump
$ORACLE_HOME/pfs/admin/<db_name>/dump/cdump
$ORACLE_HOME/pfs/admin/<db_name>/pfile
$ORACLE_HOME/pfs/admin/<db_name>/dump/network
$ORACLE_HOME/pfs/admin/<db_name>/dump/network/admin
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs/include
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs/packs
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs/user
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs/pfsdump
$ORACLE_HOME/pfs/admin/<db_name>/dump/pfs/<ORACLE_SERVICE>.conf

                                                                                

 

Non-OFA Compliant Installation

If the ORACLE_BASE environment variable is not set during installation, a non-OFA installation is performed and the PFS_HOME environment variable is set to $ORACLE_HOME/pfs/db_name.

The following is the directory structure of a sample Oracle9i Real Application Clusters Guard non-OFA compliant installation on UNIX platforms:

$ORACLE_HOME
$ORACLE_HOME/pfs
$ORACLE_HOME/pfs/admin
$ORACLE_HOME/pfs/bin
$ORACLE_HOME/pfs/demo
$ORACLE_HOME/pfs/doc
$ORACLE_HOME/pfs/setup"
$ORACLE_HOME/pfs/setup pfssetup
$ORACLE_HOME/pfs/setup createpacks
$ORACLE_HOME/pfs/setup deletepacks
$ORACLE_HOME/pfs/setup/template
$ORACLE_HOME/pfs/setup/template/packs
$ORACLE_HOME/pfs/setup/template/include
$ORACLE_HOME/pfs/setup/template/pfile
$ORACLE_HOME/pfs/setup/template/network
$ORACLE_HOME/pfs/setup/conf
$ORACLE_HOME/pfs/setup/conf/sacsetup.dat
$ORACLE_HOME/pfs/setup/conf/<ORACLE_SERVICE>.conf
$ORACLE_HOME/pfs/setup/output
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>/packs
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>/include
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>/pfile
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>/network
$ORACLE_HOME/pfs/setup/output/<ORACLE_SERVICE>/network/<ORACLE_SERVICE>.conf
$ORACLE_HOME/pfs/setup/lib
$ORACLE_HOME/pfs/setup/lib/pfs_oracle
$ORACLE_HOME/pfs/setup/lib/pfs_internal
$ORACLE_HOME/pfs/setup/lib/pfs_cluster
$ORACLE_HOME/pfs/setup/mesg
$ORACLE_HOME/pfs/setup/mesg/pfsus.msg
$ORACLE_HOME/pfs/setup/sys

$ORACLE_HOME/pfs/setup/<db_name>
$ORACLE_HOME/pfs/setup/<db_name>/<ORACLE_SERVICE>.conf
$ORACLE_HOME/pfs/setup/<db_name>/pfile
$ORACLE_HOME/pfs/setup/<db_name>/include
$ORACLE_HOME/pfs/setup/<db_name>/packs
$ORACLE_HOME/pfs/setup/<db_name>/user
$ORACLE_HOME/pfs/setup/<db_name>/log