{"id":1075,"date":"2012-08-05T23:36:15","date_gmt":"2012-08-05T15:36:15","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1075"},"modified":"2012-08-12T23:53:43","modified_gmt":"2012-08-12T15:53:43","slug":"ora-600kssadd_stage-null-parent%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1075","title":{"rendered":"ORA-600(kssadd_stage: null parent)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0\u9891\u7e41\u7684ORA-600(kssadd_stage: null parent)\u9519\u8bef\u3002<br \/>\n\u6570\u636e\u5e93\u7248\u672c\u4e3a10.2.0.5 RAC for AIX\uff0c\u62a5\u9519\u65f6\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Tue Jul 17 14:57:39 2012\r\nErrors in file \/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_307720.trc:\r\nORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []\r\nTue Jul 17 14:57:45 2012\r\nErrors in file \/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_357344.trc:\r\nORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []\r\nTue Jul 17 14:57:56 2012\r\nTrace dumping is performing id=[cdmp_20120717145753]\r\nTue Jul 17 14:58:12 2012\r\nTrace dumping is performing id=[cdmp_20120717145823]\r\nTue Jul 17 15:05:53 2012\r\nTrace dumping is performing id=[cdmp_20120717150633]\r\nTue Jul 17 15:06:42 2012\r\nErrors in file \/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_94700.trc:\r\nORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []\r\nTue Jul 17 15:06:43 2012\r\nTrace dumping is performing id=[cdmp_20120717150643]<\/pre>\n<p>\u76f8\u5173\u7684TRACE\u6587\u4ef6\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>\/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_111068.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\r\nand Real Application Testing options\r\nORACLE_HOME = \/oracle\/10g\/db\r\nSystem name:    AIX\r\nNode name:      ora2\r\nRelease:        1\r\nVersion:        6\r\nMachine:        00CCFD354C00\r\nInstance name: orcl2\r\nRedo thread mounted by this instance: 2\r\nOracle process number: 89\r\nUnix process pid: 111068, image: oracle@ora2\r\n*** ACTION NAME:() 2012-07-17 15:08:42.043\r\n*** MODULE NAME:(gsr.exe) 2012-07-17 15:08:42.043\r\n*** SERVICE NAME:(orcl) 2012-07-17 15:08:42.043\r\n*** SESSION ID:(991.44140) 2012-07-17 15:08:42.043\r\n*** 2012-07-17 15:08:42.043\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []\r\nNo current SQL statement being executed.\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              40D1A9663F9E7ABB ?\r\n                                                   6ED89E14D59386B5 ?\r\nksedmp+0290          bl       ksedst               104A2CDB0 ?\r\nksfdmp+0018          bl       03F2735C\r\nkgerinv+00dc         bl       _ptrgl\r\nkgeasnmierr+004c     bl       kgerinv              11041D938 ? 700000220FFBFC8 ?\r\n                                                   110000770 ? 7000004FDF0C700 ?\r\n                                                   FFFFFFFFFFF89C0 ?\r\nkssadd_stage+0080    bl       kgeasnmierr          110195490 ? 110450040 ?\r\n                                                   104AC46B8 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 7000004F0FA9208 ?\r\nkqreqa+0058          bl       kssadd_stage         105670038 ? 104CF7BA0 ?\r\n                                                   000000000 ? 000000000 ?\r\nkqrpre1+0850         bl       kqreqa               100203514 ? 1101A2B20 ?\r\nkqrpre+001c          bl       kqrpre1              710000770 ? 000000009 ?\r\n                                                   FFFFFFFFFFF9088 ?\r\n                                                   28A4202200000000 ?\r\n                                                   10012AEE4 ? FFFFFFFFFFF9080 ?\r\n                                                   000000000 ? 11022A3E0 ?\r\nopiosq0+009c         bl       kqrpre               000000000 ? 000000000 ?\r\n                                                   000000000 ? 1101A2B20 ?\r\n                                                   FFFFFFFFFFF9198 ? 1104B7C60 ?\r\n                                                   FFFFFFFFFFF9458 ?\r\nkpooprx+0168         bl       opiosq0              4A00000001 ? 000000001 ?\r\n                                                   000000000 ? A40000000000FF ?\r\nkpoal8+0400          bl       kpooprx              FFFFFFFFFFFB964 ?\r\n                                                   FFFFFFFFFFFB680 ?\r\n                                                   5000000050 ? 100000001 ?\r\n                                                   000000000 ? A40000000000A4 ?\r\n                                                   000000000 ? 1103A1AD8 ?\r\nopiodr+0ae0          bl       _ptrgl\r\nttcpip+1020          bl       _ptrgl\r\nopitsk+1124          bl       01F971E8\r\nopiino+0990          bl       opitsk               000000000 ? 000000000 ?\r\nopiodr+0ae0          bl       _ptrgl\r\nopidrv+0484          bl       01F96034\r\nsou2o+0090           bl       opidrv               3C02D9A29C ? 4A006E298 ?\r\n                                                   FFFFFFFFFFFF8A0 ?\r\nopimai_real+01bc     bl       01F939B4\r\nmain+0098            bl       opimai_real          000000000 ? 000000000 ?\r\n__start+0070         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u6839\u636eMOS\u6587\u6863Bug 4937225  ORA-22 from OCIStmtExecute after OCISessionBegin\u7684\u63cf\u8ff0\uff0c\u8fd9\u662f\u4e2a\u5ba2\u6237\u7aefOCI\u51fa\u73b0\u7684bug\uff0c\u95ee\u9898\u53d1\u751f\u572810.2.0.3\u4ee5\u4e0b\u7248\u672c\u7684\u5ba2\u6237\u7aef\u8fde\u63a5\u5230\u9ad8\u7248\u672c\u6570\u636e\u5e93\u7684\u60c5\u51b5\uff0c\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u4e3a10.2.0.2\uff0cOracle\u572810.2.0.3\u548c11.1.0.6\u4e2dFIXED\u4e86\u8be5bug\u3002<br \/>\n\u5f53\u524d\u6570\u636e\u5e93\u7248\u672c\u4e3a10.2.0.5\u4f46\u662f\u8fd9\u4e2a\u95ee\u9898\u662f\u53d1\u751f\u5728\u5ba2\u6237\u7aef\uff0c\u800c\u53d1\u751f\u95ee\u9898\u7684\u5ba2\u6237\u7aef\u7248\u672c\u4e3a10.2.0.1\uff0c\u56e0\u6b64\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u4ea7\u751f\u5c31\u4e0d\u5947\u602a\u4e86\uff0c\u901a\u8fc7\u5347\u7ea7\u5ba2\u6237\u7aef\u6570\u636e\u5e93\u7248\u672c\u523010.2.0.3\u4ee5\u4e0a\u53ef\u4ee5\u89e3\u51b3\u8be5\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0\u9891\u7e41\u7684ORA-600(kssadd_stage: null parent)\u9519\u8bef\u3002 \u6570\u636e\u5e93\u7248\u672c\u4e3a10.2.0.5 RAC for AIX\uff0c\u62a5\u9519\u65f6\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Tue Jul 17 14:57:39 2012 Errors in file \/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_307720.trc: ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], [] Tue Jul 17 14:57:45 2012 Errors in file \/oracle\/10g\/admin\/orcl\/udump\/orcl2_ora_357344.trc: &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1075\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[925,926,924,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-hl","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1075"}],"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=1075"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1075\/revisions"}],"predecessor-version":[{"id":1076,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1075\/revisions\/1076"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}