风哥教程

培训 . 交流 . 分享
Make progress together!

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

[复制链接]
内容发布:风哥| 发布时间:2013-12-21 22:50:26
【Oracle故障】ORA-00600: internal error code, arguments: [kole_t2u], [34]

最近数据库一直出现以下报错:
ksedmp: internal or fatal error
ORA-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 5017909
Abstract: 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 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_26623.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Wed Mar  7 11:00:08 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_2210.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Fri Mar  9 21:00:12 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_18441.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Fri Mar  9 22:00:15 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_28526.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Tue Mar 13 22:00:26 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m000_19033.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Wed Mar 14 22:00:28 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb1_m001_8280.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Fri Mar 23 14:00:49 2007
Errors 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 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_31658.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Tue Mar  6 21:00:04 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_13170.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Fri Mar  9 20:03:51 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_28049.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Fri Mar  9 21:03:20 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_8302.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Mon Mar 12 19:03:23 2007
Errors in file /oracle/oradata/test/testupdb/bdump/testupdb2_m000_27892.trc:
ORA-600: [kole_t2u],[34],[],[],[],[],[],[]
Mon Mar 12 20:00:16 2007
Errors 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 2007
Errors 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 2007
Errors 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 2007
Errors 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 2007
Errors 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 2007
Errors 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 ***


上一篇:【ASM数据迁移】两个存储之间采用Oracle RAC ASM进行数据迁移
下一篇:contos linux 6.4安装oracle11g rac的asmlib包在哪里下载?
专业提供Oracle/MySQL/NoSQL/Linux数据库培训与技术支持服务,QQ号:113257174
关注风哥教程微信公众号itpux_com  ,了解本站最新技术资料的分享.

欢迎加QQ群,提供超多高质量Oracle/Unix/Linux技术文档与视频教程的下载。

Oracle/MySQL/Linux群4-5:189070296  150201289  
Oracle/MySQL/Linux群6-8:244609803   522261684   522651731
备注:请勿重复加群,另请注明 from itpux
回复

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

热门文章教程

  • 风哥Oracle数据库巡检工具V1.0(附2.6网页
  • Oracle 12cR2 九大新功能全面曝光_详解云数
  • 实战PHP与MySQL权威指南PDF电子书下载
  • 大数据技术与应用入门培训教程(电子版下载
  • Oracle OCP认证考试IZ0-053题库共712题数据
  • MySQL5权威指南(第3版)PDF电子版下载
快速回复 返回顶部 返回列表