About Oracle Base Home
Both, in a read-only ORACLE_HOME and read/write ORACLE_HOME, the user-specific files, instance-specific files, and log files reside in a location known as the ORACLE_BASE_HOME.
In a read/write ORACLE_HOME, the ORACLE_BASE_HOME path is the same as the ORACLE_HOME directory. However, in a read-only ORACLE_HOME, the ORACLE_BASE_HOME directory is not co-located with ORACLE_HOME but is located at ORACLE_BASE/homes/HOME_NAME
. Where, HOME_NAME is the internal name for ORACLE_HOME.
For example, the networking directories network/admin
, network/trace
, and network/log
are located in the ORACLE_BASE_HOME directory. In a read/write ORACLE_HOME the networking directories appear to be in ORACLE_HOME because ORACLE_BASE_HOME is co-located with ORACLE_HOME, whereas in a read-only ORACLE_HOME the networking directories are located in ORACLE_BASE/homes/HOME_NAME
.
orabasehome
command from the $ORACLE_HOME/bin
directory:$ setenv ORACLE_HOME /u01/app/oracle/product/23.0.0/dbhome_1
$ cd $ORACLE_HOME/bin
$ ./orabasehome
The orabasehome
command returns the location of ORACLE_BASE_HOME irrespective of whether the home is a read-only ORACLE_HOME or a read/write ORACLE_HOME.
For example, to know the location of networking files like sqlnet.ora
, tnsnames.ora
, or listener.ora
, run orabasehome
:
Example 12-1 Output in a Read-Only ORACLE_HOME
$ ./orabasehome
/u01/app/oracle/homes/OraDB23Home1
Where, /u01/app/oracle
is ORACLE_BASE and OraDB23Home1
is the HOME_NAME.
Example 12-2 Output in a Read/Write ORACLE_HOME
$ ./orabasehome
/u01/app/oracle/product/23.0.0/dbhome_1
Where, /u01/app/oracle/product/23.0.0/dbhome_1
is the ORACLE_HOME.
Parent topic: Evolution of Oracle Homes