Re: Starting Oracle on Unix Reboot

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 Fri Sep 13 2002 - 14:13:11 CDT