Recently started seeing this error on few of the RAC environments.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], []
As per metalink this is a known Bug 20987661 – Doc ID 20987661.8
DECLARE po dbms_aqadm.aq$_purge_options_t; BEGIN po.block := FALSE; DBMS_AQADM.PURGE_QUEUE_TABLE( queue_table => ‘SYS.SYS$SERVICE_METRICS_TAB’, purge_condition => NULL, purge_options => po); END; /
This works until the database is restarted i.e. we’ll have to execute it every time, we restart the database.
I’ve seen this in 11204 and 12102 both. As per Oracle it’s fixed in version 12.2
