I am having a problem with a 10.1.0.3 database not automatically starting up when a box is rebooted. The machine is Windows 2003. There is an old ORACLE_HOME on this box, not sure if that is an issue.
In addition to it not starting, it will not start with the correct init file. The init file I want to use is N:\oracle\database\initorcl.ora - but the database doesn't use it unless I do a "startup pfile=3D" to point to it explicitly.
I also believe I was getting a similar error to Jared's recent post, where it is referencing a pfile in a completely different directory (not sure as it was 4:00am last time this box was rebooted, and was an emergency).
Thanks very much for any help (as I am highly Windows-challenged),
NAME TYPE VALUE -- ---- ---- ---- ---- ---- ---- --- -- ---- --- -- ---- ---- ---- ---- ---= ---- spfile string
SQL> show parameter ifile
NAME TYPE VALUE -- ---- ---- ---- ---- ---- ---- --- -- ---- --- -- ---- ---- ---- ---- ---= ---- ifile file
"OracleServiceorcl" Properties Path to executable: n:\oracle\bin\ORACLE.EXE orcl Startup type: Automatic Log On: Local system account
There is an old installation of Oracle under N:\Oracle9204 that is not used. However, there are still references to this directory in the registry. Here are the relevant registry settings under HKEY_LOCAL_MACHINE\SOFTWARE:
