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
Filed	07-APR-2005	Updated	03-APR-2006
Product	Oracle Server - Enterprise Edition	Product Version	10.1.0.3.0
Platform	Linux x86	Platform Version	2.4.21-20.EL
Database Version	10.1.0.3.0	Affects Platforms	Generic
Severity	Severe Loss of Service	Status	Suspended, Req'd Info not Avail
Base Bug	N/A	Fixed in Product Version	No 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@]

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

相關文章