On 5/25/05, Joe <nigel.tufnel1@(protected)> wrote: > > Hi all, > > I am having a problem with a 10.1.0.3 <http://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.
It might well be, see later.
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.
you should be able to deal with these two issues by issuing
oradim -edit -sid orcl -pfile N:\oracle\database\initorcl.ora -startmode auto -srvcstart system
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).
More details: > > from "set" at cmd prompt: > > ORACLE_HOME=3DN:\ORACLE > LD_LIBRARY_PATH=3DN:\ORACLE\LIB
You don't need LD_LIBRARY_PATH set as an environment variable in windows, you shouldn't need ORACLE_HOME in your system environment variables either.
Path=3DN:\oracle\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files= > \Oracle > > \jre\1.1.8\bin;N:\oracle\bin;N:\oracle\jre\1.4.2\bin\client;N:\oracle\jre\1= > .4.2\ > bin;C:\Program Files\VERITAS\NetBackup\bin\;C:\Program Files\Windows > Resour= > ce Ki > ts\Tools\;C:\Program Files\Support > Tools\;C:\WINNT\system32;C:\WINNT;C:\WIN= > NT\Sy > stem32\Wbem;C:\cygwin\bin;C:\Program Files\Quest Software\Foglight > Client\c= > onfig > \weblogic\Windows2003\bin;; > > > SQL> show parameter pfile > > 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: > > ORACLE > API =3D N:\oracle9204\dbs > inst_loc =3D C:\Program Files\Oracle\Inventory > ORA_CRS_HOME =3D N:\oracle > ORACLE_GROUP_NAME =3D Oracle - OraDb9204_home2 > ORACLE_HOME =3D N:\oracle9204 > ORACLE_HOME_NAME =3D OraDb9204_home2 > > ORACLE\ALL_HOMES > DEFAULT_HOME =3D OraDb9204_home2 > HOME_COUNTER =3D 1 > LAST_HOME =3D 0 > > ORACLE\ALL_HOMES\ID0 > NAME =3D OraDb9204_home2 > PATH =3D N:\oracle9204 > > ORACLE\HOME0 > ORA_orcl_AUTOSTART =3D FALSE > ORA_orcl_SHUTDOWN =3D TRUE > ORA_orcl_SHUTDOWN_TIMEOUT =3D 30 > ORA_orcl_SHUTDOWNTYPE =3D i > ORACLE_BASE =3D N:\oracle9204 > ORACLE_GROUP_NAME =3D Oracle - OraDb9204_home2 > ORACLE_HOME =3D N:\oracle9204 > ORACLE_HOME_KEY =3D Software\Oracle\HOME0 > ORACLE_HOME_NAME =3D OraDb9204_home2 > RDBMS_ARCHIVE =3D N:\oracle9204\DATABASE\ARCHIVE > RDBMS_CONTROL =3D N:\oracle9204\DATABASE > SQLPATH =3D N:\oracle9204\dbs
If the install is entirely unused you might consider removing it through the 10g installer.
I'd definitely remove the entries under HKLM\SOFTWARE\ORACLE that relate to the old install
