Re: Database not starting automatically (Win NT)

"Pinto" <ucanmailme_at_india.com> wrote in message news:ac0e60$1u0$1_at_news.mch.sbs.de...
> Hello,
> i had to change the password of internal user of oracle database (8.0.5)
on
> Win NT. i did the following
>
> oradim80 -delete -sid <sid>
> oradim80 -new -sid <sid> -intpwd <pwd> -pfile <pfile path>
>
> it worked fine, but the service oraclestart<sid> vanished from control
panel
> and the DB was not starting automatically when i reboot.
>
> so after this, i did this
>
> oradim80 -delete -sid <sid>
> oradim80 -new -sid <sid> -intpwd <pwd> -startmode auto -pfile <pfile path>
>
> now the service has come back and both oraclestart<sid> and
> oracleservice<sid> start automatically when the system reboots. but oracle
> does not start.
> if i try to connect using sqlplus, i get ora-01034: oracle not available
>
> but if i connect as svrmgr30 and try to start the DB, it works fine.
>
> how can i make it start automatically again.
>
> warm regards,
> Pinto.
>
>

The resolution to this has been posted many times, and I am more and more wondering why people never search the google archives, so the group is forced to answer the same old questions over and over again. After all, with the possible exception of Thomas Kyte, no one in this group is getting paid for it, and many people respond in their spare free time. At least I do.

You need to check the log file of oradim called oradim80.log, IIRC in %ORACLE_HOME%\rdbms80
If that doesn't resolve it, you need to check the alert<SID>.log, located in the directory pointed to by the background_dump_dest init.ora parameter, defaults to %ORACLE_HOME%\rdbms80\trace.

Also if you did change the password, you need to check the strt<sid>.cmd in %ORACLE_HOME%\database.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address