{"id":822,"date":"2012-05-08T23:28:05","date_gmt":"2012-05-08T15:28:05","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=822"},"modified":"2012-05-13T09:30:51","modified_gmt":"2012-05-13T01:30:51","slug":"ora-600qertbfetchbyrowid%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=822","title":{"rendered":"ORA-600(qertbFetchByRowID)\u9519\u8bef"},"content":{"rendered":"

\u4ee5\u524d\u4e5f\u78b0\u5230\u8fc7\u8fd9\u4e2a\u9519\u8bef\uff0c\u4e0d\u8fc7\u7531\u4e8e\u65e0\u6cd5\u76f4\u63a5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u6ca1\u6709\u529e\u6cd5\u6df1\u5165\u5206\u6790\u3002\u8fd9\u6b21\u867d\u7136\u540c\u6837\u6ca1\u6709\u529e\u6cd5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u4f46\u662f\u83b7\u53d6\u4e86\u66f4\u8be6\u7ec6\u7684\u4fe1\u606f\uff0c\u57fa\u672c\u786e\u5b9a\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u3002
\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n

Wed May 09 10:41:32 2012\r\nErrors in file \/oracle\/admin\/orcl\/udump\/orcl_ora_423466.trc:\r\nORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []<\/pre>\n
\u5176\u5b9e\u4ece\u9519\u8bef\u4fe1\u606f\u4e0d\u96be\u5206\u6790\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u548c\u7d22\u5f15\u6709\u5173\uff0c\u9519\u8bef\u4fe1\u606f\u660e\u786e\u6307\u51fa\u4e86\u95ee\u9898\u53d1\u751f\u5728\u901a\u8fc7ROWID\u4fe1\u606f\u8bfb\u53d6\u8868\u65f6\uff0c\u800c\u901a\u8fc7ROWID\u8bfb\u53d6\u662f\u7d22\u5f15\u626b\u63cf\u7684\u6807\u5fd7\u3002
\n\u4e00\u822c\u6765\u8bf4\u8fd9\u79cd\u95ee\u9898\u662f\u7d22\u5f15\u548c\u8868\u4e0a\u6570\u636e\u7684\u903b\u8f91\u635f\u574f\u9020\u6210\u7684\uff0c\u5982\u679c\u95ee\u9898\u51fa\u73b0\u5728\u7d22\u5f15\u4e0a\uff0c\u90a3\u4e48\u6700\u7b80\u5355\u7684\u529e\u6cd5\u83ab\u8fc7\u4e8e\u5220\u9664\u91cd\u5efa\u7d22\u5f15\uff0c\u6216\u8005\u4f7f\u7528ONLINE\u65b9\u5f0f\u91cd\u5efa\u7d22\u5f15\u3002
\n\u5c06\u7d22\u5f15\u5220\u9664\u540e\uff0c\u95ee\u9898\u679c\u7136\u4e0d\u518d\u51fa\u73b0\uff0c\u4f46\u662f\u5c1d\u8bd5\u91cd\u5efa\u7d22\u5f15\u65f6\uff0c\u5f15\u53d1\u4e86\u53e6\u4e00\u4e2aORA-600\u9519\u8bef\uff1a<\/p>\n
SQL> analyze table tab_a validate structure cascade online;\r\nanalyze table tab_a validate structure cascade online\r\nORA-01499: table\/index cross reference failure - see trace file\r\nSQL> alter index ind_a rebuild online parallel 4;\r\nalter index ind_a rebuild online parallel 4\r\nORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []<\/pre>\n
\u544a\u8b66\u65e5\u5fd7\u4e2d\u4fe1\u606f\u4e3a\uff1a<\/p>\n
Errors in file \/oracle\/admin\/orcl\/udump\/orcl_ora_618990.trc:\r\nORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []<\/pre>\n
\u8be6\u7ec6TRACE\u4e2d\u4fe1\u606f\u4e3a\uff1a<\/p>\n
*** 2012-05-09 13:52:41.518\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nalter index ind_a rebuild online parallel 4\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              00000FFFF ? 000000000 ?\r\nksedmp+0290          bl       ksedst               104A557A8 ?\r\nksfdmp+0018          bl       03F4CD24             \r\nkgerinv+00dc         bl       _ptrgl               \r\nkgeasnmierr+004c     bl       kgerinv              70000002F81807C ? 0000000B8 ?\r\n                                                   1F400000000 ? 110546478 ?\r\n                                                   110546068 ?\r\nkdsgrp+0460          bl       01FB9490             \r\nkdsgnp+0444          bl       kdsgrp               70000002F8184ED ? 000000000 ?\r\n                                                   110546070 ?\r\nkdstf0011101km+0c24  bl       03F4A5C0             \r\nkdsttgr+5244         bl       kdstf0011101km       110546068 ? 000010266 ?\r\n                                                   70000022DCBB510 ?\r\n                                                   FFFFFFFFFFF54F8 ? 0FFFFFFFF ?\r\n                                                   000001FE8 ? 000000000 ?\r\n                                                   000000000 ?\r\nqertbFetch+09b8      bl       kdsttgr              110546068 ?\r\n                                                   4842208000000001 ?\r\n                                                   804000007BFB0 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? C4FB00000000 ?\r\nqergiFetch+02a4      bl       03F49A98             \r\nqertqoFetch+01f0     bl       01FB9488             \r\nqertqiFetch+0158     bl       01FB9488             \r\nqersoFetch+0110      bl       03F49A98             \r\nqerliFetch+0188      bl       03F49A98             \r\nqertqoFetch+01f0     bl       01FB9488             \r\nqerpxFetch+0210      bl       01FB9488             \r\nkdicrws+16e8         bl       01FB9488             \r\nkdicdrv+09b8         bl       kdicrws              70000022DFE4DC0 ?\r\n                                                   70000022DFE5500 ?\r\n                                                   70000022DFE5500 ?\r\nopiexe+28c4          bl       kdicdrv              B00000009 ? 100000001 ?\r\n                                                   11043C340 ?\r\nopiosq0+19f0         bl       opiexe               FFFFFFFFFFF8E70 ?\r\n                                                   2824424042420820 ?\r\n                                                   FFFFFFFFFFF8F30 ?\r\nkpooprx+0168         bl       opiosq0              33C0D81A0 ? 1101957F8 ?\r\n                                                   1100098E0 ? A4000110199810 ?\r\nkpoal8+0400          bl       kpooprx              FFFFFFFFFFFB784 ?\r\n                                                   FFFFFFFFFFFB508 ?\r\n                                                   3B0000003B ? 100000001 ?\r\n                                                   000000000 ? A40000000000A4 ?\r\n                                                   000000000 ? 1103A0018 ?\r\nopiodr+0ae0          bl       _ptrgl               \r\nttcpip+1020          bl       _ptrgl               \r\nopitsk+1124          bl       ttcpip               1100CAB28 ? 000000000 ?\r\n                                                   000000001 ? FFFFFFFFFFFB8B0 ?\r\n                                                   000000001 ? 1100DFE78 ?\r\n                                                   FFFFFFFFFFFB830 ? 11046F998 ?\r\nopiino+0990          bl       opitsk               0FFFFD7C0 ? 000000000 ?\r\nopiodr+0ae0          bl       _ptrgl               \r\nopidrv+0484          bl       01FBA8D8             \r\nsou2o+0090           bl       opidrv               3C02ABCD9C ? 4A039F928 ?\r\n                                                   FFFFFFFFFFFF6C0 ?\r\nopimai_real+01bc     bl       01FB868C             \r\nmain+0098            bl       opimai_real          000000000 ? 000000000 ?\r\n__start+0090         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n
\u53ef\u4ee5\u770b\u5230\uff0c\u6570\u636e\u7684\u635f\u574f\u51fa\u5728\u8868\u5757\u4e0a\uff0c\u56e0\u6b64\u91cd\u5efa\u7d22\u5f15\u4f1a\u5bfc\u81f4\u9519\u8bef\u3002\u5982\u679c\u95ee\u9898\u51fa\u73b0\u5728\u8868\u5757\u4e0a\uff0c\u90a3\u4e48\u9664\u4e86\u5229\u7528DBMS_REPAIR\u5305\u4e4b\u7c7b\u7684\u8fdb\u884c\u4fee\u590d\u5916\uff0c\u8fd8\u53ef\u4ee5\u901a\u8fc7\u7b80\u5355\u7684PL\/SQL\u5c06\u6b63\u5e38\u7684\u6570\u636e\u5bfc\u51fa\u3002\u7531\u4e8e\u6570\u636e\u5b58\u5728\u574f\u5757\uff0c\u76f4\u63a5CREATE TABLE AS SELECT\u91c7\u7528\u76f4\u63a5\u8def\u5f84\u65b9\u5f0f\uff0c\u4f1a\u7ed5\u8fc7\u6570\u636e\u7684\u6821\u9a8c\uff0c\u56e0\u6b64\u9519\u8bef\u6570\u636e\u4ecd\u7136\u4f1a\u63d2\u5165\u3002\u800cEXP\u548cEXPDP\u5728\u5bfc\u51fa\u7684\u65f6\u5019\u540c\u6837\u4f1a\u62a5\u9519\uff0c\u56e0\u6b64\u53ea\u6709\u901a\u8fc7PL\/SQL\u5355\u6761\u8bb0\u5f55\u8bfb\u53d6\uff0c\u5982\u679c\u6b63\u5e38\u5c31\u63d2\u5165\u5230\u76ee\u6807\u8868\uff0c\u5982\u679c\u51fa\u73b0\u8bfb\u53d6\u5f02\u5e38\uff0c\u90a3\u4e48\u901a\u8fc7\u5f02\u5e38\u5224\u65ad\u6765\u8fc7\u6ee4\u8be5\u9519\u8bef\u3002
\nORA-600[kdsgrp1]\u9519\u8bef\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/524144<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u4ee5\u524d\u4e5f\u78b0\u5230\u8fc7\u8fd9\u4e2a\u9519\u8bef\uff0c\u4e0d\u8fc7\u7531\u4e8e\u65e0\u6cd5\u76f4\u63a5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u6ca1\u6709\u529e\u6cd5\u6df1\u5165\u5206\u6790\u3002\u8fd9\u6b21\u867d\u7136\u540c\u6837\u6ca1\u6709\u529e\u6cd5\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u4f46\u662f\u83b7\u53d6\u4e86\u66f4\u8be6\u7ec6\u7684\u4fe1\u606f\uff0c\u57fa\u672c\u786e\u5b9a\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Wed May 09 10:41:32 2012 Errors in file \/oracle\/admin\/orcl\/udump\/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], [] \u5176\u5b9e\u4ece\u9519\u8bef\u4fe1\u606f\u4e0d\u96be\u5206\u6790\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u548c\u7d22\u5f15\u6709\u5173\uff0c\u9519\u8bef\u4fe1\u606f\u660e\u786e\u6307\u51fa\u4e86\u95ee\u9898\u53d1\u751f\u5728\u901a\u8fc7ROWID\u4fe1\u606f\u8bfb\u53d6\u8868\u65f6\uff0c\u800c\u901a\u8fc7ROWID\u8bfb\u53d6\u662f\u7d22\u5f15\u626b\u63cf\u7684\u6807\u5fd7\u3002 \u4e00\u822c\u6765\u8bf4\u8fd9\u79cd\u95ee\u9898\u662f\u7d22\u5f15\u548c\u8868\u4e0a\u6570\u636e\u7684\u903b\u8f91\u635f\u574f\u9020\u6210\u7684\uff0c\u5982\u679c\u95ee\u9898\u51fa\u73b0\u5728\u7d22\u5f15\u4e0a\uff0c\u90a3\u4e48\u6700\u7b80\u5355\u7684\u529e\u6cd5\u83ab\u8fc7\u4e8e\u5220\u9664\u91cd\u5efa\u7d22\u5f15\uff0c\u6216\u8005\u4f7f\u7528ONLINE\u65b9\u5f0f\u91cd\u5efa\u7d22\u5f15\u3002 \u5c06\u7d22\u5f15\u5220\u9664\u540e\uff0c\u95ee\u9898\u679c\u7136\u4e0d\u518d\u51fa\u73b0\uff0c\u4f46\u662f\u5c1d\u8bd5\u91cd\u5efa\u7d22\u5f15\u65f6\uff0c\u5f15\u53d1\u4e86\u53e6\u4e00\u4e2aORA-600\u9519\u8bef\uff1a SQL> analyze table tab_a validate structure cascade online; analyze table tab_a validate structure … Continue reading →<\/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":[223,129,8,674,684],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-dg","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/822"}],"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=822"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/822\/revisions"}],"predecessor-version":[{"id":823,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/822\/revisions\/823"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}