File Path and Directory Changes in Read-Only Oracle Homes

Learn from these examples the differences between hierarchical file mappings in a read-only Oracle home compared to a read/write Oracle home.

This example shows an Optimal Flexible Architecture-compliant Oracle Database installation, for the user oracle, with the ORACLE_HOME, ORACLE_BASE, ORACLE_BASE_HOME, and ORACLE_BASE_CONFIG logical locations. The database files are mounted on /u01 and the HOME_NAME is OraDB23Home1.

This example also shows the changes in the Oracle Database software defined paths of configuration files, log files, and other directories in a read-only Oracle home when compared to a read/write Oracle home.

Table 12-1 Read-Only Oracle Home and Read/Write Oracle Home File Path Examples

Directory Read-Only Oracle Home File Path Read/Write Oracle Home File Path

ORACLE_HOME

/u01/app/oracle/product/23.0.0/dbhome_1 /u01/app/oracle/product/23.0.0/dbhome_1

ORACLE_BASE

/u01/app/oracle/ /u01/app/oracle/

ORACLE_BASE_HOME

ORACLE_BASE/homes/HOME_NAME

(or)

/u01/app/oracle/homes/OraDB23Home1

ORACLE_HOME

(or)

/u01/app/oracle/product/23.0.0/dbhome_1

ORACLE_BASE_CONFIG

ORACLE_BASE

(or)

/u01/app/oracle/

ORACLE_HOME

(or)

/u01/app/oracle/product/23.0.0/dbhome_1

network

ORACLE_BASE_HOME/network/admin

(or)

/u01/app/oracle/homes/OraDB23Home1/network/admin

ORACLE_HOME/network/admin

(or)

/u01/app/oracle/product/23.0.0/dbhome_1/network/admin
dbs

ORACLE_BASE_CONFIG/dbs

(or)

/u01/app/oracle/dbs

ORACLE_HOME/dbs

(or)

/u01/app/oracle/product/23.0.0/dbhome_1/dbs
hs

ORACLE_BASE_HOME/hs/admin

(or)

/u01/app/oracle/homes/OraDB23Home1/hs/admin

ORACLE_HOME/hs/admin

(or)

/u01/app/oracle/product/23.0.0/dbhome_1/hs/admin
mgw

ORACLE_BASE_HOME/mgw/admin

(or)

/u01/app/oracle/homes/OraDB23Home1/mgw/admin

ORACLE_HOME/mgw/admin

(or)

/u01/app/oracle/product/23.0.0/dbhome_1/mgw/admin
drdaas

ORACLE_BASE_HOME/drdaas/admin

(or)

/u01/app/oracle/homes/OraDB23Home1/drdaas/admin

ORACLE_HOME/drdaas/admin

(or)

/u01/app/oracle/product/23.0.0/dbhome_1/drdaas/admin
  • To print the ORACLE_BASE_HOME path, run:

    $ setenv ORACLE_HOME /u01/app/oracle/product/23.0.0/dbhome_1
    $ cd $ORACLE_HOME/bin
    $ ./orabasehome
  • To print the ORACLE_BASE_CONFIG path, run:

    $ setenv ORACLE_HOME /u01/app/oracle/product/23.0.0/dbhome_1
    $ cd $ORACLE_HOME/bin
    $ ./orabaseconfig