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

From: <Jared.Still_at_radisys.com>
Date: Thu, 03 Apr 2003 11:24:01 -0800
Message-ID: <F001.00579B34.20030403112401@fatcity.com>

Gary,

Check doc # 136214.1 on MetaLink.

There are some other non-Oracle reg entries that affect shutdown.

Jared

"Gary W. Parker" <garywp_at_ev1.net>
Sent by: root_at_fatcity.com
04/03/2003 09:03 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Oracle 8i Service Shutdown Crashes Database on Win2K

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

--

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

Author:
INET: Jared.Still_at_radisys.com

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