Difference between ORACLE_BASE and ORACLE_HOME

ORACLE_HOME is where the software is installed.

$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.4/dbhome_1

ls /u01/app/oracle/product/11.2.0.4/dbhome_1

OPatch
bin
rdbms
sqlplus
etc….

ORACLE_BASE is where everything Oracle, including the ORACLE_HOME, is installed.

$ echo $ORACLE_BASE
/u01/app/oracle

ls /u01/app/oracle

fast_recovery_area
oradata
diag
admin
etc…

The ORACLE_BASE directory can contain many ORACLE_HOME directories. It may also contain a separate Oracle flashback area, Oracle admin area and Oracle data area.

Leave a Reply