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 :

[code]

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

[/code]

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:

[code]

declare
trans_arr xid_array;
begin
trans_arr := xid_array(‘08000C00DA000000’);
dbms_flashback.transaction_backout (
numtxns=>2,
xids            => trans_arr,
options         => dbms_flashback.cascade
);
end;

[/code]

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:

    http://mrrame.blogspot.com/2011/02/ora-00600-internal-error-code-arguments.html
    http://forums.oracle.com/forums/thread.jspa?threadID=1088888

  3. sriram Sanka Says:

    Hi
    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

    Sriram

  4. sriram Sanka Says:

    I really enjoyed reading your Posts.Keep Going :)

    Sriram Sanka
    http://sriramoracle.wordpress.com

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>