ITPub博客

首页 > 数据库 > Oracle > ORA-00600: internal error code, arguments: [kokle_lob2lob13:input mismatch], [1]

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

原创 Oracle 作者:huakaibird 时间:2006-10-14 15:51:24 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 表空间基本操作
请登录后发表评论 登录
全部评论
  • 博文量
    41
  • 访问量
    421460