This discussion is archived
1 Reply Latest reply: Nov 9, 2012 8:49 AM by Levi-Pereira RSS

SET_ENQUEUE_DESTINATION : ORA-00600: [knlCanonicalize:4]

973533 Newbie
Currently Being Moderated
Linux X86_64 (RHEL 6.0).
Oracle 11gR2 (11.2.0.1.0)

The database user is XXXX.

When I do :

DBMS_APPLY_ADM.SET_ENQUEUE_DESTINATION
(
rule_name => 'XXXX.REFAAAAAAABBBBBBCCCCCCCCCC1990',
destination_queue_name => 'BROKER_QUEUE'
);

I got : ORA-00600: [knlCanonicalize:4], [], [], [], [], [], [], [], [], [], [], []

As it worked for "shorter" table names, I tried a workaround :

DBMS_APPLY_ADM.SET_ENQUEUE_DESTINATION
(
rule_name => 'REFAAAAAAABBBBBBCCCCCCCCCC1990',
destination_queue_name => 'BROKER_QUEUE'
);

And it worked fine.

The problem did not appened on Oracle 10gR2 (10.2.0.2.0) (RHEL 4.0 x86)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points