Re: database startup problem

You'll get better ideas if you list the version of oracle and the OS.

Start up a command prompt, type "path". You'll know the location of the oracle home by something along the lines of %PATH% including:

D:\oracle\product\10.1.0\db_1\bin

(this is where including your oracle version really helps out)

in the directory %ORACLE_HOME%\database look for a file named oradim.log.
most likely you'll find information there, even before the instance starts to write to its respective alert log. Next check the alert log in
%ORACLE_BASE%\admin\%ORACLE_SID%\bdump\alert_%ORACLE_SID%.log

perhaps there is no password file, no spfile, no parameter file for that database.
perhaps your drive mappings have changed. perhaps Nimda ate your database.

hth.

-bdbafh Received on Wed Sep 28 2005 - 22:54:08 CDT