{"id":999,"date":"2012-07-10T23:16:53","date_gmt":"2012-07-10T15:16:53","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=999"},"modified":"2012-07-15T17:20:18","modified_gmt":"2012-07-15T09:20:18","slug":"ora-600kffmxpget%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=999","title":{"rendered":"ORA-600(kffmXpGet)\u9519\u8bef"},"content":{"rendered":"<p>\u7b2c\u4e00\u6b21\u78b0\u5230Exadata\u4e0a\u7684bug\u3002<br \/>\n\u6570\u636e\u5e93\u73af\u5883Exadata V2-2\uff0c\u6570\u636e\u5e93\u7248\u672c\u4e3a11.2.0.2\uff0c\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Wed Apr 25 11:32:35 2012\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/ods\/orcl2\/trace\/orcl2_ora_9495.trc (incident=304808):\r\nORA-00600: internal error code, arguments: [kffmXpGet], [145], [69784], [], [], [], [], [], [], [], [], []\r\nORA-03135: connection lost contact\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_304808\/orcl2_ora_9495_i304808.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nopidcl aborting process unknown ospid (9495) as a result of ORA-600\r\nWed Apr 25 11:32:36 2012\r\nDumping diagnostic data in directory=[cdmp_20120425113236], requested by (instance=2, osid=9495), summary=[incident=304808].\r\nWed Apr 25 11:32:36 2012\r\nSweep [inc][304808]: completed\r\nSweep [inc2][304808]: completed\r\nWed Apr 25 11:32:39 2012\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_pmon_10797.trc (incident=302224):\r\nORA-00600: internal error code, arguments: [kffmXpGet], [181], [87276], [], [], [], [], [], [], [], [], []\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_302224\/orcl2_pmon_10797_i302224.trc\r\nDumping diagnostic data in directory=[cdmp_20120425113240], requested by (instance=2, osid=10797 (PMON)), summary=[incident=302224].\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/trace\/orcl2_pmon_10797.trc:\r\nORA-00600: internal error code, arguments: [kffmXpGet], [181], [87276], [], [], [], [], [], [], [], [], []\r\nPMON (ospid: 10797): terminating the instance due to error 472\r\nWed Apr 25 11:32:41 2012\r\nopiodr aborting process unknown ospid (11248) as a result of ORA-1092\r\nWed Apr 25 11:32:41 2012\r\nopiodr aborting process unknown ospid (1967) as a result of ORA-1092\r\nWed Apr 25 11:32:42 2012\r\nORA-1092 : opitsk aborting process\r\nWed Apr 25 11:32:43 2012\r\nLicense high water mark = 573\r\nInstance terminated by PMON, pid = 10797\r\nUSER (ospid: 8755): terminating the instance\r\nInstance terminated by USER, pid = 8755<\/pre>\n<p>\u7531\u4e8eORA-600[kffmXpGet]\u9519\u8bef\u7684\u51fa\u73b0\uff0c\u6700\u7ec8\u51fa\u73b0\u4e86ORA-1092\u7684\u9519\u8bef\uff0c\u5e76\u81f4\u4f7fopitsk\u8fdb\u7a0b\u9000\u51fa\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u5b9e\u4f8b\u5d29\u6e83\u3002<br \/>\nOracle\u5728MOS\u6587\u6863Bug 12387467  instance crash by ORA-600 [kffmxpget]\u4e2d\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u786e\u8ba4\u5f71\u54cd\u7684\u7248\u672c\u4e3a11.2.0.1\u300111.2.0.2\u300111.2.0.3\uff0cOracle\u572811.2.0.2 \u7684Bundle Patch 16 for Exadata\u4ee5\u53ca11.2.0.3 Bundle Patch 5 for Exadata\u4e2dfixed\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0cOracle\u8ba1\u5212\u572811.2.0.4\u548c12.1\u4e2d\u5f7b\u5e95Fixed\u8be5\u95ee\u9898\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u53ea\u4f1a\u53d1\u751f\u5728Exadata\u4e2d\uff0c\u56e0\u4e3a\u5bfc\u81f4\u9519\u8bef\u7684\u539f\u56e0\u548cSmart Scan\u6709\u5173\u3002\u5f53\u4f1a\u8bdd\u6267\u884cSmart Scan\u64cd\u4f5c\u65f6\u4f7f\u7528\u4e86Ctrl + C\u4e2d\u6b62\u8be5\u64cd\u4f5c\uff0c\u4f1a\u5bfc\u81f4PMON\u8fdb\u7a0b\u51fa\u73b0\u8fd9\u4e2a600\u9519\u8bef\u3002Oracle\u5efa\u8bae\u5728\u6267\u884c\u6570\u636e\u6587\u4ef6\u7684SHRINK\u64cd\u4f5c\u524d\uff0c\u4e2d\u6b62\u5e76\u9000\u51fa\u6240\u6709\u6267\u884cExadata Smart Scan\u7684\u4f1a\u8bdd\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b2c\u4e00\u6b21\u78b0\u5230Exadata\u4e0a\u7684bug\u3002 \u6570\u636e\u5e93\u73af\u5883Exadata V2-2\uff0c\u6570\u636e\u5e93\u7248\u672c\u4e3a11.2.0.2\uff0c\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Wed Apr 25 11:32:35 2012 Errors in file \/u01\/app\/oracle\/diag\/rdbms\/ods\/orcl2\/trace\/orcl2_ora_9495.trc (incident=304808): ORA-00600: internal error code, arguments: [kffmXpGet], [145], [69784], [], [], [], [], [], [], [], [], [] ORA-03135: connection lost contact Incident details in: \/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl2\/incident\/incdir_304808\/orcl2_ora_9495_i304808.trc Use ADRCI &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=999\">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":[490,46,857,858,856,268,8,277,180,361,859],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-g7","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/999"}],"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=999"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/999\/revisions"}],"predecessor-version":[{"id":1000,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/999\/revisions\/1000"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}