Gene Sais wrote:
>
> its set to Y. i think its a linux issue, just wondering anyone else using linux and
>when rebooting the server it shutdowns the db's? it calls the scripts to startup
>just not the shutdown.
>
> >>> [EMAIL PROTECTED] 02/13/02 02:01PM >>>
> Please also ensure you have entry of your databases in /etc/oratab file
> whith last field as 'Y'. You oratab file may be on differnt location than
> /etc. Check for $ORACLE_HOME/bin/dbstart file for exact location of oratab
> file
> Regards
> Rafiq
>
> Reply-To: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Date: Wed, 13 Feb 2002 10:03:35 -0800
>
> Did you test the scripts from the command line??
>
> /etc/init.d/dbora stop
> /etc/init.d/dbora start
>
> ?
>
> -Joe
>
> --- Gene Sais <[EMAIL PROTECTED]> wrote:
> > OS: redhat linux 7.2
> > DB: oracle 9.0.1
> > Issue: Databases startup but do not shutdown
> >
> > I placed the db startup and shutdown scripts in /etc/rc.d/init.d
> > directories and linked them to rc0.d, rc2.d, rc3.d, rc4.d, rc5.d.
> > The databases startup fine, however they do NOT shutdown when I
> > issue "shutdown -r now" command from root. Any clues, hints?
> > Maybe I have to put the K00* in all rc.d dirs????
> >
> > Gene
> >
Gene,
I have a Mandrake 8.0 distrib, which is based on RedHat. Here is the
result of find /etc/rc -name '*oracle*' :
/etc/rc.d/init.d/oracle
/etc/rc.d/rc0.d/K01oracle
/etc/rc.d/rc1.d/K01oracle
/etc/rc.d/rc2.d/K01oracle
/etc/rc.d/rc3.d/S98oracle
/etc/rc.d/rc4.d/S98oracle
/etc/rc.d/rc5.d/S98oracle
/etc/rc.d/rc6.d/K01oracle
(All K* and S* are links to the script in init.d).
And here is oracle under init.d (note that my ORACLE_HOME is hard-coded
- as a general rule, when you have several versions of Oracle which
coexist on a machine, call the scripts from the most recent version,
they now how to start/stop older ones, the reverse is not true):
---------------- CUT HERE ----------------
#!/bin/sh
#
# Startup script for Oracle
#
# See how we were called.
case "$1" in
start)
echo -n "Starting oracle: "
su - oracle -c "/software/Oracle/9.0.1/bin/dbstart"
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle
;;
stop)
echo -n "Shutting down oracle: "
su - oracle -c "/software/Oracle/9.0.1/bin/dbshut"
RETVAL=$?
echo
[ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle
;;
restart)
$0 stop
$0 start
RETVAL=$?
;;
*)
echo -n "Usage: $0 {start|stop|restart}"
exit 1
esac
if [ $# -gt 1 ]; then
shift
$0 $*
fi
exit $RETVAL
-------------- CUT HERE ---------------
Works perfectly well for me.
--
HTH,
Stephane Faroult
Oriole Ltd
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
