script

#1 create two oratab /etc/oratab and /etc/oratab2 file for bi infra and oracle 11g database
#2 change script both $ORACLE_HOME/bin/dbstart and dbshut file
PS3='Please enter your choice: '
options=("Start 1" "Down 2" "Quit")
select opt in "${options[@]}"
do
   case $opt in
       "Start 1")
           echo " Starting ALL Process Please Wait "
HOST=`hostname`
PLATFORM=`uname`

ORACLE_HOME=/infra
export ORACLE_HOME
ORACLE_SID=orcl
export ORACLE_SID
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/dbstart $ORACLE_HOME
echo " Starting opmn INFRA "
$ORACLE_HOME/opmn/bin/opmnctl startall
ORACLE_HOME=/bi
export ORACLE_HOME
echo " Starting opmn BI "
$ORACLE_HOME/opmn/bin/opmnctl startall

ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
ORACLE=oracle
ORACLE_SID=sweet
PATH=${PATH}:$ORACLE_HOME/bin
export ORACLE_HOME PATH
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/dbstart $ORACLE_HOME
           ;;
       "Down 2")
           echo " Shuting down ALL Process Please Wait "
ORACLE_HOME=/bi
export ORACLE_HOME
echo " down opmn BI "
$ORACLE_HOME/opmn/bin/opmnctl stopall

ORACLE_HOME=/infra
export ORACLE_HOME
ORACLE_SID=orcl
export ORACLE_SID
echo " down opmn INFRA "
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/bin/lsnrctl stop
$ORACLE_HOME/bin/dbshut $ORACLE_HOME
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
ORACLE=oracle
ORACLE_SID=sweet
$ORACLE_HOME/bin/lsnrctl stop
$ORACLE_HOME/bin/dbshut $ORACLE_HOME
;;
       "Quit")
           break
           ;;
       *) echo invalid option;;
   esac
done