Getting ORA-600 [kcbgcur_3] When Creating a Queue Table (Doc ID 555035.1)

Last updated on AUGUST 01, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Feb-2012***


Symptoms

Trying to create a Queue table and it fails with :

ORA-00600: internal error code, arguments: [kcbgcur_3]

SQL STATEMENT executed

begin
dbms_aqadm.create_queue_table(queue_table => '<owner.qtable_name>',
queue_payload_type => '<owner.typename>',
multiple_consumers => TRUE,
comment => 'xxxxxxx',
compatible => '8.1');
end;
/

ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgcur_3], [658814], [1], [0], [0], [], [], []

Changes

There was an attempt to drop the queue_table and it failed with :

ORA-24010 QUEUE <qname> does not exist

A trace file was also generated and showed:

Encountered error when executing :DROP VIEW <owner.AQ$AQ$_qtable_name>_T
Encountered error when executing :DROP VIEW <owner.AQ$_AQ$_qtable_name>_T_F
Encountered error when executing :DROP VIEW <owner.AQ$AQ$_qtable_name>_I
Encountered error when executing :DROP VIEW <owner.AQ$_AQ$_qtable_name>_I_F
Encountered error when executing :DROP VIEW <owner.AQ$AQ$_qtable_name>_H
Encountered error when executing :DROP VIEW <owner.AQ$_AQ$_qtable_name>_H_F
*** 2007-06-15 19:08:37.663
kwqalqt2: Warning !! queue table owner.qtable_name missing

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