Windows autostart problem
- From: Joe <nigel.tufnel1@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 25 May 2005 10:02:16 -0400
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'
--
//www.freelists.org/webpage/oracle-l
Other related posts:
