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@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/545828/viewspace-872074/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/545828/viewspace-872074/