Tuesday, June 18, 2013

ORA-00600 [kwqitnmphe:ltbagi]

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file. This issue arises on 11.2.0.2 is fixed on 11.2.0.3 but if the db has been upgraded from 11.2.0.2 -> 11.2.0.3 its also valid.

In order to be able to use the proposed workaround verify the issue :

1.

Inside the trace file reported in alert log you find :

Error 600 in Queue Table SYS.SCHEDULER$_EVENT_QTAB

2.
connect / as sysdba
Run:
select object_type from dba_objects where owner='SYS' and object_name='SCHEDULER$_EVENT_QTAB_HIST';

You should see :

OBJECT_TYPE
-------------------
INDEX


Solution :

connect / as sysdba

Drop the problematic index

drop index sys.scheduler$_event_qtab_hist;


Purge all messgaes in the queue along ith the problematic data

DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'SYS.scheduler$_event_qtab',
purge_condition => NULL,
purge_options => po);
END;
/


Recompile all invalid objects

@?/rdbms/admin/utlrp.sql




3 comments: