{"id":1053,"date":"2012-07-27T23:31:57","date_gmt":"2012-07-27T15:31:57","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1053"},"modified":"2012-08-06T01:03:49","modified_gmt":"2012-08-05T17:03:49","slug":"ora-600qersqcloserem-2%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1053","title":{"rendered":"ORA-600(qersqCloseRem-2)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u768410.2.0.4 RAC for Hp-un\u73af\u5883\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Wed Feb 29 19:42:05 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_11261.trc:\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:42:05 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_32036.trc:\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:42:05 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_5935.trc:\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:42:05 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_5026.trc:\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:42:05 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_7620.trc:\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:42:08 2012\r\nTrace dumping is performing id=[cdmp_20120229194207]\r\nWed Feb 29 19:42:17 2012\r\nTrace dumping is performing id=[cdmp_20120229194217]<\/pre>\n<p>\u8fd9\u4e2aORA-600[qersqCloseRem-2]\u9519\u8bef\u975e\u5e38\u7f55\u89c1\uff0c\u5728MOS\u4e0a\u5c45\u7136\u6ca1\u6709\u4efb\u4f55\u8bb0\u8f7d\u3002\u4e0d\u8fc7\u4ece\u9519\u8bef\u4fe1\u606f\u8fdb\u884c\u8fdb\u4e00\u6b65\u7684\u5206\u6790\uff0c\u8fd9\u4e2a\u9519\u8bef\u53d1\u751f\u5728\u8fdc\u7aef\u6570\u636e\u5e93\u7684\u8bbf\u95ee\u5f02\u5e38\u3002<br \/>\n\u68c0\u67e5\u8fdb\u4e00\u6b65\u7684\u8be6\u7ec6\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>*** 2012-02-29 19:42:05.564\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], []\r\nORA-02068: following severe error from WEBDB.COM\r\nORA-03113: end-of-file on communication channel\r\nCurrent SQL statement for this session:\r\nSELECT ACCESS_LOG_SEQUENCE.NEXTVAL@WEBDB.COM FROM DUAL \r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\n0x39b5c3720         5  ECOMMERCE.P_USER_AT\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+31          call     ksedst1()            000000000 ? 000000001 ?\r\n                                                   7FBFFF4370 ? 7FBFFF43D0 ?\r\n                                                   7FBFFF4310 ? 000000000 ?\r\nksedmp()+610         call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FBFFF4370 ? 7FBFFF43D0 ?\r\n                                                   7FBFFF4310 ? 000000000 ?\r\nksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?\r\n                                                   7FBFFF4370 ? 7FBFFF43D0 ?\r\n                                                   7FBFFF4310 ? 000000000 ?\r\n.\r\n.\r\n.\r\n                                                   0059DF200 ? 683F6E400000001 ?\r\nmain()+116           call     opimai_real()        000000002 ? 7FBFFFF4E0 ?\r\n                                                   000000004 ? 7FBFFFF478 ?\r\n                                                   0059DF200 ? 683F6E400000001 ?\r\n__libc_start_main()  call     main()               000000002 ? 7FBFFFF4E0 ?\r\n+219                                               000000004 ? 7FBFFFF478 ?\r\n                                                   0059DF200 ? 683F6E400000001 ?\r\n_start()+42          call     __libc_start_main()  0007139F8 ? 000000002 ?\r\n                                                   7FBFFFF628 ? 0052B4BD0 ?\r\n                                                   000000000 ? 000000002 ?\r\n \r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u4ece\u8be6\u7ec6TRACE\u5206\u6790\uff0c\u5728\u95ee\u9898\u53d1\u751f\u65f6\u523b\uff0c\u6b63\u5728\u901a\u8fc7\u6570\u636e\u5e93\u94fe\u8bfb\u53d6\u8fdc\u7aef\u5e8f\u5217\u7684\u503c\u3002\u800c\u6b64\u65f6\u51fa\u73b0\u7684ORA-3113\u901a\u4fe1\u9519\u8bef\uff0c\u591a\u534a\u4e0e\u8fdc\u7aef\u6570\u636e\u5e93\u72b6\u6001\u5f02\u5e38\u6709\u5173\u3002<br \/>\n\u68c0\u67e5\u8fdc\u7aef\u6570\u636e\u5e93\u7684\u544a\u8b66\u65e5\u5fd7\uff0c\u679c\u7136\u53d1\u73b0\u5728\u95ee\u9898\u51fa\u73b0\u65f6\u523b\uff0c\u6570\u636e\u5e93\u72b6\u6001\u5f02\u5e38\u5e76\u6700\u7ec8\u5bfc\u81f4\u4e86\u5b9e\u4f8b\u91cd\u542f\uff1a<\/p>\n<pre lang='SQL'>Wed Feb 29 19:39:29 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:39:30 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:40:01 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\n.\r\n.\r\n.\r\nWed Feb 29 19:43:28 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:28 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:28 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:28 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:29 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:29 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:29 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:29 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:43:30 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:45:26 2012\r\nPMON failed to acquire latch, see PMON dump\r\nWed Feb 29 19:46:32 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:46:33 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:46:34 2012\r\nPMON failed to acquire latch, see PMON dump\r\nWed Feb 29 19:46:40 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:46:43 2012\r\nWARNING: inbound connection timed out (ORA-3136)\r\nWed Feb 29 19:46:44 2012\r\nErrors in file \/opt\/app\/oracle\/admin\/orcl\/bdump\/orcl1_asmb_14614.trc:\r\nORA-15064: communication failure with ASM instance\r\nORA-03113: end-of-file on communication channel\r\nWed Feb 29 19:46:44 2012\r\nASMB: terminating instance due to error 15064\r\nWed Feb 29 19:46:44 2012\r\nSystem state dump is made for local instance\r\nSystem State dumped to trace file \/opt\/app\/oracle\/admin\/orcl\/bdump\/orcl1_diag_14555.trc\r\nWed Feb 29 19:46:47 2012\r\nShutting down instance (abort)\r\nLicense high water mark = 1623\r\nWed Feb 29 19:46:49 2012\r\nInstance terminated by ASMB, pid = 14614\r\nWed Feb 29 19:46:52 2012\r\nInstance terminated by USER, pid = 3684<\/pre>\n<p>\u663e\u7136\u8fdc\u7aef\u6570\u636e\u5e93\u72b6\u6001\u5f02\u5e38\u662f\u8fd9\u4e2aORA-600\u9519\u8bef\u7684\u76f4\u63a5\u539f\u56e0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u768410.2.0.4 RAC for Hp-un\u73af\u5883\u78b0\u5230\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Wed Feb 29 19:42:05 2012 Errors in file \/opt\/app\/oracle\/admin\/orcl\/udump\/orcl1_ora_11261.trc: ORA-00600: internal error code, arguments: [qersqCloseRem-2], [Invalid Handle], [], [], [], [], [], [] ORA-02068: following severe error from WEBDB.COM ORA-03113: end-of-file on communication channel Wed &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1053\">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":[853,906,673,194,8,907],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-gZ","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1053"}],"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=1053"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1053\/revisions"}],"predecessor-version":[{"id":1054,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1053\/revisions\/1054"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1053"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1053"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1053"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}