ORA-00600 kokegPinLob1

alert日志如下：
[code]Thu Feb 13 17:59:05 2014
Errors in file /export/home/oracle/app/oracle/diag/rdbms/
//trace/1_ora_14600.trc (incident=730453):
ORA-00600: \\304\\332\\262\\277\\264\\355\\316\\363\\264\\372\\302\\353, \\262\\316\\312\\375: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /export/home/oracle/app/oracle/diag/rdbms///incident/incdir_730453/_ora_14600_i730453.trc
Errors in file /export/home/oracle/app/oracle/diag/rdbms///incident/incdir_730453/_ora_14600_i730453.trc:
ORA-01013: \\323\\303\\273\\247\\307\\353\\307\\363\\310\\241\\317\\373\\265\\261\\307\\260\\265\\304\\262\\331\\327\\367
ORA-00600: \\304\\332\\262\\277\\264\\355\\316\\363\\264\\372\\302\\353, \\262\\316\\312\\375: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []
Errors in file /export/home/oracle/app/oracle/diag/rdbms///incident/incdir_730453/_ora_14600_i730453.trc:
ORA-01013: \\323\\303\\273\\247\\307\\353\\307\\363\\310\\241\\317\\373\\265\\261\\307\\260\\265\\304\\262\\331\\327\\367
ORA-00600: \\304\\332\\262\\277\\264\\355\\316\\363\\264\\372\\302\\353, \\262\\316\\312\\375: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []
Thu Feb 13 17:59:09 2014
Dumping diagnostic data in directory=[cdmp_20140213175909], requested by (instance=1, osid=14600), summary=[incident=730453].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Feb 13 17:59:10 2014
Sweep [inc][730453]: completed
Sweep [inc2][730453]: completed
Thu Feb 13 17:59:52 2014[/code]
trace文件如下：
[code]Trace file /export/home/oracle/app/oracle/diag/rdbms///trace/1_ora_14600.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /export/home/oracle/app/oracle/product/11.2.0/db
System name: SunOS
Node name:
Release: 5.10
Version: Generic_147440-19
Machine: sun4u
Instance name:
Redo thread mounted by this instance: 1
Oracle process number: 306
Unix process pid: 14600, image: oracle@

*** 2014-02-13 17:59:05.178
*** SESSION ID:(9427.45513) 2014-02-13 17:59:05.178
*** CLIENT ID:() 2014-02-13 17:59:05.178
*** SERVICE NAME:() 2014-02-13 17:59:05.178
*** MODULE NAME:(PL/SQL Developer) 2014-02-13 17:59:05.178
*** ACTION NAME:(SQL 窗口 - select wm_concat(OPERATE_DESC) from ( select listagg() 2014-02-13 17:59:05.178

kokegPinLob1 typ_qeeOpn12 typ_qeeConst407
kokegPinLob1:
kokegPinLob1 loc : ffffffff7aa49ee8offset 0 : 0x24 0xd3 0xb1 0xc9 0x00 0x00 0x00 0x36
kokegPinLob1 refcount 0
kokegPinLob1 flags : offset 0 : 0x02 0x08 0x80 0x03 Incident 730453 created, dump file: /export/home/oracle/app/oracle/diag/rdbms///incident/incdir_730453/_ora_14600_i730453.trc
ORA-00600: 内部错误代码, 参数: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []

Dump file /export/home/oracle/app/oracle/diag/rdbms///incident/incdir_730453/_ora_14600_i730453.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /export/home/oracle/app/oracle/product/11.2.0/db
System name: SunOS
Node name:
Release: 5.10
Version: Generic_147440-19
Machine: sun4u
Instance name:
Redo thread mounted by this instance: 1
Oracle process number: 306
Unix process pid: 14600, image: oracle@

*** 2014-02-13 17:59:05.341
*** SESSION ID:(9427.45513) 2014-02-13 17:59:05.341
*** CLIENT ID:() 2014-02-13 17:59:05.341
*** SERVICE NAME:() 2014-02-13 17:59:05.341
*** MODULE NAME:(PL/SQL Developer) 2014-02-13 17:59:05.341
*** ACTION NAME:(SQL \\264\\260\\277\\332 - select wm_concat(OPERATE_DESC) from ( select listagg() 2014-02-13 17:59:05.341

Dump continued from file: /export/home/oracle/app/oracle/diag/rdbms///trace/_ora_14600.trc
ORA-00600: \\304\\332\\262\\277\\264\\355\\316\\363\\264\\372\\302\\353, \\262\\316\\312\\375: [kokegPinLob1], [], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 730453 (ORA 600 [kokegPinLob1]) ========

*** 2014-02-13 17:59:05.349
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=ct8wm5zz01kmk) -----
select a.show_serial_no,a.serial_id,a.service_content,bb.cc from .........

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst1()+124 CALL skdstdst() FFFFFFFF7FFF0E00 ?
000000002 ? 10CB89050 ?
000000000 ?
FFFFFFFF7FFC8170 ?[/code]
结果查mos，确认为select一个clob字段触发，打上11.2.0.3.5补丁即可（当前为11.2.0.3.4），或者升级到11.2.0.4以上版本即可。
MOS信息如下：
The list below is restricted to show only bugs believed to affect version 11.2.0.3.
Other bugs may affect this version but have not been confirmed as being relevant yet.

There are 2 bugs listed.
NB Bug Fixed Description
13877007 11.2.0.4, 12.1.0.1 ORA-600 [kokegPinLob1] during INSERT to partitioned table with LOB data
10263668 11.2.0.3.5, 11.2.0.3.BP07, 11.2.0.4, 12.1.0.1 ORA-600 [kokegPinLob1] selecting a CLOB

Bug 10263668 ORA-600 [kokegPinLob1] selecting a CLOB

This note gives a brief overview of bug 10263668.
The content was last updated on: 05-JUL-2013
Click here for details of each of the sections below.

Affects:

Product (Component)

Oracle Server (Rdbms)

Range of versions believed to be affected

Versions BELOW 12.1

Versions confirmed as being affected

* 11.2.0.3
* 11.2.0.2

Platforms affected

Generic (all / most platforms affected)

Fixed:

This issue is fixed in

* 12.1.0.1 (Base Release)
* 11.2.0.4 (Future Patch Set)
* 11.2.0.3.5 Database Patch Set Update
* 11.2.0.3 Bundle Patch 7 for Exadata Database
* 11.2.0.3 Patch 6 on Windows Platforms

Symptoms:

Related To:

* Internal Error May Occur (ORA-600)
* ORA-600 [kokegPinLob1]


* Datatypes (LOBs/CLOB/BLOB/BFILE)

Description

This problem can occur in releases where the fix of bug 6843252 is present.
ORA-600 [kokegpinlob1] can occur when selecting a CLOB.

Rediscovery Notes:
ORA-600 [kokegPinLob1] during select of a CLOB may be due to this issue.

Workaround
None

Getting a Fix
Use one of the "Fixed" versions listed above
(for Patch Sets / bundles use the latest version available as
contents are cumulative - the "Fixed" version listed above is
the first version where the fix is included)
or
You can check for existing interim patches here: Patch:10263668