问题描述
客户的数据库出现ORA-600错误,错误函数为1265。
数据库版本为10.2.0.4 for Linux,错误信息为:
Fri Aug 26 22:00:11 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] Fri Aug 26 22:00:13 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] Fri Aug 26 22:00:13 2011 Trace dumping IS performing id=[cdmp_20110826220013] Fri Aug 26 22:00:14 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-06512: at "USER1.P_PRO", line 5 ORA-04088: error during execution OF TRIGGER 'USER1.P_PRO' Fri Aug 26 22:00:15 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-06512: at "USER1.P_PRO ", line 5 ORA-04088: error during execution OF TRIGGER 'USER1.P_PRO' ORA-06512: at "USER1.U_PRO ", line 25 Fri Aug 26 22:00:17 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-02067: TRANSACTION OR SAVEPOINT ROLLBACK required Fri Aug 26 22:00:18 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [17281], [600], [0x2E134EEC0], [], [], [], [], [] ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] ORA-02067: TRANSACTION OR SAVEPOINT ROLLBACK required
专家解答
这个错误是ORA-600[1265]错误引发的,随后还出现了ORA-600[17281]、ORA-4088和ORA-2067错误。其中ORA-2067的描述为:
$ oerr ora 2067 02067, 00000, "transaction or savepoint rollback required" // *Cause: A failure (typically a TRIGGER OR stored PROCEDURE WITH multiple // remote updates) occurred such that the all-or-nothing execution // OF a previous Oracle CALL cannot be guaranteed. // *Action: ROLLBACK TO a previous SAVEPOINT OR ROLLBACK the TRANSACTION // AND resubmit.
从这个描述和Oracle的报错信息不难判断,Oracle在通过触发器更新远端表时引发了这个600错误。
根据Oracle的MOS文档Bug 5655419 Distributed transaction hits ORA-600:[1265] or ORA-600:[k2gget: downgrade] in 10.2的描述,这个错误和分布式事务有关,确认影响的版本就是当前环境的10.2.0.4。这个错误的产生一般与窗口维护有关,可以看到问题的发生时刻恰好是22点,从这个时刻开始,Oracle进入维护窗口,进行空间回收统计信息收集等后台工作,显然就是因为窗口的变化导致了这个错误的产生。
Oracle在11.1.0.6中FIXED了这个bug。除了版本升级外,可以考虑将包含分布式事务修改的程序放到远离时间窗口改变时间。
最后修改时间:2019-04-14 11:00:40
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。