orabasetab file is used to define fundamental directories based on $ORACLE_HOME: ORACLE_BASE, ORACLE_BASE_HOME and ORACLE_BASE_CONFIG.
orabasetab file resides in
ORACLE_HOME/install/orabasetab and can be used to determine if an ORACLE_HOME is read-only or read/write. It also defines the ORACLE_BASE and the HOME_NAME of the Oracle home. HOME_NAME is the internal name for ORACLE_HOME.
The last line in the
orabasetab file, which starts with $ORACLE_HOME, defines the directories for $ORACLE_HOME. The last line consists of four fields, each separate by a colon delimiter
The first field matches the current $ORACLE_HOME.
The second field defines the ORACLE_BASE for the current ORACLE_HOME.
The third field defines the HOME_NAME which is used in constructing the ORACLE_BASE_HOME path in a read-only ORACLE_HOME.
The fourth field displays
Nin a read/write ORACLE_HOME and
Yin a read-only ORACLE_HOME.
In a read-only ORACLE_HOME, the ORACLE_BASE_HOME path is
ORACLE_BASE/homes/HOME_NAME and ORACLE_BASE_CONFIG is the same as ORACLE_BASE.
In a read/write ORACLE_HOME, ORACLE_HOME, ORACLE_BASE_HOME and ORACLE_BASE_CONFIG are all the same.
Viewing an orabasetab File
Log in as the Oracle installation owner user account (
Go to the
$ cd /u01/app/oracle/product/18.0.0/dbhome_1/install
View the contents of the
$ cat orabasetab $ u01/app/oracle/product/18.0.0/dbhome_1:/u01/app/oracle:OraDB18Home1:Y:
In this example, a
Yin the fourth field at the end of the line indicates you have a read-only Oracle home.