yhd_my 发表于 2014-11-5 11:14:43

ORA-600 kolrghte: wrong lob type

环境：oracle： RAC 10.2.0.5.0aix    weblogic:10.2.6.0linux
以下是alert中的报错：
ORA-00600: internal error code, arguments: ,...
ORA-00600: internal error code, arguments: ,...

请兄弟们帮着给分析一下，详细日志和trace文件放在附件中。

yhd_my 发表于 2014-11-5 15:31:43

问题初步解决，方法还是metalink上说的，将空的clob值用empty_clob()函数重新update，问题解决了。

xifenfei 发表于 2014-11-5 21:36:01

        ORA-00600 Fetching Row With LOB Column in OCI Application (Doc ID 1418135.1)        To BottomTo Bottom       

In this Document
Symptoms
Cause
Solution


APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
SYMPTOMS

An OCI-based application compiled with the 11.1.0.7 client reading a CLOB field being fetched using OCISmtFetch2 fails with an ORA-00600 .
CAUSE

The CLOB field being fetched needs to be initialized, as when fetching a uninitialized LOB column (ie) without any LOB locator is causing the ORA 600 error.

SOLUTION

Initialize the CLOB field/column with empty_clob(), either on INSERT or after the row is inserted via an UPDATE.

yhd_my 发表于 2014-11-6 00:17:48

xifenfei 发表于 2014-11-5 21:36
ORA-00600 Fetching Row With LOB Column in OCI Application (Doc ID 141 ...

多谢飞总给正确回复。
页: [1]
查看完整版本: ORA-600 kolrghte: wrong lob type