Kamran Agayev's Oracle Blog

Oracle Certified Master

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

Posted by Kamran Agayev A. on April 15th, 2011

During testing 11g new feature – Flashback Transaction Backout, I got following internal error :


ORA-00600: internal error code, arguments: [ktftb_backout_xids_3], [1], [0],[], [], [], [], [], [], [], [], []


After a little investigation I find out that I got it because of setting “numtxns” parameter incorrectly. I’ve set it to “2” while was backing out only one transaction:


trans_arr xid_array;
trans_arr := xid_array(‘08000C00DA000000’);
dbms_flashback.transaction_backout (
xids            => trans_arr,
options         => dbms_flashback.cascade


Then I realized it and changed the value to “1” and the process succeeded. Instead of returning a readable error, Oracle throws an undefined internall error and there’s no any information on this error at metalink :)

4 Responses to “ORA-00600: internal error code, arguments: [ktftb_backout_xids_3]”

  1. Baxtiyar Says:

    hi Kamran.please help me.I install 11gR2 in solaris 10.When I try to open database (11gR2)

    SQL> alter database open;
    alter database open
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] [][][]…

    thanks very much.

  2. Kamran Agayev A. Says:

    It’s an internal error Baxtiyar. Check the following links:


  3. sriram Sanka Says:

    I am very glad to see your posts.Nice Job.

    “there’s no any information on this error at metalink ”
    But It exists On the Web. http://yangtingkun.itpub.net/post/468/444594


  4. sriram Sanka Says:

    I really enjoyed reading your Posts.Keep Going :)

    Sriram Sanka

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>