Re: suspicious standard Oracle Linux start/stop script

Hi!

Yes, eventually all processes are killed with -9 signal. Consider the chance that your Oracle service will remain hanging, the whole shutdown process remains hanging and you can't even log on anymore to see what's going on... And if the server room is hundreds of miles away from your location.. and you don't have any operators on site...

You normally would want to shut down all your databases manually, before shutting down the server.

Tanel.

"LeKaido" <kaidol_at_bluff.ee> wrote in message news:3ed60a81$1_1_at_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
> fi
>
> 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 - 09:38:44 CDT