Oracle-L: Oracle 8i Service Shutdown Crashes Database on Win2K

From: Gary W. Parker <garywp_at_ev1.net>
Date: Thu, 03 Apr 2003 09:03:52 -0800
Message-ID: <F001.005797F8.20030403090352@fatcity.com>

Gurus,

I am running Oracle 8.1.7.4.1 on a Win2K Advanced Server platform using 2 ZEON P4 processors.

The problem I have is that when I stop the Service for the DB (OracleServiceLIMS), it crashes the database instead of performing a clean shutdown.

The registry entry is set to allow 5 minutes for the shutdown to complete, yet the system behaves as if the entry is not there. The registry entries are as follows:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0

  ORA_LIMS_AUTOSTART:REG_EXPAND_SZ:TRUE
  ORA_LIMS_PFILE:REG_EXPAND_SZ:c:\Oracle\admin\LIMS\pfile\initLIMS.ora
  ORA_LIMS_SHUTDOWN:REG_EXPAND_SZ:TRUE
  ORA_LIMS_SHUTDOWN_TIMEOUT:REG_EXPAND_SZ:300
  ORA_LIMS_SHUTDOWNTYPE:REG_EXPAND_SZ:i
  ORACLE_BASE:REG_SZ:c:\oracle
  ORACLE_CWD:REG_SZ:c:\Oracle\admin\LIMS\log
  ORACLE_GROUP_NAME:REG_SZ:Oracle - OraHome817
  ORACLE_HOME:REG_SZ:c:\oracle\ora817
  ORACLE_HOME_KEY:REG_SZ:Software\ORACLE\HOME0

ORACLE_HOME_NAME:REG_SZ:OraHome817
ORACLE_SID:REG_SZ:LIMS The service will open the database whenever it's started, but it crashes the DB when the service is stopped.

I have used the ORADIM utility to drop and recreate the service with no change in behavior.

Any suggestions would be appreciated.

TIA GWP
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gary W. Parker
INET: garywp_at_ev1.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Apr 03 2003 - 11:03:52 CST