From oracle-l-bounce@freelists.org Wed May 25 10:07:07 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4PF77lF006096 for ; Wed, 25 May 2005 10:07:07 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4PF72Ni006075 for ; Wed, 25 May 2005 10:07:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0415A1B2266; Wed, 25 May 2005 09:04:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01201-03; Wed, 25 May 2005 09:04:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7842E1B2238; Wed, 25 May 2005 09:04:04 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dAonbUAlauLeBZ1hUwI0Uu95o+j+/lFh22KV6C/8nRG28Kkoxs3gX+rzyjM+8TgVUv8hCcnJgxrLNbaXFM24K7oVVZfoCCSxx8kpseL3ADFV4+DYP77IJXYEbGhV0hW8oWC1M0LnbEOx/8rssBtg93KKheLviT6pgRFuHpu/w3o= Message-ID: Date: Wed, 25 May 2005 10:02:16 -0400 From: Joe To: Oracle-L@freelists.org Subject: Windows autostart problem In-Reply-To: Mime-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Content-Disposition: inline References: X-archive-position: 20261 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: nigel.tufnel1@gmail.com Precedence: normal Reply-To: nigel.tufnel1@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=UPPERCASE_25_50 autolearn=no version=2.63 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