MMON Slave Process Reports ORA-7445 [kglic0]/[kksIterCursorStat] Error, Plus Database Hangs
(Doc ID 1487720.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
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.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |