一套10.2.0.2数据库alertlog报错ORA-600 [kole_t2u] [34]:
Tue Jun 28 09:00:19 2011
Errors in file /oracle/oracle/admin/BOCPCS/bdump/bocpcs_m000_6639.trc:
ORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []
部分trace内容:
Dump file /oracle/oracle/admin/BOCPCS/bdump/bocpcs_m000_6639.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/oracle/product/10.2.0.1
System name: SunOS
Node name: cupd15k
Release: 5.10
Version: Generic_139555-08
Machine: sun4u
Instance name: BOCPCS
Redo thread mounted by this instance: 1
Oracle process number: 23
Unix process pid: 6639, image: oracle@cupd15k (m000)
*** ACTION NAME:(Auto-Flush Slave Action) 2011-06-28 09:00:19.109
*** MODULE NAME:(MMON_SLAVE) 2011-06-28 09:00:19.109
*** SERVICE NAME:(SYS$BACKGROUND) 2011-06-28 09:00:19.109
*** SESSION ID:(177.36) 2011-06-28 09:00:19.109
*** 2011-06-28 09:00:19.109
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操作时发生。
经查,这个错误与bug 5017909 - SQL TUNING ADVISOR FAILES WITH ORA-904,ORA-911,ORA-1740一致,由于错误只与V$sql等性能视图有关,因此不会影响应用数据。使用相关补丁可解决该问题。
附metalink说明:
Frequent ORA-00600[kole_t2u] Error Being Reported By MMON [ID 553528.1]
In this Document
Symptoms
Cause
Solution
References
Platforms: 1-914CU;
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.5 to 10.2.0.3 - Release: 10.1 to 10.2
Information in this document applies to any platform.
The following error is reported by MMON and captured in the alert log:
ORA-00600: internal error code, arguments: [kole_t2u], [34], [], [], [], [], [], []
Database character set uses multibyte characters.
V$sqlarea.sql_fulltext/v$sql.sql_fulltext contain incorrect sql statement.
The call stack can look like this:
kole_t2u koklwrite koklc_write kolaslWrite kolaWrite koklwrite qerfxCreateTempClob FromBuff ...
Number of issues have been reported with similar symptoms. Some of them are pasted below :
Bug 5970258 : ORA-600[KOLE_T2U],[34] IN MMON
Bug 6066506 : ORA-600 [KOLE_T2U] OCCURS IN MMON
Bug 6367143 : ORA-600 [KOLE_T2U], [34] EVEN AFTER APPLYING PATCH FOR Bug 4562807
The cause was further diagnosed and each of these bugs was closed as a duplicate to the following:
Bug 5017909 : SQL TUNING ADVISOR FAILES WITH ORA-904,ORA-911,ORA-1740
which mentions the following :
v$sqlarea.sql_fulltest/v$sql.sql_fulltext can contain an incorrect/corrupt sql statement in a multibyte database (i.e if the 1000th byte of the SQL is a multibyte character then the statement will show incorrectly in sql_fulltest). This can affect tools such as SQL tuning advisor which can fail with errors like ORA-00904, ORA-00911, ORA-01740.
To resolve this issue, you may choose any of these options:
1. Apply the 10.2.0.4 or 11.1.0.6 patchset which includes the bug fix.
2. Check for the availability of Patch 5017909 on MetaLink corresponding to your platform.
and database version.
3. If no patch is available, request a patch by creating a service request with Oracle Support.
BUG:4562807 - ORA-00600 ERROR WHEN GIST & THEME TESTING AGAINST BENRI DB DOCS
BUG:5017909 - SQL TUNING ADVISOR FAILS WITH ORA-904, ORA-911, ORA-1740
BUG:5970258 - ORA-600[KOLE_T2U],[34] IN MMON
BUG:6066506 - ORA-600 [KOLE_T2U] OCCURS IN MMON
BUG:6367143 - ORA-600 [KOLE_T2U], [34] EVEN AFTER APPLYING PATCH FOR BUG 4562807
NOTE:5017909.8 - Bug 5017909 - V$SQL / V$SQLAREA.SQL_FULLTEXT corrupt for multibyte
PATCH:5017909 - SQL TUNING ADVISOR FAILES WITH ORA-904,ORA-911,ORA-1740
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20750200/viewspace-701223/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20750200/viewspace-701223/