Cannot autostart Oracle 9i on HP-UX 11i

[gnagesh]

Hi

Cannot auto start Oracle 9i on HP-UX 11i box. Help me please.

Here is my dbora (/sbin/init.d):
#!/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=/opt/app/oracle/product/9.2.0
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

/usr/bin/su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart" &
/usr/bin/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

/usr/bin/su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut" &
/usr/bin/su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
;;

esac

I have created links to
/sbin/rc0.d/K10dbora -> /sbin/init.d/dbora
/sbin/rc2.d/S99dbora -> /sbin/init.d/dbora
/sbin/rc3.d/S99dbora -> /sbin/init.d/dbora

When I try /sbin/init.d/dbora start/stop, working fine. It can start all the instances and listener also.

Any thing I am missing? Help me.

Thanks In Advance

[sysdba]

try take off '&'

[OracleDoc]

Correct me if I'm wrong but doesn't Oracle prefer to run under a K-shell?

[davey23uk]

makes no odds really what shell you run it is as long as syntax is correct.

Also taking the & wont help at all.

I would put some echo's in there and watch the console or touch a file and see if it gets created - or write the whole thing to a log file

[sysdba]

Believe it or not, it is my experience that on some system,
'&' will not start the database instance, and WITHOUT '&', everything worked fine. Linux is one the examples.

[gnagesh]

Hi

Thanks for your support. Problem solved. We need setup ORACLE_START environment variable in /etc/rc.config.d on HP-UX to auto start Oracle instance while reboot. I have configured the file dbora in /etc/rc.config.d , following way:

#!/sbin/sh
# ***********************************************************
# ORACLE_START: Set to 1 to start ORACLE RDBMS, 0 otherwise.
# ***********************************************************
ORACLE_START=1
ORACLE_OWNER=oracle

Thanks.

[davey23uk]

Believe it or not, it is my experience that on some system,
'&' will not start the database instance, and WITHOUT '&', everything worked fine. Linux is one the examples.

I wont believe it because it isnt true, we use the & and it makes no difference. You must be doing something different