Getting ORA-600 [kcbgcur_3] When Creating a Queue Table
(Doc ID 555035.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]Oracle Database Cloud Schema 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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |