1 Reply Latest reply: Nov 9, 2012 10:49 AM by Levi Pereira RSS

    SET_ENQUEUE_DESTINATION : ORA-00600: [knlCanonicalize:4]

    973533
      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)