!/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=/home/oracle/app/oracle/product/19.3.0/dbhome_1
ORA_OWNER=oracle
if [ -f ORA_OWNER -c "
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_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_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_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_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 start
;;
esac
