Re: Starting Oracle on Unix Reboot

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 Thu Sep 12 2002 - 15:58:12 CDT