RE: DB shutdown - NT

Paul,

But where is this patchset. It's not on Metalink or the ftp sites.

Saul Solomon
PPG Industries
ssolomon_at_ppg.com

-----Original Message-----
Sent: Wednesday, June 13, 2001 10:06 AM
To: Multiple recipients of list ORACLE-L

"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: Paul Drake
  INET: paled_at_home.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Solomon, Saul M.
  INET: ssolomon_at_ppg.com

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