Hi I’m having a bit of a problem with a init script which I wrote to start and stop oracle listener and database. My system is Redhat 5.4 64bit and oracle 10g2 standard database (64).
I have created the script and added the script using

chkconfig –add orashut, and on the script by

chkconfig –level 345 orashut on

Now I can use service orashut start, stop, restart, and works fine and when the system comes up the database and the listener would come up as planed. But the problem is when I do a reboot or shut down the db or the listener would not shutdown as expected, I placed at K00 values as well in rc0.d and rc6.d to give the priority at the shutdown. Even though all the configurations say this script should run before everything else at the shutdown time this is not working.

Can some one tell me what I am doing wrong

Thanks
Best regards

You forgot to add the relevant runlevels in chkconfig.
0 and 6

Why it's not running when you manually added them ...
did you make it executable? Are the manually created
links pointing at the right file?

Cheers,
Tink

Hi Thakns for the reply, but I am bit confused

when I do chkconfig --list | grep orashut it gives me this out put
orashut 0 : off 1 : off 2 : off 3 : on 4 : on 5 : on 6 : off

This mean all runlevels are oka and it I go the /etc/rc.d/rc0.d and rc6.d I can find K00orashut -> ../init.d/orashut in both places so acording to this things should be okay (at least I hope )

Please let me know what I a am doing wrong, when he shutdowns I dont even see a error message.

Only good thing is the startup script works oks and I can do service orasut start|stop|restart at the command prompt with out any issue.

Thanks and regards

In that case you may wish to post the script - chances are your
code is faulty :}

Hi Tinkster, below is my start and stop script, thanks bser regards



#!/bin/bash
#
# Oracle 10g2 This shell script takes care of starting and stopping
# Oracle 10g2.
#
# chkconfig: 345 95 00
# description: Oracle 10g2 service listner and database
#
# processnameracledb
# config: /etc/oratab

# Source function library.
. /etc/rc.d/init.d/functions

# Source networking configuration.
. /etc/sysconfig/network

export ORACLE_BASE="/home/app/oracle"
export ORACLE_HOME="/home/app/oracle/product/10.2.0"
export ORACLE_HOME_LISTNER=${ORACLE_HOME}
export ORA_OWNR="oracle10g2"

RETVAL=0
prog="Oracle10g2"

start() {
# Start Oracle process.

[ -f $ORACLE_HOME/bin/lsnrctl ] || exit 4
[ -f $ORACLE_HOME/bin/dbstart ] || exit 4

site="Listner"
echo -n $"Starting $site for $prog: "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl start"
site="db"
echo -n $"Starting $prog "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbstart"
RETVAL=$?
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/$prog
echo
return $RETVAL
}

stop() {
# Stoping Oracle process.

[ -f $ORACLE_HOME/bin/lsnrctl ] || exit 4
[ -f $ORACLE_HOME/bin/dbshut ] || exit 4

site="Listner"
echo -n $"Stoping $site for $prog: "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/lsnrctl stop"
site="db"
echo -n $"Stoping $prog "
su - $ORA_OWNR -c "$ORACLE_HOME/bin/dbshut"
RETVAL=$?
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/$prog
echo
return $RETVAL
}

# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
restart|reload)
stop
start
RETVAL=$?
;;
asarestart)
if [ -f /var/lock/subsys/$prog ]; then
stop
start
RETVAL=$?
fi
;;
status)
status $prog
RETVAL=$?
;;
*)
echo $"Usage: $0 {start|stop|restart|asarestart|status}"
exit 2
esac

exit $RETVAL