oracle注释 kole_t2u,【Oracle故障】ORA-00600: internal error code , arguments: [kole_t2u] , [34]_风哥教程...

【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 ***