bug-5970258
早上有客户系统报告，数据库里600错误，报错如下：
ORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []
查看trace文件有如下信息
/u01/app/oracle/admin/lzrac/bdump/lzrac1_m000_29992.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db
System name: Linux
Node name: lzrac1
Release: 2.6.9-42.ELlargesmp
Version: #1 SMP Wed Jul 12 23:46:39 EDT 2006
Machine: x86_64
Instance name: lzrac1
Redo thread mounted by this instance: 1
Oracle process number: 40
Unix process pid: 29992, image: <a href="mailto:oracle@lzrac1">oracle@lzrac1</a> (m000)
*** ACTION NAME:(Remote-Flush Slave Action) 2009-01-17 01:00:27.388
*** MODULE NAME:(MMON_SLAVE) 2009-01-17 01:00:27.388
*** SERVICE NAME:(SYS$BACKGROUND) 2009-01-17 01:00:27.388
*** SESSION ID:(3145.11960) 2009-01-17 01:00:27.388
*** 2009-01-17 01:00:27.388
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
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FBFFEF370 ? 7FBFFEF3D0 ?
7FBFFEF310 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
。。。。。。。。
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
*** KEWROCISTMTEXEC - encountered error: (ORA-00600: internal error code, arguments: [kole_t2u],
[34], [], [], [], [], [], []
)
*** SQLSTR: total-len=211, dump-len=211,
STR={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}
*** KEWRAFM1: Error=13509 encountered by kewrfteh
经查询METALINK，确认为BUG 5970258，只有到11G才能修复，目前来看问题不大
相关文档ID:553528.1
ORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []
查看trace文件有如下信息
/u01/app/oracle/admin/lzrac/bdump/lzrac1_m000_29992.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db
System name: Linux
Node name: lzrac1
Release: 2.6.9-42.ELlargesmp
Version: #1 SMP Wed Jul 12 23:46:39 EDT 2006
Machine: x86_64
Instance name: lzrac1
Redo thread mounted by this instance: 1
Oracle process number: 40
Unix process pid: 29992, image: <a href="mailto:oracle@lzrac1">oracle@lzrac1</a> (m000)
*** ACTION NAME:(Remote-Flush Slave Action) 2009-01-17 01:00:27.388
*** MODULE NAME:(MMON_SLAVE) 2009-01-17 01:00:27.388
*** SERVICE NAME:(SYS$BACKGROUND) 2009-01-17 01:00:27.388
*** SESSION ID:(3145.11960) 2009-01-17 01:00:27.388
*** 2009-01-17 01:00:27.388
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
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FBFFEF370 ? 7FBFFEF3D0 ?
7FBFFEF310 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
。。。。。。。。
KSOLS: Begin dumping all object level stats elements
KSOLS: Done dumping all elements. Exiting.
Dump event group for SESSION
Dump event group for SYSTEM
*** KEWROCISTMTEXEC - encountered error: (ORA-00600: internal error code, arguments: [kole_t2u],
[34], [], [], [], [], [], []
)
*** SQLSTR: total-len=211, dump-len=211,
STR={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}
*** KEWRAFM1: Error=13509 encountered by kewrfteh
经查询METALINK，确认为BUG 5970258，只有到11G才能修复，目前来看问题不大
相关文档ID:553528.1
