Kamran Agayev’s Oracle Blog

Kamran Agayev’s Oracle Blog

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

Posted by Kamran Agayev A. on April 15, 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:


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;

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 🙂

Advertisements

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

  1. Baxtiyar said

    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. 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 said

    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 said

    I really enjoyed reading your Posts.Keep Going 🙂

    Sriram Sanka
    http://sriramoracle.wordpress.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: