Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database not starting automatically (Win NT)

Database not starting automatically (Win NT)

From: Pinto <ucanmailme_at_india.com>
Date: Thu, 16 May 2002 19:32:05 +0530
Message-ID: <ac0e60$1u0$1@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. Received on Thu May 16 2002 - 09:02:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US