# description: oracle is meant to run under Linux Oracle Server # Source function library. . /etc/rc.d/init.d/functions
ORACLE_HOME=/home/oracle/product/10.2 ORACLE_SID=ora10ha ORACLE_NAME=oracle
LOCKFILE=\RESTART_RETRIES=3 DB_PROCNAMES=\LSNR_PROCNAME=\
#RETVAL=0
#Start the oracle Server
#The following command assumes that the oracle login will not prompt the password start() {
echo \
tmpfile=/home/oracle/`basename $0`-start.$$ logfile=/home/oracle/`basename $0`-start.log #
# Set up our sqlplus script. Basically, we're trying to # capture output in the hopes that it's useful in the case # that something doesn't work properly. #
echo \echo \
su - $ORACLE_NAME -c \
if [ $? -ne 0 ]; then
echo \echo \return 1 fi #
# If we see:
# ORA-.....: failure, we failed #
rm -f $tmpfile
grep -q \if [ $? -eq 0 ]; then rm -f $tmpfile
echo \echo \return 1 fi
echo \
((su - $ORACLE_NAME -c \2>&1) || return 1 #return $?
if [ -n \touch $LOCKFILE fi
#/usr/local/tomcat/bin/catalina.sh start return 0 }
stop() {
echo \
declare tmpfile declare logfile
tmpfile=/home/oracle/`basename $0`-stop.$$ logfile=/home/oracle/`basename $0`-stop.log if [ -z \echo \else
echo \return 0 fi
# Setup for Stop ...
echo \echo \
su - $ORACLE_NAME -c \if [ $? -ne 0 ]; then
echo \echo \return 1 fi #
# If we see 'failure' in the log, we're done. #
rm -f $tmpfile
grep -q failure $logfile if [ $? -eq 0 ]; then echo
echo \echo \return 1 fi
status $LSNR_PROCNAME if [ $? -ne 0 ] ; then if [ -n \rm -f $LOCKFILE fi
return 0 # Listener is not running fi
((su - $ORACLE_NAME -c \2>&1) || return 1
if [ -n \rm -f $LOCKFILE fi return 0 }
get_lsnr_status() {
declare -i subsys_lock=$1
status $LSNR_PROCNAME
if [ $? == 0 ] ; then
return 0 # Listener is running fine elif [ $subsys_lock -ne 0 ]; then return 3
elif [ $? -ne 0 ] ; then return 1 fi }
get_db_status() {
declare -i subsys_lock=$1 declare -i i=0 declare -i rv=0 declare ora_procname
for procname in $DB_PROCNAMES ; do
ora_procname=\
status $ora_procname if [ $? -eq 0 ] ; then
# This one's okay; go to the next one. continue
elif [ $subsys_lock -ne 0 ]; then return 3
elif [ $? -ne 0 ] ; then return 1 fi