ORA-00600: internal error code, arguments: [kokle_lob2lob13:input mismatch], [1]

huakaibird發表於2006-10-14
Error
erroe解釋

Errors in file /opt/ora10/admin/SID/bdump/SID_m000_3570.trc:
ORA-00600: internal error code, arguments: [kokle_lob2lob13:input mismatch], [1]
, [], [], [], [], [], []



在log中有這個錯誤

查詢該錯誤為This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition


請問這個錯誤具體是什麼，由什麼引起的？

metalink:

一個bug:

Bug No.4292049
Filed07-APR-2005Updated03-APR-2006
ProductOracle Server - Enterprise EditionProduct Version 10.1.0.3.0
PlatformLinux x86Platform Version2.4.21-20.EL
Database Version10.1.0.3.0Affects Platforms Generic
Severity Severe Loss of ServiceStatusSuspended, Req'd Info not Avail
Base BugN/AFixed in Product VersionNo
Data


Problem
statement:

ORA-00600 [KOKLE_LOB2LOB13:INPUT
MISMATCH] 


 
 
 
*** 04/07/05 02:32 pm *** 
TAR: 
---- 
. 
PROBLEM: 
-------- 
Customer began to repeatedly receivs in the alert.log  
ORA-00600 [KOKLE_LOB2LOB13:INPUT MISMATCH] since Feb 22, 2005. 
Doesn't know were is comming from. 
. 
DIAGNOSTIC ANALYSIS: 
-------------------- 
The failing query is : 
. 
SELECT MT.NAME, INST_CHK_METHOD, INST_CHK_LOGIC, USG_DET_METHOD,  
USG_DET_LOGIC FROM WRI$_DBU_FEATURE_METADATA MT, WRI$_DBU_FEATURE_USAGE FU  
WHERE MT.NAME = FU.NAME AND FU.DBID = :B2 AND FU.VERSION = :B1 ; 
. 
If we replace the bind variables and run the query from sqlplus succeeds. 
See the output in oracle_support.txt. 
. 
SELECT MT.NAME, INST_CHK_METHOD, INST_CHK_LOGIC, USG_DET_METHOD,  
USG_DET_LOGIC  
FROM WRI$_DBU_FEATURE_METADATA MT, WRI$_DBU_FEATURE_USAGE FU  
WHERE MT.NAME = FU.NAME  
AND FU.DBID = 2420437385  
AND FU.VERSION = '10.1.0.3.0'; 
. 
We analyzed the tables WRI$_DBU_FEATURE_METADATA and WRI$_DBU_FEATURE_USAGE  
validate structure cascade, and the indexes envolved and they are ok. 
. 
This is related to AWR. 
Customer wants to know where this query is comming from, and how to stop the  
error. 
. 
WORKAROUND: 
----------- 
. 
RELATED BUGS: 
------------- 
. 
REPRODUCIBILITY: 
---------------- 
. 
TEST CASE: 
---------- 
. 
STACK TRACE: 
------------ 
kokle_lob2lob koklCreateTempLob kokleva evaopn2 opifcr qertbFetchByRowID       
 qerjotFetch opifch2  
. 
SUPPORTING INFORMATION: 
----------------------- 
. 
24 HOUR CONTACT INFORMATION FOR P1 BUGS: 
---------------------------------------- 
. 
DIAL-IN INFORMATION: 
-------------------- 
. 
IMPACT DATE: 
------------ 
. 
*** 04/10/05 10:24 pm *** (CHG: Asg->NEW OWNER) 
*** 04/10/05 10:24 pm *** 
*** 04/12/05 04:06 am *** (CHG: Sta->11 SubComp->LOB ACCESS) 
*** 04/12/05 04:06 am *** 
*** 04/12/05 04:08 am *** 
*** 04/12/05 04:09 am *** (CHG: Asg->NEW OWNER) 
*** 04/12/05 07:39 pm *** (CHG: DevPri->2) 
*** 04/12/05 07:39 pm *** (CHG: Confirmed Flag->Y) 
*** 04/12/05 07:39 pm *** (CHG: Sta->30) 
*** 04/12/05 07:39 pm *** 
*** 04/12/05 07:41 pm *** 
*** 04/12/05 09:45 pm *** 
*** 04/20/05 01:48 pm *** (CHG: Sta->33) 
*** 04/20/05 01:48 pm *** 
*** 04/21/05 06:35 am *** (CHG: Sta->11) 
*** 04/21/05 06:35 am *** 
*** 04/21/05 09:43 am *** (CHG: Sta->30) 
*** 04/21/05 09:43 am *** 
*** 04/21/05 11:40 am *** (CHG: Sta->11) 
*** 04/21/05 11:40 am *** 
*** 04/21/05 02:46 pm *** (CHG: Sta->30) 
*** 04/21/05 02:46 pm *** 
*** 05/04/05 01:35 pm *** (CHG: Sta->33) 
*** 03/31/06 01:25 pm *** (CHG: Sta->11) 
*** 03/31/06 01:25 pm *** 
*** 03/31/06 05:41 pm *** (CHG: Sta->33) 
*** 03/31/06 05:41 pm *** 
*** 04/03/06 06:57 am ***
[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/545828/viewspace-872074/，如需轉載，請註明出處，否則將追究法律責任。

相關文章