Friday, April 23, 2010

Nice one liner for ORACLE_HOME

Here is a quick way to set your ORACLE_HOME for a given SID. It works great for writing scripts that need to call sqlplus or other oracle utilities.

export ORACLE_HOME=$(grep $ORACLE_SID /var/opt/oracle/oratab | awk -F':' '{ print $2 }')

0 comments: