suspicious standard Oracle Linux start/stop script

From: LeKaido <kaidol_at_bluff.ee>
Date: Thu, 29 May 2003 16:24:07 +0300
Message-ID: <3ed60a81$1_1@news.estpak.ee>

Version: 9.2.0.1 Opsys: Linux RedHat

Oracle recommends using the following script in /etc/init.d/<your_name_for_script>
for starting/stopping database (also at startup/shutdown).

The full script is referred below. It can also be found in the installation guide.

What really bothers me in all this is the line:

su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &

As I understand it , it starts a _background_ process that's supposed to shutdown oracle during _system_ shutdown.

Is there anyone out there who can comment on what happens , if the operating system shutdown completes _before_ oracle has completed? I assume there is no "stopping mechanism" there and oracle just gets killed before it's done with shutdown with all possible dire consequences that could follow.

Anyone got any exp/opinions on this one?

KL.

THE SCRIPT -------------

#!/bin/sh

# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle/product/9.2.0.1.0 ORA_OWNER=oracle

if [! -f $ORA_HOME/bin/dbstart]
then

      echo "Oracle startup: cannot start"
      exit

case "$1" in

'start')

# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values

      su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
      ;;

      'stop')



           # Stop the Oracle databases:

           # The following command assumes that the oracle login

           # will not prompt the user for any values


      su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
      ;;

esac Received on Thu May 29 2003 - 08:24:07 CDT