Odi's astoundingly incomplete notes

Oracle init script

Here is a simple init script for Oracle 10/11 on RedHat Linux. It assumes your instances to start/stop are listed in /etc/oratab and the oracle user's shell environment sets ORACLE_HOME correctly.

#!/bin/sh
#
# chkconfig: 345 98 10
# description: Oracle
#

#
# change the value of ORACLE to the login name of the
# oracle owner at your site
#

ORACLE=oracle

case $1 in
'start')
        cat <<-"EOF"|su - ${ORACLE}
        # Start Oracle Net
        if [ -f ${ORACLE_HOME}/bin/tnslsnr ] ;
        then
             echo "starting Oracle Net Listener"
             ${ORACLE_HOME}/bin/lsnrctl start
        fi
        echo "Starting Oracle databases"
        ${ORACLE_HOME}/bin/dbstart
        ${ORACLE_HOME}/bin/emctl start dbconsole
EOF
        ;;
'stop')
        cat <<-"EOF"|su - ${ORACLE}
        echo "shutting down"
        ${ORACLE_HOME}/bin/emctl stop dbconsole
        # Stop Oracle Net
        if [ -f ${ORACLE_HOME}/bin/tnslsnr ] ;
        then
             echo "stopping Oracle Net Listener"
             ${ORACLE_HOME}/bin/lsnrctl stop
        fi
        echo "stopping Oracle databases"
        ${ORACLE_HOME}/bin/dbshut
EOF
        ;;
*)
        echo "usage: $0 {start|stop}"
        exit
        ;;
esac
#
exit

posted on 2008-05-08 14:20 UTC in Code | 0 comments | permalink

Add comment