ORA-600(kokegPinLob1)错误

客户10.2.0.5 Oracle for AIX系统中,出现了这个ORA-600错误。
其中错误信息为:

Fri Nov 18 19:50:18 GMT+08:00 2011Errors IN file /oracle/admin/ccicwmix/udump/ccicwmix_ora_4915530.trc:
ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []

对应的详细TRACE文件:

*** ACTION NAME:() 2011-11-18 19:50:18.033
*** MODULE NAME:(JDBC Thin Client) 2011-11-18 19:50:18.033
*** SERVICE NAME:(SYS$USERS) 2011-11-18 19:50:18.033
*** SESSION ID:(859.5) 2011-11-18 19:50:18.033
*** 2011-11-18 19:50:18.033
ksedmp: internal OR fatal error
ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []
CURRENT SQL statement FOR this SESSION:
SELECT * FROM (  SELECT task.jobid || '-' || task.stepid || '-' || task.taskid ID, task.code WBSNO, (SELECT wmsys.wm_concat(chr(10) || '(' || to_char(logdate,'yyyy-mm-dd') || ')[' || to_char(ACTUALHOURS,'fm990.099') || 'H]' || chr(13) || substr(remark,0,200)) ll.jobid=task.jobid AND ll.stepid=task.stepid AND ll.taskid=task.taskid AND logdate BETWEEN to_date(:1, 'yyyy-MM-dd') AND to_date(:2, 'yyyy-MM-dd')) detaildesc, ……)ORDER BY wbsno
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex      
location             TYPE     point                (? means dubious VALUE)     
-------------------- -------- -------------------- ----------------------------
ksedst+001c          bl       ksedst1              FFFFFFFFFFF7EA0 ? 104CCE8A4 ?
ksedmp+0290          bl       ksedst               104C251D0 ?
ksfdmp+02d8          bl       03F397B4             
kgerinv+00dc         bl       _ptrgl               
kgesinv+0020         bl       kgerinv              FFFFFFFFFFF8BD0 ? 000000000 ?
                                                   FFFFFFFFFFF8A40 ?
                                                   44A420288A5DC2D8 ?
                                                   102A34300 ?
ksesin+006c          bl       kgesinv              00000035B ? 50000000540A0 ?
                                                   700000188E6FAB0 ? 1108EFE30 ?
                                                   FFFFFFFFFFF8AD0 ?
kokegPinLob+00dc     bl       ksesin               104EE00D8 ? 000000000 ?
                                                   70000017FC8F488 ? 6BEC7DDB1 ?
                                                   000000000 ? 0F93A79B9 ?
                                                   09E377EB9 ?
                                                   FFFFFFFFFFFFFFFA ?
kokegCollectGarbage  bl       kokegPinLob          1104208E0 ? 000000011 ?
FromScalar+004c                                    000000009 ?
kokegGarbageCollect  bl       kokegCollectGarbage  FFFFFFFFFFF8C90 ? 000000000 ?
Rworo+008c                    FromScalar           35B00050000 ? 500018C54E1F0 ?
rworupo+0648         bl       kokegGarbageCollect  201000300000000 ?
                              Rworo                FFFFFFFF00001FE8 ?
qersoFetch+0e18      bl       03F38D08             
kpofrws+019c         bl       _ptrgl               
opifch2+13a4         bl       01FC83C0             
opifch+003c          bl       opifch2              1100D4610 ? 000000000 ?
                                                   FFFFFFFFFFF9BC0 ?
opiodr+0b2c          bl       _ptrgl               
ttcpip+1020          bl       _ptrgl               
opitsk+117c          bl       01FC7F78             
opiino+09d0          bl       opitsk               0FFFFD670 ? 000000000 ?
opiodr+0b2c          bl       _ptrgl               
opidrv+04a4          bl       opiodr               3C102A9A18 ? 404C780A0 ?
                                                   FFFFFFFFFFFF630 ? 0102A9A10 ?
sou2o+0090           bl       opidrv               3C02A2D6DC ? 4A0071248 ?
                                                   FFFFFFFFFFFF630 ?
opimai_real+01bc     bl       01FC4434             
main+0098            bl       opimai_real          000000000 ? 000000000 ?
__start+0070         bl       main                 000000000 ? 000000000 ?
--------------------- Binary Stack Dump ---------------------

根据报错的查询语句,detaildesc是一个子查询作为列出现在SELECT列表中。和应用程序的开发人员确认detaildesc这个列的类型是CLOB,而这个查询的聚集函数是wmsys.wm_concat。根据MOS上查询的结果,问题指向Bug 9824435 ORA-600 [kokegPinLob1] from aggregate returning a LOB。
确认受影响的版本包括10.2.0.5和11.2.0.2,这个bug在补丁集11.2.0.3和12.1中被解决。显然不可能通过补丁集来解决这个问题。可以在10.2.0.5上直接应用Patch 9824435。

This entry was posted in BUG and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *