Auto Startup Shutdown Problem

From: DOKNIK <dominiqs_at_o2.co.uk>
Date: Wed, 12 Nov 2003 11:33:55 -0000
Message-ID: <1068636886.744595@ernani.logica.co.uk>

All,
I am trying to implement the Oracle auto startup/shutdown scripts on our Unix server using the instructions and scripts supplied by Oracle ie Oracle Installation guide but this does not seem to work.

I am running HP version (HP-UX B.11.11 U 9000/800 721957645 unlimited-user license)and Oracle version 9.2.0.3

Please see below a copy of the dbora scriptI am using .I have always done this successfully on Solaris, but this is my first time doing this on HP, is there anything else i need to do?, Am i missing any steps, perhaps the Oracle manual didnt mention? I have edited /etc/oratab making all databases to be autostarted or autostopped .

Any help would be greatly appreciated.

# cat dbora
#!/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=/ora8_01/app/oracle/product/8.1.7
#ORA_OWNER=oracle8

export ORA_HOME=/u01/app/oracle/product/9.2.0.3 export 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 &

#       su - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl start &
        ;;
        '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 &

#       su - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl stop &
        ;;

esac Received on Wed Nov 12 2003 - 05:33:55 CST