Oracle Startup Script

#!/bin/bash
#
# chkconfig: 2345 95 10
# description: init script to start/stop oracle database 10g, TNS listener \ 
#              EMS, isqlplus

##------------------------##
## chkconfig --add oracle ##
## chkconfig --del oracle ##
##------------------------##

usage()
{
    echo "Usage: $0 {start|restart|stop}"
    exit 1
}

[ $# -gt 0 ] || usage

LOG_PATH=/var/log/oracle-start-stop.log

start(){
    su - oracle<<EOO
        lsnrctl start
        sqlplus /nolog<<EOS
            connect / as sysdba
            startup
        EOS
        #emctl start dbconsole
        #isqlplusctl start
    EOO
}

stop(){
    su - oracle<<EOO
    lsnrctl stop
    sqlplus /nolog<<EOS
        connect / as sysdba
        shutdown immediate
    EOS
    #emctl stop dbconsole
    #isqlplusctl stop
    EOO
}

case $1 in
start)
    start >> $LOG_PATH
;;
stop)
    stop >> $LOG_PATH
;;
restart)
    stop >> $LOG_PATH
    start >> $LOG_PATH
;;
*)
    usage
;;
esac