ORA-00600 [kwqitnmphe:ltbagi] Errors even after the fix for Bug 17831758 and Bug 18536720 is in place
(Doc ID 2002540.1)
Last updated on JULY 20, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
The following error is reported in the Alert log:
ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], , , , , , , , , , , 
The call stack in the trace file written by the error includes the following functions:
kwqitnmphe <- kwqmshise2 <- kwqitnmptme <- kwqmstmgr <- kwqitmmit <- kwqitmmsgs <- kwqitptm <- kwqmnslv <- ksvrdp <- opirip <- opidrv <- sou2o
The error occurs because there are still Historical Messages without a current Subscriber (a.k.a. orphaned entries in the History table), and can be confirmed by the following SQL statement:
select sub_hist.NAME, sub_hist.SUBSCRIBER#, sub_hist.MSGID, msg.QUEUE, msg.MSG_STATE from AQ$_SYS$SERVICE_METRICS_TAB_H sub_hist, AQ$SYS$SERVICE_METRICS_TAB msg where sub_hist.MSGID = msg.MSG_ID and NOT EXISTS (select sub.SUBSCRIBER_ID from aq$_SYS$SERVICE_METRICS_TAB_s sub where sub_hist.subscriber# = sub.SUBSCRIBER_ID) ;
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