Windows autostart problem

From: Joe <nigel.tufnel1_at_gmail.com>
Date: Wed, 25 May 2005 10:02:16 -0400
Message-ID: <a9a1cff7050525070270094d22@mail.gmail.com>

Hi all,

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),

Joe

=3D=3D=3D=3D
More details:

from "set" at cmd prompt:

ORACLE_HOME=3DN:\ORACLE
LD_LIBRARY_PATH=3DN:\ORACLE\LIB
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

Looks like the 10g registry stuff is in here:

ORACLE\Key_OraDb10g_home1

   ORA_orcl_AUTOSTART =3D TRUE
   ORA_orcl_SHUTDOWN =3D TRUE
   ORA_orcl_SHUTDOWN_TIMEOUT =3D 90
   ORA_orcl_SHUTDOWNTYPE =3D immediate
   ORACLE_BASE =3D N:
   ORACLE_GROUP_NAME =3D Oracle - OraDb10g_home1
   ORACLE_HOME =3D N:\oracle

   ORACLE_HOME_KEY =3D SOFTWARE\ORACLE\KEY_OraDb10g_home1    ORACLE_HOME_NAME =3D OraDb10g_home1
   RDBMS_ARCHIVE =3D N:\oracle\DATABASE\ARCHIVE    RDBMS_CONTROL =3D N:\oracle\DATABASE
   SQLPATH =3D N:\oracle\dbs
   USE_SHARED_SOCKET =3D true

The pfile is N:\oracle\database\initorcl.ora; contents are:

*._allow_level_without_connect_by=3Dtrue
*.background_dump_dest=3D'N:\oracle\admin\orcl\bdump'
*.compatible=3D'10.1.0.3.0'
*.control_files=3D'N:\oracle\oradata\orcl\control01.ctl'
*.core_dump_dest=3D'N:\oracle\admin\orcl\cdump'
*.db_block_size=3D8192
*.db_cache_size=3D335544320
*.db_domain=3D''
*.db_file_multiblock_read_count=3D16
*.db_name=3D'orcl'
*.db_writer_processes=3D1
*.fast_start_mttr_target=3D900
*.instance_name=3D'orcl'
*.java_pool_size=3D67108864
*.job_queue_processes=3D10
*.large_pool_size=3D8388608
*.max_dump_file_size=3D'UNLIMITED'
*.open_cursors=3D300
*.pga_aggregate_target=3D209715200
*.processes=3D150
*.query_rewrite_enabled=3D'FALSE'
*.remote_login_passwordfile=3D'EXCLUSIVE'
*.shared_pool_size=3D335544320
*.star_transformation_enabled=3D'FALSE'
*.timed_statistics=3DTRUE
*.undo_management=3D'AUTO'
*.undo_retention=3D10800
*.undo_tablespace=3D'undo'
*.user_dump_dest=3D'N:\oracle\admin\orcl\udump'
*.WORKAREA_SIZE_POLICY=3D'AUTO'

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 25 2005 - 10:07:07 CDT