QMON Process Reports an ORA-600 [7005] or ORA-7445[kpoopq] or ORA-7445 [kwqmnslv] (Doc ID 2353168.1)

Last updated on JUNE 15, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The following type error is reported by a QMON worker process e.g. q001 in the alert log:

ORA-600 [7005], [0]

ORA-00600: internal error code, arguments: [7005], [0], [], [], [], [], [], [], [], [], [], []

On review of an incident trace generated at the time of the above error (the incident trace referenced in the alert log), the trace has a call stack that includes the call: kponPurgeUnreachLoc.

   ----- Current SQL Statement for this session (sql_id=5udxh0ykgshkb) -----
   select location_name, max(r.reg_id) from reg$ r left outer join
   gv$subscr_registration_stats v on r.reg_id = v.reg_id where location_name
   like 'net8://(%' group by location_name having
   min(current_timestamp-nvl(last_ntfn_sent_time, reg_time)) > :1

----- Call Stack Trace ----- includes calls like:

kprcdt <- kpoalbdf <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute <- kponPurgeUnreachLoc <- kwqmnslv <- ksvrdp

ORA-7445 [kpoopq]

ORA-7445: exception encountered: core dump [kpoopq()+787] [SIGSEGV][ADDR:0x2B23812F6730] [PC:0x1ABDF2F] [Address not mapped to object] []

----- Call Stack Trace ----- includes calls like:

kpoopq <- kpoal8 <- opiodr<- kpoodr <- upirtrc <- upirtr <- kpurcs <- kpurserverparse <- kpureq <- kpuStmtPrep2New <- kpuStmtCachePrepare <- kpureq2 <-OCIStmtPrepare2<- kponPurgeUnreachLoc <- kwqmnslv <- ksvrdp

ORA-7445 [kwqmnslv]

ORA-7445 [kwqmnslv()+1009] [SIGSEGV]

----- Call Stack Trace ----- minimal stack trace includes call:

kwqmnslv