Linux alias command to change database environment ORACLE_SID Oracle Database Tips by Donald Burleson

Many folks do not like to use the "oraenv" script to change Oracle environments, and some Oracle professionals write a Linux login script to perform the same task.

The script resides in the Linux users "profile" (i.e. .profile, .cshrc), and it build an alias with the same name as each $ORACLE_SID. 

Once in-place, this alternative to oraenv allows you to change database environments by entering the ORACLE_SID name:

for DB in `cat /etc/oratab|grep -v \#|grep -v \*|cut -d":" -f1`
do
  alias $DB='export ORAENV_ASK=NO; \
  export ORACLE_SID='$DB';\
  . $TEMPHOME/bin/oraenv; \
  export ORACLE_HOME;\
  export ORACLE_BASE=\
  `echo $ORACLE_HOME | sed -e 's:/product/.*::g'`;\
  export DBA=$ORACLE_BASE/admin;\
  export SCRIPT_HOME=$DBA/scripts;\
  export PATH=$PATH:$SCRIPT_HOME;\
  export LIB_PATH=$ORACLE_HOME/lib64:$ORACLE_HOME/lib '
done

Now, simply enter the ORACLE_SID as a UNIX alias, and the alias will set your Oracle environment.

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.