My advice
modify the dbshut sql script so it does a shutdown abort. Oracle will
recover on startup.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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 - 10:42:21 CDT
