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
May 10th, 2011 at 4:27 pm
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.
May 10th, 2011 at 11:05 pm
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
June 10th, 2011 at 9:51 am
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
June 10th, 2011 at 11:30 am
I really enjoyed reading your Posts.Keep Going
Sriram Sanka
http://sriramoracle.wordpress.com