SEO

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

DOKNIK wrote:
> 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

Can you start the database(s) manually using this script? Usually you
need to copy over the init<dbname>.ora file to the appropriate location.
The Oracle installer manually specifies the file name when it starts
up the database instance. Running "dbstart" by hand should indicate the
problem. Hope that helps.

Rakesh

Rakesh Vidyadharan wrote:
> DOKNIK wrote:
>
>> 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
>
>
> Can you start the database(s) manually using this script? Usually you
> need to copy over the init<dbname>.ora file to the appropriate location.
> The Oracle installer manually specifies the file name when it starts up
> the database instance. Running "dbstart" by hand should indicate the
> problem. Hope that helps.
>
> Rakesh
>
also make sure you have the ENV sourced.

We do it as part of SAP R/3 startup, and there we must start "lsnrctl
start" to get the database up. Maybe it helps.

Ulrich

"DOKNIK" <dominiqs@o2.co.uk> writes:

> 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

alain
are you sure that ORACLE_SID is set to a real value?
it could be a real problem

"Ulrich Windl" <Ulrich.Windl@RZ.Uni-Regensburg.DE> a écrit dans le message
de news: m31xrwwy61.fsf@pc5234.klinik.uni-regensburg.de...
> We do it as part of SAP R/3 startup, and there we must start "lsnrctl
> start" to get the database up. Maybe it helps.
>
> Ulrich
>
> "DOKNIK" <dominiqs@o2.co.uk> writes:
>
> > 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