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.