Re: How to startup database automatically?

"Deniko" <deniko_momoto_at_hotmail.com> wrote in message news:16c9fbd5.0110190615.4136e1f7_at_posting.google.com...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<tsuhko8lqjca5e_at_corp.supernews.com>...
>
> > Please check out the manual, in this case the getting started manual for
> > your platform, and please do so before posting any question, or you will
be
> > responded with that famous FLA.
> > You need to change the OracleService<SID> to startup automatic, not
manual.
> >
> > Regards,
> >
> > Sybrand Bakker
> > Senior Oracle DBA
>
> Sybrand,
>
> The problem is everything (include OracleService<SID>) in the service
> panel start automatic in my machine (The service panel reflect all
> Oracle services are running), that's why I've no idea why I still have
> to do it manually using sqlplus.
>
> The manual didn't address this kind of problem. I've look through the
> forum and seems that some people also address this concern with Win2K
> platform. They all have to run it manually (or write a bat file) to
> start up the database.
>
> If anyone know if there's another solution to this, please let me
> know.
> Thanks alot!!
>
> Regards,
> Deniko

If they are set to automatically, the startup *fails* You need to look at errors in the alert_<SID>.log which is typically located in the directory pointed to by the background_dump_dest parameter in the init<sid>.ora file. Or there is a service problem, usually an incorrect password, which should be reported in the oradim.log file.
The latter error seems the most likely as you can start the database manually

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 19 2001 - 12:27:53 CDT