#!/bin/sh
# chkconfig: 35 80 10
# description: oracle auto start-stop script.
#
# set ora_home to be equivalent to the $oracle_home
# from which you wish to execute dbstart and dbshut;
#
# set ora_owner to the user id of the owner of the
# oracle database in ora_home.
ora_home=/opt/oracle/102
ora_owner=oracle
if [ ! -f $ora_home/bin/dbstart ]
then
echo “oracle startup: cannot start”
exit
fi
case “$1” in
start)
# start the oracle databases:
echo “starting oracle databases … “
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : starting oracle databases as part of system up.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
su – $ora_owner -c “$ora_home/bin/dbstart” >>/var/log/oracle
echo “done”
# start the listener:
echo “starting oracle listeners … “
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : starting oracle listeners as part of system up.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
su – $ora_owner -c “$ora_home/bin/lsnrctl start” >>/var/log/oracle
echo “done.”
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : finished.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
# stop the oracle listener:
echo “stoping oracle listeners … “
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : stoping oracle listener as part of system down.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
su – $ora_owner -c “$ora_home/bin/lsnrctl stop” >>/var/log/oracle
echo “done.”
rm -f /var/lock/subsys/oracle
# stop the oracle database:
echo “stoping oracle databases … “
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : stoping oracle databases as part of system down.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
su – $ora_owner -c “$ora_home/bin/dbshut” >>/var/log/oracle
echo “done.”
echo “”
echo “————————————————-” >> /var/log/oracle
date +” %t %a %d : finished.” >> /var/log/oracle
echo “————————————————-” >> /var/log/oracle
;;
restart)
$0 stop
$0 start
;;
esac