{"id":769,"date":"2012-04-19T23:59:09","date_gmt":"2012-04-19T15:59:09","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=769"},"modified":"2012-04-21T16:55:58","modified_gmt":"2012-04-21T08:55:58","slug":"ora-6006002%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=769","title":{"rendered":"ORA-600(6002)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(6002)\u9519\u8bef\u3002<br \/>\n\u5728\u544a\u8b66\u6587\u4ef6\u4e2d\u51fa\u73b0\u5927\u91cf\u7684\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Sun Apr 1 16:15:41 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16555.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:16:43 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16555.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:17:44 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16961.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:18:45 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16961.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:19:47 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16961.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:20:48 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16555.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nSun Apr 1 16:21:49 2012\r\nErrors in file \/oracle\/orcl\/udump\/orcl_ora_16961.trc:\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []<\/pre>\n<p>\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>ksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []\r\nCurrent SQL statement for this session:\r\nINSERT INTO TABLE_STAT (ID ,START_TIME, END_TIME) VALUES (:1, :2, :3)         \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                                                   7FFF7063E240 ? 7FFF7063E2A0 ?\r\n                                                   7FFF7063E1E0 ? 000000000 ?\r\nksedmp()+610         call     ksedst()             000000000 ? 000000001 ?\r\n                                                   7FFF7063E240 ? 7FFF7063E2A0 ?\r\n                                                   7FFF7063E1E0 ? 000000000 ?\r\nksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?\r\n                                                   7FFF7063E240 ? 7FFF7063E2A0 ?\r\n                                                   7FFF7063E1E0 ? 000000000 ?\r\nkgeriv()+176         call     ksfdmp()             000000003 ? 000000001 ?\r\n                                                   7FFF7063E240 ? 7FFF7063E2A0 ?\r\n                                                   7FFF7063E1E0 ? 000000000 ?\r\nkgeasi()+263         call     kgeriv()             0068966E0 ? 2AAACED21168 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   7FFF7063E1E0 ? 000000000 ?\r\nkdiins0()+4578       call     kgeasi()             0068966E0 ? 2AAACED21168 ?\r\n                                                   000001772 ? 000000002 ?\r\n                                                   000000004 ? 000000000 ?\r\nkauxsin()+4261       call     kdiins0()            11BCC8DD0 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\ninsidx()+2461        call     kauxsin()            11BCC8E38 ? 7FFF70651640 ?<\/pre>\n<p>\u8fd9\u4e2a\u9519\u8bef\u4e00\u822c\u90fd\u662f\u7d22\u5f15\u5757\u51fa\u73b0\u4e86\u903b\u8f91\u635f\u574f\u9020\u6210\u7684\uff0c\u89e3\u51b3\u65b9\u6cd5\u5176\u5b9e\u5f88\u7b80\u5355\uff0c\u5c06\u7d22\u5f15\u5220\u9664\u91cd\u5efa\u4e00\u822c\u5c31\u53ef\u4ee5\u89e3\u51b3\u95ee\u9898\u3002\u5982\u679c\u60f3\u8981\u4f7f\u7528REBUILD\u7684\u65b9\u5f0f\u91cd\u5efa\u7d22\u5f15\uff0c\u8bb0\u5f97\u52a0\u4e0aONLINE\u9009\u9879\uff0c\u786e\u4fdd\u5728\u7d22\u5f15\u91cd\u5efa\u7684\u65f6\u5019\u9009\u62e9\u8bfb\u8868\uff0c\u800c\u4e0d\u662f\u4ece\u672c\u6765\u5c31\u5b58\u5728\u6570\u636e\u9519\u8bef\u7684\u7d22\u5f15\u6765\u83b7\u53d6\u6570\u636e\u3002<br \/>\n\u5173\u4e8eORA-600[6002]\u9519\u8bef\u7684\u66f4\u591a\u95ee\u9898\u53ef\u4ee5\u53c2\u8003\u6587\u6863ID 47449.1\uff0c\u800c\u5bf9\u4e8e\u5f53\u524d\u7248\u672c\u53ef\u80fd\u7684bug\uff0c\u5219\u5e94\u8be5\u662fBug 6621940 &#8211; Corruption after MOVE of an empty partition with local indexes [ID 6621940.8]\uff0c\u8fd9\u4e2a\u95ee\u9898\u572810.2.0.5\u548c11.2.0.1\u4e2d\u88abFIXED\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(6002)\u9519\u8bef\u3002 \u5728\u544a\u8b66\u6587\u4ef6\u4e2d\u51fa\u73b0\u5927\u91cf\u7684\u9519\u8bef\uff1a Sun Apr 1 16:15:41 2012 Errors in file \/oracle\/orcl\/udump\/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], [] Sun Apr 1 16:16:43 2012 Errors in file \/oracle\/orcl\/udump\/orcl_ora_16555.trc: ORA-00600: internal error code, arguments: [6002], [0], &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=769\">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":[635,223,473,8,347],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-cp","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/769"}],"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=769"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/769\/revisions"}],"predecessor-version":[{"id":770,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/769\/revisions\/770"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=769"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=769"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=769"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}