{"id":461,"date":"2012-01-08T23:55:30","date_gmt":"2012-01-08T15:55:30","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=461"},"modified":"2012-01-09T16:50:11","modified_gmt":"2012-01-09T08:50:11","slug":"ora-60016608%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=461","title":{"rendered":"ORA-600(16608)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.4\u73af\u5883\u51fa\u73b0ORA-600(16608)\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Sun Dec 19 11:17:41 2010\r\nErrors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl_j005_5937.trc:\r\nORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], []<\/pre>\n<p>\u68c0\u67e5\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\uff0c\u53d1\u73b0\u6570\u636e\u5e93\u5728\u8fdb\u884c\u7d22\u5f15\u7684\u6536\u7f29\uff1a<\/p>\n<pre lang='SQL'>Dump file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl_j005_5937.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/u01\/app\/oracle\/product\/10.2.0\/db_1\r\nSystem name:\tLinux\r\nNode name:\tDBSERVER\r\nRelease:\t2.6.28.10-vs1.0\r\nVersion:\t#1 SMP Thu Jun 30 21:18:27 CST 2011\r\nMachine:\tia64\r\nInstance name: orcl\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 45\r\nUnix process pid: 5937, image: oracle@DBSERVER (J005)\r\n*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2010-12-19 11:17:41.736\r\n*** MODULE NAME:(DBMS_SCHEDULER) 2010-12-19 11:17:41.736\r\n*** SERVICE NAME:(SYS$USERS) 2010-12-19 11:17:41.736\r\n*** SESSION ID:(1069.3) 2010-12-19 11:17:41.736\r\n*** 2010-12-19 11:17:41.736\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], []\r\nCurrent SQL statement for this session:\r\nalter index \"U1\".\"SYS_IQ0000051623$$\" shrink space CHECK\r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\n0x8000002c3fc35960       526  SYS.WRI$_ADV_OBJSPACE_TREND_T\r\n0x8000002c3fc35960      1660  SYS.WRI$_ADV_OBJSPACE_TREND_T\r\n0x8000002c3fea1e98      1535  package body SYS.PRVT_ADVISOR\r\n0x8000002c3fea1e98      1618  package body SYS.PRVT_ADVISOR\r\n0x8000002c3fc7e3a8       186  package body SYS.DBMS_ADVISOR\r\n0x8000002c3fdadcc0      1500  package body SYS.DBMS_SPACE\r\n0x8000002c3fdadcc0      1566  package body SYS.DBMS_SPACE\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+64          ????     ksedst1()            000000000 ?\r\n                                                   600FFFFFFFAF6800 ?\r\nksedmp()+1344        ????     ksedst()             000000000 ?\r\n                                                   C000000000000C1E ?\r\n                                                   4000000000410140 ?\r\n                                                   000000000 ?\r\n                                                   600FFFFFFFAF6800 ?\r\n                                                   C000000000000185 ?\r\nksfdmp()+48          ????     ksedmp()             000000003 ?\r\nkgeriv()+432         ????     ksfdmp()             60000000002352B0 ?\r\n                                                   000000003 ?\r\n                                                   C000000000000716 ?\r\n                                                   40000000050614B0 ?\r\n                                                   000000003 ?\r\n                                                   600FFFFFFFAF6BA0 ?\r\n                                                   C000000000000205 ?\r\n                                                   4000000000453EB0 ?\r\nkgeasi()+688         ????     kgeriv()             60000000002352B0 ?\r\n                                                   6000000000236368 ?\r\n                                                   0000040E0 ? 000000003 ?\r\n                                                   600FFFFFFFAF6BF8 ?\r\nkglsscn()+1616       ????     kgeasi()             600FFFFFFFAF6BD0 ?\r\n                                                   600FFFFFFFAF6BE0 ?\r\n                                                   600FFFFFFFAF6BD8 ?\r\n                                                   600FFFFFFFAF6BE8 ?\r\n                                                   000000003 ? 000000000 ?\r\n                                                   000000002 ? 000000000 ?\r\nkqlsscn()+64         ????     kglsscn()            60000000002352B0 ?\r\n                                                   8000002C33FC5D3A ?\r\n                                                   8000002C4FA008F0 ?\r\n                                                   2000000001F1D670 ?\r\n                                                   600FFFFFFFAF7360 ?\r\nktsk_init_shk_ctx()  ????     kqlsscn()            000000000 ?\r\n+160                                               8000002C4FA008F0 ?\r\n                                                   2000000001F1D670 ?\r\n                                                   600FFFFFFFAF7360 ?\r\n                                                   C0000000000029DB ?\r\n                                                   400000000108DFE0 ?\r\n                                                   60000000002352B0 ?\r\n                                                   8000002C33FC5D3A ?\r\nktskshk1()+2288      ????     ktsk_init_shk_ctx()  600FFFFFFFAF8C50 ?\r\n                                                   600FFFFFFFAF9140 ?\r\n                                                   8000002C4FA00DC0 ?\r\n                                                   8000002C5699A650 ?\r\n                                                   8000002C4C870D48 ?\r\n                                                   000000000 ?\r\n                                                   600FFFFFFFAF7360 ?\r\n                                                   C0000000000014B1 ?\r\nain_shk_drv()+5840   ????     ktskshk1()           600FFFFFFFAF9140 ?\r\n                                                   000000000 ?\r\n                                                   600FFFFFFFAF9000 ?\r\n                                                   C000000000001C40 ?\r\n                                                   4000000001660FD0 ?\r\n                                                   60000000001ADE80 ?\r\n                                                   6000000000234930 ?\r\n                                                   000000000 ?<\/pre>\n<p>\u68c0\u67e5\u53d1\u73b0ORA-600 [16608] On Index Shrink [ID 1277283.1]\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0cOracle\u63cf\u8ff0\u8fd9\u662f\u4e00\u4e2a\u672a\u53d1\u5e03\u7684Bug 4926805\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u5728ASSM\u8868\u7a7a\u95f4\u4e2d\u6536\u7f29CLUSTER\u7d22\u5f15\u6bb5\uff0c\u800c\u76ee\u524d\u552f\u4e00\u7684\u89e3\u51b3\u65b9\u6848\u5c31\u662f\u5347\u7ea7\u523011g\u3002<br \/>\n\u597d\u5728\u8fd9\u4e2a\u95ee\u9898\u5f71\u54cd\u7684\u8303\u56f4\u975e\u5e38\u5c0f\uff0c\u5bf9\u4e8e\u7edd\u5927\u90e8\u5206\u60c5\u51b5\uff0c\u90fd\u53ef\u4ee5\u5ffd\u7565\u8fd9\u4e2a\u9519\u8bef\u3002\u60f3\u8981\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\uff0c\u53ef\u4ee5\u907f\u514d\u624b\u5de5SHRINK CLUSTER\u7d22\u5f15\uff0c\u5e76\u7981\u6b62\u7a7a\u95f4\u7ba1\u7406\u7684SCHEDULER\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.4\u73af\u5883\u51fa\u73b0ORA-600(16608)\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Sun Dec 19 11:17:41 2010 Errors in file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl_j005_5937.trc: ORA-00600: internal error code, arguments: [16608], [2], [3], [0x8000002C4FA00DC0], [], [], [], [] \u68c0\u67e5\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\uff0c\u53d1\u73b0\u6570\u636e\u5e93\u5728\u8fdb\u884c\u7d22\u5f15\u7684\u6536\u7f29\uff1a Dump file \/u01\/app\/oracle\/admin\/orcl\/bdump\/orcl_j005_5937.trc Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 &#8211; 64bit Production With the &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=461\">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":[360,183,223,8,361],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-7r","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/461"}],"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=461"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions"}],"predecessor-version":[{"id":462,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions\/462"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}