Oracle auto startup in Solaris

[David Li]

I have installed Oracle 9i in Solaris 6.5 machine.
But everytime after the Solaris restarts, I have to startup the Oracle service manually.

Could you tell me how to startup Oracle service automatically after the Solaris server is restarted?

[David Li]

Please!

It will be highly appreciated if any response!

[Beksy Kurian]

1. Oracle startup and shutdown scripts

$ORACLE_HOME/bin/dbstart
$ORACLE_HOME/bin/dbshut

1a)./etc/oratab or /var/opt/oracle/oratab Specify a "Y" in this field for the database


2. As root, create the following OS script file dbora.sh in the
/etc/init.d directory:
#!/bin/sh
ORACLE_HOME="Your Oracle Home"
ORACLE_OWNER=oracle
if [ "$1" = "start" ] ; then
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart &
exit 0
fi
if [ "$1" = "stop" ] ; then
su - $ORACLE_HOME -c $ORACLE_HOME/bin/dbshut &
exit 0
fi
echo "Usage: $0 [start|stop]"


3. Link the dbora.sh to /etc/rc directory:
# ln -s /etc/init.d/dbora.sh /etc/rc0.d/K10dbora.sh
# ln -s /etc/init.d/dbora.sh /etc/rc2.d/S99dbora.sh


Hope this helps!
Beksy