{"id":248,"date":"2011-10-29T23:19:19","date_gmt":"2011-10-29T15:19:19","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=248"},"modified":"2011-10-30T01:52:39","modified_gmt":"2011-10-29T17:52:39","slug":"ora-600kjcsombd2%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=248","title":{"rendered":"ORA-600(kjcsombd:2)\u9519\u8bef"},"content":{"rendered":"<p>\u53c8\u662f\u4e00\u4e2a9208 RAC\u4e0a\u7684\u9519\u8bef\uff0c\u4e8b\u5b9e\u4e0a\u8fd9\u4e2a\u9519\u8bef\u548c\u4e0a\u4e00\u7bc7\u6587\u7ae0\u4e2d\u63cf\u8ff0\u7684\u9519\u8bef\u76f8\u5173\u6027\u5f88\u5927\uff0c\u56e0\u4e3a\u5728\u4e0a\u4e00\u7bc7\u8282\u70b9\u5173\u95ed\u5e76\u62a5\u9519\u7684\u540c\u65f6\uff0c\u8fd9\u4e2a\u8282\u70b9\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002<br \/>\nORA-600(kjccgmb:1)\u9519\u8bef\uff1a<a href=\"https:\/\/yangtingkun.net\/?p=245\">https:\/\/yangtingkun.net\/?p=245<\/a><br \/>\n\u5728\u5f53\u524d\u8282\u70b9\u4e0a\u7684\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Thu Oct 13 18:13:10 2011\r\nIPC Send timeout detected. Sender ospid 1228900\r\nThu Oct 13 18:13:12 2011\r\nCommunications reconfiguration: instance 1\r\nThu Oct 13 18:13:12 2011\r\nTrace dumping is performing id=[cdmp_20111013181312]\r\nThu Oct 13 18:13:17 2011\r\nIPC Send timeout detected. Sender ospid 770198\r\nThu Oct 13 18:13:19 2011\r\nEvicting instance 2 from cluster\r\nThu Oct 13 18:13:22 2011\r\nIPC Send timeout detected. Sender ospid 1032208\r\nThu Oct 13 18:13:31 2011\r\nIPC Send timeout detected. Sender ospid 1302720\r\nThu Oct 13 18:13:37 2011\r\nIPC Send timeout detected. Sender ospid 438420\r\nThu Oct 13 18:13:39 2011\r\nWaiting for instances to leave: \r\n2 \r\nThu Oct 13 18:13:47 2011\r\nIPC Send timeout detected. Sender ospid 1474810\r\nThu Oct 13 18:13:59 2011\r\nWaiting for instances to leave: \r\n2 \r\n.\r\n.\r\n.\r\nThu Oct 13 18:17:22 2011\r\nIPC Send timeout detected. Sender ospid 876652\r\nThu Oct 13 18:17:24 2011\r\nIPC Send timeout detected. Sender ospid 1654878\r\nThu Oct 13 18:17:27 2011\r\nIPC Send timeout detected. Sender ospid 1425476\r\nThu Oct 13 18:17:27 2011\r\nIPC Send timeout detected. Sender ospid 970920\r\nThu Oct 13 18:17:39 2011\r\nWaiting for instances to leave: \r\n2 \r\nThu Oct 13 18:17:59 2011\r\nWaiting for instances to leave: \r\n2 \r\nThu Oct 13 18:18:19 2011\r\nWaiting for instances to leave: \r\n2 \r\nThu Oct 13 18:18:29 2011\r\nErrors in file \/u01\/product\/admin\/RAC\/udump\/rac1_ora_1032208.trc:\r\nORA-00600: internal error code, arguments: [kjcsombd:2], [], [], [], [], [], [], []\r\nORA-03113: end-of-file on communication channel\r\nThu Oct 13 18:18:37 2011\r\nErrors in file \/u01\/product\/admin\/RAC\/udump\/rac1_ora_1032208.trc:\r\nORA-00603: ORACLE server session terminated by fatal error\r\nORA-00600: internal error code, arguments: [kjcsombd:2], [], [], [], [], [], [], []\r\nORA-03113: end-of-file on communication channel\r\nThu Oct 13 18:18:38 2011\r\nTrace dumping is performing id=[cdmp_20111013181838]<\/pre>\n<p>\u8fd9\u4e2a600\u9519\u8bef\u4e00\u76f4\u91cd\u590d\u51fa\u73b0\uff0c\u76f4\u5230\u53e6\u4e00\u4e2a\u5b9e\u4f8b\u542f\u52a8\uff0c\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>\/u01\/product\/admin\/RAC\/udump\/rac1_ora_1032208.trc\r\nOracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production\r\nWith the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options\r\nJServer Release 9.2.0.8.0 - Production\r\nORACLE_HOME = \/u01\/product\/oracle\/9.2.0\r\nSystem name: AIX\r\nNode name: p55a1\r\nRelease: 3\r\nVersion: 5\r\nMachine: 0001D007D600\r\nInstance name: RAC1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 237\r\nUnix process pid: 1032208, image: oracle@p55a1 (TNS V1-V3)\r\n*** SESSION ID:(275.64909) 2011-10-13 18:13:22.043\r\nSKGXPCTX: 0x102c4988 ctx\r\nadmono 0x3d9a665b admport:\r\nSSKGXPT 0x102c4c44 flags  active network 0\r\ninfo for network 0\r\n socket no 7  IP 172.16.12.254  UDP 57496\r\n HACMP network_id 0 sflags SSKGXPT_WRITESSKGXPT_UP\r\ncontext timestamp 0xe5b469\r\n no ports\r\n    sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks\r\n0x5c9264d4 0x07c1249a     32      3  33535    772    772      0    296    771\r\nslot 6 rqh=11035df18\r\nseq=33534 len=424 accno=0x7c1249a start TS=0xe102f0 rt TS=0xe5b7c7 X CNT=297\r\n0x5c9264d5 0x60c4351d     32      3  34041   1278   1278      0      0   1278\r\n0x5c9264d6 0x4201cb1f     32      3  32770      7      7      0      0      7\r\n       ach     accono     sconno      admno  state   seq#    rcv rtrans   acks\r\nSubmitting synchronized dump request [268435460]\r\nKCL: caught error 3113 during cr lock op\r\n*** 2011-10-13 18:18:29.055\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kjcsombd:2], [], [], [], [], [], [], []\r\nORA-03113: end-of-file on communication channel\r\nCurrent SQL information unavailable - no session.\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp+0148          bl       ksedst               102974684 ?\r\nksfdmp+0018          bl       01FD3FC8             \r\nkgerinv+00e8         bl       _ptrgl               \r\nkgeanmfe+0048        bcl      kglsim_unpin_simhp+  000000200 ? 000000000 ?\r\n                              001c                 700000000017CD8 ? 000000000 ?\r\nkjcsombdi+0974       bl       kgeanmfe             110006288 ? 110357A28 ?\r\n                                                   102A73228 ? 000000000 ?\r\n                                                   10DC9D3665FC00 ?\r\n                                                   8A2477269B180 ?\r\n                                                   12E0BE826D694B2F ?\r\n                                                   000000077 ?\r\nkjcsombd+00a4        bl       kjcsombdi            BADC0FFEE0DDF00D ?\r\n                                                   BADC0FFEE0DDF00D ?\r\nkjpsod+0fbc          bl       kjcsombd             70000034CDEECD8 ? 2000004F8 ?\r\nkssdch_stage+02b8    bl       _ptrgl               \r\nkssdch+0014          bl       kssdch_stage         BADC0FFEE0DDF00D ?\r\n                                                   BADC0FFEE0DDF00D ?\r\n                                                   BADC0FFEE0DDF00D ?\r\nksudlp+0380          bl       kssdch               7000003796230D0 ? 200000002 ?\r\nopidcl+020c          bl       01FD4824             \r\nopidrv+045c          bl       opidcl               11000D060 ? 0101FAED0 ?\r\nsou2o+0028           bl       opidrv               3C0C000000 ? 4A0142C60 ?\r\n                                                   FFFFFFFFFFFF990 ?\r\nmain+0138            bl       01FD39E0             \r\n__start+0098         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u4eceTRACE\u6587\u4ef6\u4e0d\u96be\u5224\u65ad\uff0c\u51fa\u73b0\u8fd9\u4e2a\u95ee\u9898\u662f\u7531\u4e8e\u9700\u8981\u4ece\u8fdc\u7aefCACHE\u4e2d\u83b7\u53d6\u4e00\u81f4\u6027\u8bfb\u7684BLOCK\uff0c\u4f46\u662f\u5728\u83b7\u53d6\u8fc7\u7a0b\u4e2d\u78b0\u5230\u4e86ORA-3113\u901a\u4fe1\u4e2d\u65ad\u9519\u8bef\u3002<br \/>\n\u663e\u7136\u8fd9\u4e2a\u95ee\u9898\u4e0e\u53e6\u5916\u7684\u8282\u70b9\u5173\u95ed\u76f4\u63a5\u76f8\u5173\uff0c\u914d\u5408\u53e6\u5916\u8282\u70b9\u4e0a\u7684ORA-600\u9519\u8bef\uff0c\u6000\u7591\u4e24\u4e2a\u8282\u70b9\u95f4\u7684\u901a\u4fe1\u5728\u5173\u95ed\u65f6\u523b\u51fa\u73b0\u5f02\u5e38\uff0c\u4ece\u800c\u5f15\u53d1\u5404\u4e2a\u8282\u70b9\u4e0a\u51fa\u73b0\u4e86\u4e0d\u540c\u7684ORA-600\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c8\u662f\u4e00\u4e2a9208 RAC\u4e0a\u7684\u9519\u8bef\uff0c\u4e8b\u5b9e\u4e0a\u8fd9\u4e2a\u9519\u8bef\u548c\u4e0a\u4e00\u7bc7\u6587\u7ae0\u4e2d\u63cf\u8ff0\u7684\u9519\u8bef\u76f8\u5173\u6027\u5f88\u5927\uff0c\u56e0\u4e3a\u5728\u4e0a\u4e00\u7bc7\u8282\u70b9\u5173\u95ed\u5e76\u62a5\u9519\u7684\u540c\u65f6\uff0c\u8fd9\u4e2a\u8282\u70b9\u51fa\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002 ORA-600(kjccgmb:1)\u9519\u8bef\uff1ahttps:\/\/yangtingkun.net\/?p=245 \u5728\u5f53\u524d\u8282\u70b9\u4e0a\u7684\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Thu Oct 13 18:13:10 2011 IPC Send timeout detected. Sender ospid 1228900 Thu Oct 13 18:13:12 2011 Communications reconfiguration: instance 1 Thu Oct 13 18:13:12 2011 Trace dumping is performing id=[cdmp_20111013181312] Thu Oct 13 18:13:17 2011 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=248\">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":[179,176,178,8,180],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-40","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/248"}],"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=248"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/248\/revisions"}],"predecessor-version":[{"id":249,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/248\/revisions\/249"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}