Re: Auto Startup Shutdown Problem

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 12 Nov 2003 22:47:25 +1100
Message-ID: <3fb21dd2$0$13591$afc38c87@news.optusnet.com.au>

"DOKNIK" <dominiqs_at_o2.co.uk> wrote in message news:1068636886.744595_at_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

==================

Please don't post in HTML! Lots of readers can't or won't be allowed to cope with it.

Your problem wouldn't have anything to do with the fact that the lines to set the variables for ORA_HOME and ORA_OWNER are still commented out in this example, would it??

Regards
HJR

---

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:47:25 CST