{"id":321,"date":"2011-11-22T23:58:18","date_gmt":"2011-11-22T15:58:18","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=321"},"modified":"2011-11-23T00:25:31","modified_gmt":"2011-11-22T16:25:31","slug":"ora-600kokegpinlob1%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=321","title":{"rendered":"ORA-600(kokegPinLob1)\u9519\u8bef"},"content":{"rendered":"

\u5ba2\u623710.2.0.5 Oracle for AIX\u7cfb\u7edf\u4e2d\uff0c\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002
\n\u5176\u4e2d\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n

Fri Nov 18 19:50:18 GMT+08:00 2011Errors in file \/oracle\/admin\/ccicwmix\/udump\/ccicwmix_ora_4915530.trc:\r\nORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []<\/pre>\n
\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u6587\u4ef6\uff1a<\/p>\n
*** ACTION NAME:() 2011-11-18 19:50:18.033\r\n*** MODULE NAME:(JDBC Thin Client) 2011-11-18 19:50:18.033\r\n*** SERVICE NAME:(SYS$USERS) 2011-11-18 19:50:18.033\r\n*** SESSION ID:(859.5) 2011-11-18 19:50:18.033\r\n*** 2011-11-18 19:50:18.033\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nselect * 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, \u2026\u2026)order by wbsno\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+001c          bl       ksedst1              FFFFFFFFFFF7EA0 ? 104CCE8A4 ?\r\nksedmp+0290          bl       ksedst               104C251D0 ?\r\nksfdmp+02d8          bl       03F397B4             \r\nkgerinv+00dc         bl       _ptrgl               \r\nkgesinv+0020         bl       kgerinv              FFFFFFFFFFF8BD0 ? 000000000 ?\r\n                                                   FFFFFFFFFFF8A40 ?\r\n                                                   44A420288A5DC2D8 ?\r\n                                                   102A34300 ?\r\nksesin+006c          bl       kgesinv              00000035B ? 50000000540A0 ?\r\n                                                   700000188E6FAB0 ? 1108EFE30 ?\r\n                                                   FFFFFFFFFFF8AD0 ?\r\nkokegPinLob+00dc     bl       ksesin               104EE00D8 ? 000000000 ?\r\n                                                   70000017FC8F488 ? 6BEC7DDB1 ?\r\n                                                   000000000 ? 0F93A79B9 ?\r\n                                                   09E377EB9 ?\r\n                                                   FFFFFFFFFFFFFFFA ?\r\nkokegCollectGarbage  bl       kokegPinLob          1104208E0 ? 000000011 ?\r\nFromScalar+004c                                    000000009 ?\r\nkokegGarbageCollect  bl       kokegCollectGarbage  FFFFFFFFFFF8C90 ? 000000000 ?\r\nRworo+008c                    FromScalar           35B00050000 ? 500018C54E1F0 ?\r\nrworupo+0648         bl       kokegGarbageCollect  201000300000000 ?\r\n                              Rworo                FFFFFFFF00001FE8 ?\r\nqersoFetch+0e18      bl       03F38D08             \r\nkpofrws+019c         bl       _ptrgl               \r\nopifch2+13a4         bl       01FC83C0             \r\nopifch+003c          bl       opifch2              1100D4610 ? 000000000 ?\r\n                                                   FFFFFFFFFFF9BC0 ?\r\nopiodr+0b2c          bl       _ptrgl               \r\nttcpip+1020          bl       _ptrgl               \r\nopitsk+117c          bl       01FC7F78             \r\nopiino+09d0          bl       opitsk               0FFFFD670 ? 000000000 ?\r\nopiodr+0b2c          bl       _ptrgl               \r\nopidrv+04a4          bl       opiodr               3C102A9A18 ? 404C780A0 ?\r\n                                                   FFFFFFFFFFFF630 ? 0102A9A10 ?\r\nsou2o+0090           bl       opidrv               3C02A2D6DC ? 4A0071248 ?\r\n                                                   FFFFFFFFFFFF630 ?\r\nopimai_real+01bc     bl       01FC4434             \r\nmain+0098            bl       opimai_real          000000000 ? 000000000 ?\r\n__start+0070         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n
\u6839\u636e\u62a5\u9519\u7684\u67e5\u8be2\u8bed\u53e5\uff0cdetaildesc\u662f\u4e00\u4e2a\u5b50\u67e5\u8be2\u4f5c\u4e3a\u5217\u51fa\u73b0\u5728SELECT\u5217\u8868\u4e2d\u3002\u548c\u5e94\u7528\u7a0b\u5e8f\u7684\u5f00\u53d1\u4eba\u5458\u786e\u8ba4detaildesc\u8fd9\u4e2a\u5217\u7684\u7c7b\u578b\u662fCLOB\uff0c\u800c\u8fd9\u4e2a\u67e5\u8be2\u7684\u805a\u96c6\u51fd\u6570\u662fwmsys.wm_concat\u3002\u6839\u636eMOS\u4e0a\u67e5\u8be2\u7684\u7ed3\u679c\uff0c\u95ee\u9898\u6307\u5411Bug 9824435 ORA-600 [kokegPinLob1] from aggregate returning a LOB\u3002
\n\u786e\u8ba4\u53d7\u5f71\u54cd\u7684\u7248\u672c\u5305\u62ec10.2.0.5\u548c11.2.0.2\uff0c\u8fd9\u4e2abug\u5728\u8865\u4e01\u96c611.2.0.3\u548c12.1\u4e2d\u88ab\u89e3\u51b3\u3002\u663e\u7136\u4e0d\u53ef\u80fd\u901a\u8fc7\u8865\u4e01\u96c6\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u3002\u53ef\u4ee5\u572810.2.0.5\u4e0a\u76f4\u63a5\u5e94\u7528Patch 9824435\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u623710.2.0.5 Oracle for AIX\u7cfb\u7edf\u4e2d\uff0c\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002 \u5176\u4e2d\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a 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], [], [], [], [], [], [], [] \u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u6587\u4ef6\uff1a *** ACTION NAME:() 2011-11-18 19:50:18.033 *** MODULE NAME:(JDBC Thin Client) 2011-11-18 19:50:18.033 … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[236,235,91,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-5b","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/321"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=321"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions"}],"predecessor-version":[{"id":322,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/321\/revisions\/322"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}