Script for sourcing environment for multiple SID’s sharing same HOME

Below is simple script i created to set environment in RAC nodes & instances sharing same oracle_home.

export ORACLE_HOME=/oracle
export PATH=$ORACLE_HOME/bin:$PATH
echo ” “
echo ” “
echo “Please Enter SID : +ASM1 / RAC1 “
read SID
export ORACLE_SID=$SID
echo ” “
echo ” Environment set for $SID “
echo ” “
echo ” `env|grep ORACLE_SID` “
echo ” “

Advertisement