Re: Starting Oracle on Unix Reboot

There is a free paper on www.robonerd.com in the downloads area that discusses startup and shutdown on UNIX, Linux and Windows in detail with example scripts and instructions about K and S entries in the Unix startup area. You may find it enlightening.

Mike Ault
TUSC
www.tusc.com
ROBO Books
www.robonerd.com

longtermmemoryloss_at_hotmail.com (Mike) wrote in message news:<7d3e2063.0209131113.75abedc6_at_posting.google.com>...
> Try this:
>
> export ORACLE_SID=xxxx # or whatever your oracle_sid happens to be
> export PATH=$PATH:/path/to/dbstart/script # /var/opt/oracle,
> ferinstance
>
> export ORAENV_ASK=NO
> . oraenv
>
> When these lines are added to the "oracle" account's shell
> initialization script (e.g. $HOME/.profile or $HOME/.login), things
> should "just work".
>
> Now try dbstart. Hope it works.
>
> How are you starting the server when the server boots up? Did you
> modify one of the system's shell scripts (e.g. /etc/rc.local or
> /etc/rc2.d/something) so that it invokes dbstart?
>
> For example:
> su - oracle -c dbstart
>
> audrey_at_marketaccess.ca (audrey) wrote in message news:<14799422.0209121258.386a17ff_at_posting.google.com>...
> > Hi Norman!
> > Yes, we've tried dbstart, and nothing happens
> > yes, the database is the only database on the server, although there
> > were a couple other databases on there which I deleted.
> >
> > I am sure the ORACLE_HOME is correct, however I am not so sure about
> > the ORACLE_SID
> >
> > I would assume they are the both correct, because when I reconfigure
> > the database, it runs fine. I just find it odd that you would need to
> > reconfigure the database everytime the computer reboots.
> >
> >
> > Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in message news:<E2F6A70FE45242488C865C3BC1245DA70294EDF9_at_lnewton.leeds.lfs.co.uk>...
> > > Audrey,
> > >
> > > what happens if, when your databse is down, you simply type in dbstart
> > > (assuming that only your databse is on the server !!) - does it start ?
> > >
> > > Usualy rules about having ORACLE_HOME and ORACLE_SID set correctly of
> > > course :o)
> > >
> > > Cheers,
> > > Norman.
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: audrey_at_marketaccess.ca (audrey) [mailto:audrey_at_marketaccess.ca]
> > > Posted At: Friday, August 30, 2002 2:56 PM
> > > Posted To: server
> > > Conversation: Starting Oracle on Unix Reboot
> > > Subject: Starting Oracle on Unix Reboot
> > >
> > >
> > > Hi All!
> > >
> > > I'm a newbie to Unix and think I am missing a command in my start up
> > > script on unix. Here's the situation.
> > >
> > > A client of mine has a unix true 64 box with Oracle 8.1.7. I finally
> > > managed to install Oracle with no errors, was able to create a
> > > database, create tables, enter data, etc. Everything was working
> > > wonderfully until I tried rebooting the box.
> > >
> > > When I reboot, my start up script starts the listener with no problems
> > > (I can see the process when I type the ps ax command). I also have my
> > > script run dbstart, I edited the ora_tab file and changed the N to a
> > > Y. My start up script also runs the dbstart command. After the start
> > > up script is run, I look at my ps ax and none of my database processes
> > > are started.
> > >
> > > I have discovered that if I run dbassist and select the reconfigure
> > > option, select the database and hit the next button, the database
> > > processes are then started. Obviously, there is something in this UI
> > > that starts the process. I don't know what that command would be as I
> > > am new to unix.
> > >
> > > Does anyone know what I am missing in my start up script?
> > >
> > > Any help would be appreciated. Thanks in advance!
> > > Audrey
Received on Mon Sep 16 2002 - 11:55:15 CDT