RE: DB shutdown

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 13 Jun 2001 17:28:55 -0700
Message-ID: <F001.00328AED.20010613163544@fatcity.com>

Sean,

Added to Paul's good list of registry values. I have used svrmgrl to do a shutdown immediate and then a startup and still seen recovery in the alert log.
That is, to me, the presence of "Beginning crash recovery" in the alert log does not imply the shutdown was not an immediate one.

I would rather check the alert log for "Shutting down instance (immediate)" to confirm the shutdown type.

Regards,
Bruce

-----Original Message-----
Sent: Thursday, 14 June 2001 12:06

"O'Neill, Sean" wrote:
>
> I'm trying to configure systems to shutdown immediate Oracle when NT
server
> is shutdown. I've followed instructions in Admin manual for registry
> settings and being trying it on Oracle PE 8.1.7.0.0 but it don't appear to
> work. Oracle does crash recovery when PC [NT4-SP6a] is bounced. Current
> registry settings are:
> ora_DBATest_shutdown = TRUE
> ora_DBATest_shutdowntype = i
> ora_DBATest_shutdown_timeout = 30
>
> I'd like to get this working for the following versions of Oracle on our
> production NT servers. Maybe a patch set is required, is so I'd
appreciate
> patch set ID. If it can't be done for particular version please let me
> know.
> 7.3.3.0.0
> 8.0.5.0.0
> 8.1.7.0.0
>
> I could spend a "while" trying to look all this up on MetaLink but if
anyone
> has "been there" would appreciate your input!
>
> Sean :)
>

Sean,

this is for 8.1.7.1.2

HKLM\Software\Oracle\Home0

Value 3

  Name:            ORA_DEV_AUTOSTART
  Type:            REG_EXPAND_SZ
  Data:            TRUE
 
Value 4
  Name:            ORA_DEV_PFILE
  Type:            REG_EXPAND_SZ
  Data:            D:\Oracle\admin\DEV\pfile\initDEV.ora
 
Value 5
  Name:            ORA_DEV_SHUTDOWN
  Type:            REG_EXPAND_SZ
  Data:            TRUE
 
Value 6
  Name:            ORA_DEV_SHUTDOWN_TIMEOUT
  Type:            REG_EXPAND_SZ
  Data:            180                                  << 30 seconds is not

sufficient

Value 7

  Name:            ORA_DEV_SHUTDOWNTYPE
  Type:            REG_EXPAND_SZ
  Data:            i

Please patch 8.1.7.0.0 to at least 8.1.7.0.2, I've been using 8.1.7.1.2 for 6 weeks.

Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed Jun 13 2001 - 19:28:55 CDT

RE: DB shutdown - NT