MMON Slave Process Reports ORA-7445 [kglic0]/[kksIterCursorStat] Error, Plus Database Hangs (Doc ID 1487720.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Jul-2015***

Symptoms

When the MMON_SLAVE is attempting to perform an "Auto-Flush Slave Action", one of the following errors may occur:

ORA-07445: exception encountered: core dump [kglic0()+1075] [SIGSEGV] [ADDR:0x18] [PC:0x90F1CFF] [Address not mapped to object] []

- OR -

ORA-07445: exception encountered: core dump [kksIterCursorStat()+596] [SIGSEGV] [ADDR:0x17] [PC:0x5562FEC] [Address not mapped to object] []


Subsequently, the following message can be reported in the Alert log:

PMON failed to acquire latch...


The Call Stack in the MMON_SLAVE trace file at the time of the error shows the following Oracle functions:

... kksIterCursorStat kewrrtsq_rank_topsql kewrbtsq_build_topsql kewrftsq_flush_topsql kewrft_flush_table kewrftec_flush_table_ehdlcx kewrfat_flush_all_tables kewrfos_flush_onesnap kewrfsc_flush_snapshot_c kewrafs_auto_flush_slave...


In the case of the ORA-7445 [kglic0] error, the "kksIterCursorStat" function is preceded by the "kglic0" function in the Call Stack:

... kglic0 kksIterCursorStat kewrrtsq_rank_topsql kewrbtsq_build_topsql kewrftsq_flush_topsql ...


During this time, a database hang may be experienced.

 

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