Getting ORA-600 [6704] And/Or ORA-25326 (Doc ID 1547140.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

On RDBMS: 11.2.0.3 Oracle Database - Enterprise Edition, OS: Oracle Solaris on SPARC (64-bit) 10

Errors in file /data/oracle/LNRMS1U/admin/diag/diag/rdbms/lnrms1u/LNRMS1U/trace/LNRMS1U_j014_9848.trc:
ORA-12012: error on auto execute of job "RMS_OWNER"."TRADESUMMARY4"
ORA-25326: Array dequeue operation failed for message at index 101
ORA-00600: internal error code, arguments: [6704], [2], [1673829], [16842752], [], [], [], [], [], [], [], []
ORA-25228: timeout or end-of-fetch during message dequeue from RMS_OWNER.TRADESUMMARYQUEUE4
ORA-25228: timeout or end-of-fetch during message dequeue from RMS_OWNER.TRADESUMMARYQUEUE4
ORA-06512: at "RMS_OWNER.PKG_TRADESUMMARY", line 1349

In the trace files we can see actions against this AQ.

dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=0np66hb0hh7su) -----
delete /*+ CACHE_CB("TRADESUMMARYQT3") */ from "RMS_OWNER"."TRADESUMMARYQT3" where rowid = :1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object line object
 handle number name
134d38bf98 619 package body SYS.DBMS_AQ
134f4035c8 1310 package body RMS_OWNER.PKG_TRADESUMMARY
13495e1f00 1 anonymous block

They have 4 different queues named TRADESUMMARYQUEUE1 to TRADESUMMARYQUEUE4

The error is random some times in one queue some times in another

The ANALYZE is not finding any corruption in the queues.
Customer recreate the QUEUES but the error persist


exec DBMS_AQADM.STOP_QUEUE('RMS_OWNER.TRADESUMMARYQUEUE4');
exec DBMS_AQADM.DROP_QUEUE(Queue_name => 'RMS_OWNER.TRADESUMMARYQUEUE4');
exec DBMS_AQADM.DROP_QUEUE_TABLE(Queue_table => 'RMS_OWNER.TRADESUMMARYQT4');
BEGIN DBMS_AQADM.CREATE_QUEUE_TABLE(
  Queue_table => 'RMS_OWNER.TRADESUMMARYQT4',
  Queue_payload_type => 'RMS_OWNER.TRADESUMMARYQUEUEMSGTYPE',
  storage_clause => 'PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 TABLESPACE TRADE_DATA_MD',
  Sort_list => 'ENQ_TIME',
  Compatible => '8.1.3');
END;
/
BEGIN DBMS_AQADM.CREATE_QUEUE(
  Queue_name => 'RMS_OWNER.TRADESUMMARYQUEUE4',
  Queue_table => 'RMS_OWNER.TRADESUMMARYQT4',
  Queue_type => sys.dbms_aqadm.normal_queue,
  Max_retries => 50,
  Retry_delay => 0,
  dependency_tracking => FALSE,
  comment => 'Queue for populating of TradeSummary');
END;
/
exec DBMS_AQADM.START_QUEUE('RMS_OWNER.TRADESUMMARYQUEUE4');

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms