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

From: Danny Vanderryn <dvanderr_at_oracle.com>
Date: Sat, 2 Oct 1993 00:53:11 GMT
Message-ID: <DVANDERR.93Oct1165311_at_hen3ry.oracle.com>

In article <p24qsADCBh107h_at_uidixon.uucp> idixon_at_uidixon.infocom.co.uk (Ian Dixon) writes:

   Path: oracle!gatekeeper.us.oracle.com!sgiblab!swrinde!cs.utexas.edu!uunet!pipex!uknet!infocom.co.uk!idixon    From: idixon_at_uidixon.infocom.co.uk (Ian Dixon)    Newsgroups: comp.databases.oracle
   Date: 30 Sep 93 21:53:45 GMT
   References: <KS.3.2CA9B101_at_ic.uva.nl> <28cek5$9i5_at_pandora.sdsu.edu>    Organization: at Home in Reading, England    Lines: 49
   X-Newsreader: Helldiver 1.07 (Waffle 1.65)

   In <28cek5$9i5_at_pandora.sdsu.edu> oliver_at_io.nosc.mil (George Oliver) writes:
>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
 

>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:

[...]

>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.

if you put $ORACLE_HOME/bin/dbstart into /etc/rc.local, then each database whose /etc/oratab line has 'Y' in it will be autostarted. this includes any necessary shutdowns. you may also want to start listener process in rc.local. here's what mine looks like: (note that setting ORACLE_HOME isn't necessary, and probably shouldn't be done if you have more than one database (dbstart does it internally). it just makes it easier for me to move my ORACLE_HOME around)

ORACLE_HOME=/private2/oracle7; export ORACLE_HOME

if [ -f $ORACLE_HOME/bin/dbstart ]; then

        echo -n "Starting up databases..." >/dev/console
        $ORACLE_HOME/bin/dbstart >/dev/console
        echo "Done" >/dev/console

fi
if [ -f $ORACLE_HOME/bin/tcpctl -a -f /etc/oratab ]; then

        echo -n "Starting orasrv..." >/dev/console
        PATH=$PATH:$ORACLE_HOME/bin; export PATH
        $ORACLE_HOME/bin/tcpctl start logoff>/dev/console
        echo "Done" >/dev/console

fi

>George Oliver
>NRaD, Code 4221
>oliver_at_nosc.mil

   --
   --

   Ian Dixon                       Email : idixon_at_infocom.co.uk

   Reading, England

--
This opinion will self destruct in 5 seconds.
danny vanderryn--dvanderr_at_oracle.com   || Take my advice ---
{uunet,hplabs,apple}!oracle!dvanderr   || *I'm* certainly not using it.
(415) 506-3142                         || 

Received on Sat Oct 02 1993 - 01:53:11 CET