Instance Crashed After ORA-07445 [ksrconsume] (Doc ID 970772.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.8 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

LGWR encounters the following error and as a result the instance crashed:

ORA-07445: exception encountered: core dump [ksrconsume()+665] [SIGFPE] [ADDR:0xA561D3] [PC:0xA561D3] [Integer divide by zero] []


As LGWR crashed, FSF could not fail over the instance.

Problem is not specific to LGWR and it may affect also others processes.

The trace file of the process that hit the ORA-7445 [ksrconsume] shows a 'broadcast handle' state object where the event count has rapped ("messages published: 0"), for example:

 The broadcast channel state object shows:
   ----------------------------------------
   SO: 9566d6110, type: 11, owner: 95601cb08, flag: INIT/-/-/0x00
   (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 95601cb08,
      mask: (0, 0, 0),
      event: 4304510807, last message event: 4304517007,
       last message waited event: 4304517007, messages read: 334528670
       channel: (4f0bbbe28) AQ post/wait channel 1
            scope: 200, event: 4304517007, last message event: 4304517007,
                    publishers/subscribers: 27/1,
                    messages published: 0   <<<< Notice zero here ****
   ----------------------------------------

 


 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms