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