Re: inactive instance on server crash

froliol_at_yahoo.com (Louis Frolio) wrote in message news:<94c28610.0410120643.19e924c8_at_posting.google.com>...
> fabrizio <watch.the_at_stars.fr> wrote in message news:<ckgc4n$pnt$1_at_utcnews.utc.fr>...
> > Hello,
> >
> > i am wondering why the instance of a database is inactive after a server
> > powerdown.
> > The server was running when the a 'eletrical breakdown' ocured -sorry
> > for my english. at server restart the instance was inactive.
> >
> > why ?
> > how can i avoid this behaviour ?
> >
> > Fabrice
>
> Depending on what platform you are running you will have different
> options for ensuring an autostart of the Oracle instance when the
> server is brought up. For Unix look at the oratab (if you don't know
> what this is do a Google on it and read up0 file (different locations
> depending on flavor of Unix) and on Windows you need to go into
> services and set several of the Oracle processes to "Automatic"
>
> Louis Frolio

Automatically starting the OracleService..., for the given Oracle instance, does little good if the service has not been configured to also start the instance. This is where oradim needs to be run, and ,if my memory serves me correctly:

oradim -startup -sid <sid> -startmode a -starttype srvc,inst -pfile <your init.ora file name, including path>

This will configure the service to start the instance when the service starts, giving you a running instance at reboot.

Just what you want, if I read this correctly.

David Fitzjarrell Received on Tue Oct 12 2004 - 15:06:36 CDT