Oracle Auto Restart

January 2, 2011 oracleperformancetuner Database, Oracle Administration, Oracle Configuration, Oracle Installation

This page covers Oracle Auto Restart and automatically stopping and starting an Oracle Database on Linux and UNIX restart.

In the /etc/oratab file you might have to set the flags to Y (traditionally this has always been the default).

RH4 for Oracle10g may also have an incorrect setting for the lsnrctl program that prevents listener startup in an ASM installation.

The Startup & Shutdown Script

Add this file /etc/init.d/oracle:

#!/bin/sh
# chkconfig: 345 95 30
# description: Oracle auto start-stop script.
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
case "$1" in
        'start')
                su - oracle -c $ORACLE_HOME/bin/dbstart				#Database - handles multiple s
                su - oracle -c "$ORACLE_HOME/bin/lsnrctl start"			#Listener
                su - oracle -c "$ORACLE_HOME/bin/lsnrctl dbsnmp_start"		#Agent (might be installed elsewhere with RAC and/or a multiple database environment)
                exit 0
        ;;
        'stop')
                su - oracle -c "$ORACLE_HOME/bin/lsnrctl dbsnmp_stop"           #Agent (might be installed elsewhere with RAC and/or a multiple database environment)
                su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop"
                su - oracle -c $ORACLE_HOME/bin/dbshut
        ;;
        *)
                echo "usage: start or stop"
                exit 0
        ;;
esac
exit 0

Setting the Shutdown & Startup Script to Execute on Operating System Restart

Automate the execution of the /etc/init.d script by adding script copies or symbolic links to the startup and shutdown directory, ie. the /etc/rc2.d and /etc/rc0.d directories respectively.

The shutdown directory is /etc/rc0.d, which will execute process (K)ill scripts on *NIX shutdown where those scripts are executed in order of the integers in the filenames, ie. K02test1 is executed before K03test2. Place the oracle shutdown scripts above K00<name> but as close to K00<name> as possible, ie. execute the Oracle process shutdown first.

cd /etc/rc0.d
ln -s /etc/init.d/oracle K30oracle

The startup directory is /etc/rc2.d. Note that the startup directory contains both (K)ill and (S)tartup scripts, or links. If anything needs to be killed before starting when *NIX starts-up then this is where it goes. Place the oracle startup link in the sequence of file/link names as far to the end of the list as possible.

cd /etc/rc2.d
ln -s /etc/init.d/oracle S95oracle

And the:

chmod 755 /etc/init.d/oracle

Please note that this page was constructed from a Solaris blade server environment but should apply to Linux and other flavors of UNIX as well.

dbshut, dbstart, Oracle 10g Auto Restart, Oracle 11g Auto Restart, Oracle Auto Restart

Using Agile to Develop with Lowered Risk Install Oracle11gR2 Single Instance on Linux