Oracle-L: ORA-7445 "DBW0: terminating instance due to error 472" During SHUTDOWN of Database

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 19 Jun 2002 04:28:22 -0800
Message-ID: <F001.00480FD6.20020619042822@fatcity.com>

Oracle 8.1.7.2
Solaris 2.8
machine SF6800

CASE Intermittent Occurences of ORA-7445 "DBW0: terminating instance due to error 472" during Databse Shutdown

Oracle Corp also Says that "DBW0: terminating instance due to error 472" may be Similar to LGWR Abnormal Termination too

Oracle Corp has Advised setting the Event in the init.ora event='10073 trace name context level 1'

NOTE

db_writer_processes                 integer 1   (DEFAULT)
dbwr_io_slaves                      integer 0   (DEFAULT)

log_buffer=4M

alert_bby01.log :-

Completed: ALTER DATABASE CLOSE NORMAL
Tue Jun 18 02:53:50 2002
ALTER DATABASE DISMOUNT
Tue Jun 18 02:53:50 2002
Errors in file /oracle734/ver817/rdbms/log/bby01_pmon_5617.trc: ORA-07445: exception encountered: core dump [ksupgpcl()+16] [SIGSEGV] [Address not mapped to object] [812] [] [] Tue Jun 18 02:54:11 2002
DBW0: terminating instance due to error 472 Instance terminated by DBW0, pid = 5619
Tue Jun 18 02:56:15 2002
Starting ORACLE instance (normal)

bby01_pmon_5617.TRC SAMPLE

2002-06-18 02:53:49.883
SESSION ID:(1.1) 2002-06-18 02:53:49.881 Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x32c, PC: ksupgpcl()+16
2002-06-18 02:53:50.876 ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [ksupgpcl()+16] [SIGSEGV] [Address not mapped to object] [812] [] [] ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+168 CALL ksedst()+0 310 ? 1 ? FFBEC940 ? FFBEC3E4 ? FFBEC3C8 ? 0 ? ssexhd()+380 CALL ksedmp()+0 3 ? 0 ? 1 ? FFBED060 ? 1 ? 7 ? sigacthandler()+40 PTR_CALL 00000000 B ? FFBED8B8 ? 19FEC00 ? 19FEC00 ? 0 ? 0 ? ksupgpcl()+16 PTR_CALL 00000000 B ? FFBED8B8 ? FFBED600 ? 0 ?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.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).

Received on Wed Jun 19 2002 - 07:28:22 CDT