{"id":1364,"date":"2012-11-07T23:48:40","date_gmt":"2012-11-07T15:48:40","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1364"},"modified":"2013-07-09T08:28:01","modified_gmt":"2013-07-09T00:28:01","slug":"ora-600kcbgcur_1%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1364","title":{"rendered":"ORA-600(kcbgcur_1)\u9519\u8bef"},"content":{"rendered":"<p>\u4e00\u4e2a\u4e34\u65f6\u8868\u7a7a\u95f4\u65e0\u6cd5\u5206\u914d\u5bfc\u81f4\u7684ORA-600\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Wed May 16 17:26:23 2012\r\nORA-1652: unable to extend temp segment by 128 in tablespace                 ATEMP \r\nWed May 16 17:26:31 2012\r\nORA-1652: unable to extend temp segment by 128 in tablespace                 ATEMP \r\nWed May 16 17:26:37 2012\r\nORA-1652: unable to extend temp segment by 128 in tablespace                 ATEMP \r\nWed May 16 17:26:38 2012\r\nORA-1652: unable to extend temp segment by 128 in tablespace                 ATEMP \r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_ora_15925604.trc  (incident=209723):\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [kcbgcur_1], [], [], [], [], [], [], [], [], [], [], []\r\nORA-01652: \u65e0\u6cd5\u901a\u8fc7 128 (\u5728\u8868\u7a7a\u95f4 ATEMP \u4e2d) \u6269\u5c55 temp \u6bb5\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_209723\/orcl1_ora_15925604_i209723.trc<\/pre>\n<p>\u5728MOS\u4e2d\u627e\u4e0d\u5230\u548c\u5f53\u524d\u73b0\u8c61\u4e00\u81f4\u7684\u5df2\u77e5BUG\u63cf\u8ff0\uff0c\u4f46\u662f\u5728\u5f53\u524d\u8fd9\u4e2a11.2.0.3 RAC for AIX\u73af\u5883\u4e2d\uff0c\u8fd9\u4e2aORA-600[kcbgcur_1]\u9519\u8bef\u662f\u53ef\u91cd\u73b0\u7684\uff0c\u4e00\u65e6\u8fde\u7eed\u53d1\u751fORA-1652\u9519\u8bef\uff0c\u5c31\u4f1a\u5bfc\u81f4\u8fd9\u4e2aORA-600\u9519\u8bef\u7684\u4ea7\u751f\u3002<br \/>\n\u8981\u907f\u514d\u8fd9\u4e2a600\u9519\u8bef\uff0c\u5176\u5b9e\u5c31\u662f\u8981\u6d88\u9664ORA-1652\u9519\u8bef\uff0c\u9664\u4e86\u589e\u52a0\u8db3\u591f\u7684\u4e34\u65f6\u7a7a\u95f4\u5916\uff0c\u8fd8\u53ef\u4ee5\u4f18\u5316\u5360\u7528\u4e34\u65f6\u7a7a\u95f4\u8f83\u5927\u7684SQL\u8bed\u53e5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u4e2a\u4e34\u65f6\u8868\u7a7a\u95f4\u65e0\u6cd5\u5206\u914d\u5bfc\u81f4\u7684ORA-600\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Wed May 16 17:26:23 2012 ORA-1652: unable to extend temp segment by 128 in tablespace ATEMP Wed May 16 17:26:31 2012 ORA-1652: unable to extend temp segment by 128 in tablespace ATEMP Wed May 16 17:26:37 2012 ORA-1652: &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1364\">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":[1201,1199,8,1200],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-m0","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1364"}],"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=1364"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1364\/revisions"}],"predecessor-version":[{"id":1366,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1364\/revisions\/1366"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}