DB autostart/shutdown

ashley75 · 07-12-2005, 02:13 PM

I was doing to some research to shutdown/startup DB automatically when server is reboot and one of the thing we have to do as follow:

You can also use $ORACLE_HOME/bin/dbstart to startup the database, and $ORACLE_HOME/bin/dbshut to shutdown the database. You can place $ORACLE_HOME/bin/dbstart into the /etc/rc.d/rc.local boot script to automatically bring up the database at system boot time.

what do he mean by "place $ORACLE_HOME/bin/dbstart"??? does he mean vi the rc.local file and add the string on dbstart into that file???

Tinkster · 07-12-2005, 02:49 PM

Yes, that's what she means. :) ... However, that's not really
a good idea because it won't solve the shut-down.

Code:

#!/bin/sh
# description: Start Stop Oracle 10g and IAS
# chkconfig: 2345 99 00
        
case "$1" in
'start')
        su - oracle -c /path/to/your/oracle/start/db_start.sh
        touch /var/lock/subsys/oracle
        ;;
'stop')
        su - oracle -c /path/to/your/oracle/start/db_stop.sh
        rm -f /var/lock/subsys/oracle
        ;;
*)
        echo "Usage: $0 { start | stop }"
        ;;
esac
exit 0

If you're using RH you probably want a script "oracle"
in /etc/init.d/ ... and symlinks to that from:
./rc.d/rc0.d/K05oracle
./rc.d/rc3.d/S99oracle
./rc.d/rc4.d/S95oracle
./rc.d/rc5.d/S95oracle
./rc.d/rc6.d/K05oracle

Cheers,
Tink