Re: How to get oracle server to start automatically on reboot

Karel Sprenger (KS_at_ic.uva.nl) wrote:
: Hello all,
 

: Is there a way to make the oracle server start up automatically when the
: (SunOS) operating system is restarted? I vaguely recall this question has been
: asked and answered here earlier, but didn't archive the answer at the time.
: Or was it simply RTFM?
 

: Any help is much appreciated.

Try adding the startup procedures to your rc.local. That way whenever you reboot, it startup oracle. I use this to startup a version 6.0.33 server:

#
ORACLE_HOME=/usr2/oracle
ORACLE_SID=aries  

export ORACLE_HOME ORACLE_SID  

if [ -f /usr2/oracle/bin/sqldba ]; then  

        echo -n 'starting oracle server:'
        /usr2/oracle/bin/sqldba shutdown abort
        /usr2/oracle/bin/sqldba startup
 

For some reason, if my server crashes I have to run a shutdown abort to clear the server (ior c?).

I am told that you can set a flag in your /etc/oratab file. But I haven't had any success with it.

Good luck,

Geo.

George Oliver
NRaD, Code 4221
oliver_at_nosc.mil Received on Wed Sep 29 1993 - 17:54:29 CET