【Oracle故障】ORA-00600: internal error code, arguments: [kole_t2u], [34]

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:252

【Oracle故障】ORA-00600: internal error code, arguments: [kole_t2u], [34]

最近数据库一直出现以下报错:ksedmp: internal or fatal errorORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []Current SQL statement for this session:INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, ref_count) SELECT sqlid_kewrstx, :dbid, sqlfulltext_kewrstx, cmdtype_kewrstx, :lah_snap_id, 0 ref_count FROM x$kewrtsqltext 经分析,该报错由MMON进程对wrh$_sqltext表做insert操作时发生。通过查询metalin后,发现这个错误与Bug 5970258 : ORA-600[KOLE_T2U],[34] IN MMON一致,由于错误只与V$sql等性能视图有关,因此不会影响应用数据,这个问题在Oracle 11.1版本中修复。 metalink文档描述如下: Bug 5970258 : ORA-600[KOLE_T2U],[34] IN MMON Bug 属性: 类型 B - Defect 已在产品版本中修复 11.1严重性 2 - Severe Loss of Service 产品版本 10.2.0.3状态 36 - Duplicate Bug. To Filer 平台 226 - Linux x86-64创建时间 2007-4-3 平台版本 更新时间 2007-5-23 基本 Bug 5017909数据库版本 10.2.0.3 影响平台 Generic产品源 Oracle 相关产品: 产品线 Oracle Database Products 系列 Oracle Database区域 Oracle Database 产品 5 - Oracle Server - Enterprise Edition Hdr: 5970258 10.2.0.3 RDBMS 10.2.0.3 SQL EXECUTION PRODID-5 PORTID-226 ORA-600 5017909Abstract: ORA-600[KOLE_T2U],[34] IN MMON*** 04/03/07 12:42 am ***TAR:---- PROBLEM:--------ORA-600[kole_t2u],[34] occued in MMON Process.Ct's system is 3node-RAC.I can't find regularity of the error occurrence. - alert_TESTUPDB1.log Tue Mar 6 20:03:48 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_26623.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Wed Mar 7 11:00:08 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_2210.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 9 21:00:12 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_18441.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 9 22:00:15 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_28526.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Tue Mar 13 22:00:26 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_19033.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Wed Mar 14 22:00:28 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m001_8280.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 23 14:00:49 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_30466.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] - alert_TESTUPDB2.log Tue Mar 6 20:00:29 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_31658.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Tue Mar 6 21:00:04 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_13170.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 9 20:03:51 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_28049.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 9 21:03:20 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_8302.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Mon Mar 12 19:03:23 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_27892.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] Mon Mar 12 20:00:16 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m001_10361.trc:ORA-600: [kole_t2u],[34],[],[],[],[],[],[] - alert_TESTUPDB3.log Tue Mar 6 18:00:35 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb3_m000_16392.trc:ORA-600: ?à???G???[?E?R?[?h?A????: [kole_t2u],[34],[],[],[],[],[],[] Fri Mar 9 20:00:06 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb3_m000_2970.trc:ORA-600: ?à???G???[?E?R?[?h?A????: [kole_t2u],[34],[],[],[],[],[],[] Mon Mar 12 13:00:10 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb3_m000_836.trc:ORA-600: ?à???G???[?E?R?[?h?A????: [kole_t2u],[34],[],[],[],[],[],[] Mon Mar 12 19:00:18 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb3_m000_6577.trc:ORA-600: ?à???G???[?E?R?[?h?A????: [kole_t2u],[34],[],[],[],[],[],[] Tue Mar 13 12:00:16 2007Errors in file /oracle/oradata/test/testupdb/bdump/testupdb3_m001_1219.trc:ORA-600: ?à???G???[?E?R?[?h?A????: [kole_t2u],[34],[],[],[],[],[],[] DIAGNOSTIC ANALYSIS:--------------------The next insert statement is shown as Current SQL in all MMON traces. INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, ref_count) SELECT sqlid_kewrstx, :dbid, sqlfulltext_kewrstx, cmdtype_kewrstx, :lah_snap_id, 0 ref_count FROM x$kewrtsqltext WORKAROUND:-----------none RELATED BUGS:-------------Bug:5921509 REPRODUCIBILITY:----------------Sometimes in CT's site TEST CASE:----------none STACK TRACE:------------ SUPPORTING INFORMATION:----------------------- 24 HOUR CONTACT INFORMATION FOR P1 BUGS:----------------------------------------none DIAL-IN INFORMATION:--------------------none IMPACT DATE:------------none *** 04/03/07 12:45 am ****** 04/03/07 01:43 am *** *** 04/03/07 10:36 pm ****** 04/03/07 11:08 pm ****** 04/03/07 11:29 pm *** (CHG: Sta->10)*** 04/03/07 11:29 pm ****** 04/10/07 05:20 am *** (CHG: Sta->16)*** 04/10/07 05:20 am ****** 04/10/07 07:18 pm ****** 04/10/07 07:22 pm ****** 04/10/07 07:22 pm *** *** 04/10/07 07:23 pm *** (CHG: Sta->11)*** 04/10/07 07:24 pm *** *** 04/10/07 07:24 pm ****** 04/10/07 10:32 pm *** (CHG: Sta->30)*** 04/10/07 10:32 pm ****** 04/10/07 10:34 pm *** *** 04/10/07 10:34 pm ****** 04/10/07 11:40 pm ****** 04/13/07 01:12 am ****** 05/22/07 10:04 pm *** *** 05/22/07 10:04 pm *** *** 05/22/07 10:04 pm *** (CHG: Sta->36)*** 05/22/07 10:04 pm ***

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】