Tuesday, April 7, 2015

Change ORACLE_BASE after installation

Situation:Want to change the ORACLE_BASE after the installation regardless the environment variable is set or not.

Cause:You used a wrong ORACLE_BASE location during the installation or want to set a new one.

Solution:Use the orabase utility. It is available in 11g and above.

First, check the current value of ORACLE_BASE:
$ORACLE_HOME/bin/orabase

Then, change the value using this command:
$ORACLE_HOME/bin/orabase -d <NEW_ORACLE_BASE>

Finally, verify if the ORACLE_BASE has been changed:
$ORACLE_HOME/bin/orabase