{"id":306,"date":"2011-11-18T23:55:08","date_gmt":"2011-11-18T15:55:08","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=306"},"modified":"2011-11-21T00:52:12","modified_gmt":"2011-11-20T16:52:12","slug":"ora-60015160%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=306","title":{"rendered":"ORA-600(15160)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u5728\u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Wed Nov 2 11:13:17 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:13:36 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:13:44 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:13:47 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:14:14 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:14:18 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:15:39 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nWed Nov 2 11:15:43 2011\r\nErrors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc:\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []<\/pre>\n<p>\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\u8be6\u7ec6\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>\/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production\r\nWith the Partitioning, OLAP and Data Mining options\r\nORACLE_HOME = \/oracleapp\/oracle10g\r\nSystem name: HP-UX\r\nNode name: wfrb1\r\nRelease: B.11.31\r\nVersion: U\r\nMachine: ia64\r\nInstance name: ora10\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 511\r\nUnix process pid: 9007, image: oracleora10@wfrb1\r\n*** ACTION NAME:() 2011-11-02 11:13:17.618\r\n*** MODULE NAME:(TOAD 8.0.0.47) 2011-11-02 11:13:17.618\r\n*** SERVICE NAME:(ora10) 2011-11-02 11:13:17.618\r\n*** SESSION ID:(508.11184) 2011-11-02 11:13:17.618\r\n*** 2011-11-02 11:13:17.618\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nSelect o.object_name, o.object_type, o.status, t.typecode, t.attributes, t.methods\r\nfrom  SYS.DBA_TYPES t, SYS.DBA_OBJECTS o\r\nwhere o.owner = :own\r\nand   o.owner = t.owner\r\nand   o.object_type = 'TYPE'\r\nand   o.object_name = t.type_name\r\nand   o.subobject_name is null\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          call     _etext_f()+23058430  000000000 ? 000000001 ?\r\n                              09017162224          \r\nksedmp()+1680        call     _etext_f()+23058430  000000000 ?\r\n                              09017162224          C000000000000D20 ?\r\n                                                   40000000052B0470 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nksfdmp()+48          call     _etext_f()+23058430  000000003 ?\r\n                              09017162224          \r\nkgeriv()+432         call     _etext_f()+23058430  400000000944FAD0 ?\r\n                              09017162224          000000003 ?\r\n                                                   C000000000000695 ?\r\n                                                   000060E0F ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nkgesiv()+176         call     _etext_f()+23058430  6000000000015C50 ?\r\n                              09017162224          6000000000016D08 ?\r\n                                                   600000000011C078 ?\r\n                                                   6000000000014240 ?\r\n                                                   9FFFFFFFFFFEE9A8 ?\r\nksesic0()+192        call     _etext_f()+23058430  6000000000015C50 ?\r\n                              09017162224          9FFFFFFFBF561168 ?\r\n                                                   000003B38 ? 000000000 ?\r\n                                                   9FFFFFFFFFFEE9A8 ?\r\n$cold_kkogfp()+608   call     _etext_f()+23058430  000003B38 ?\r\n                              09017162224          6000000000127450 ?\r\n                                                   9FFFFFFFFFFEE9A8 ?\r\n                                                   6000000000127B20 ?\r\nkkooqb()+2112        call     _etext_f()+23058430  9FFFFFFFBF0FFE88 ?\r\n                              09017162224          9FFFFFFFBF0EEA28 ?\r\n                                                   000000001 ?\r\n                                                   9FFFFFFFBF0EE468 ?\r\nkkoqbc()+2912        call     0000000000000002     9FFFFFFFBF2C32E0 ?\r\n                                                   000000006 ? 000000002 ?\r\n                                                   000000000 ?\r\napakkoqb()+384       call     9fffffffbf2c3420     9FFFFFFFFFFF07B0 ?\r\n                                                   9FFFFFFFBF2C32E0 ?\r\n                                                   600000000011D1C0 ?\r\n                                                   4000000003340880 ?\r\n                                                   000060209 ?\r\napaqbd()+800         call     9fffffffbf2c3420     9FFFFFFFFFFF07B0 ?\r\n                                                   9FFFFFFFBF2C32E0 ?\r\n                                                   C00000019486D370 ?\r\n                                                   40000000033402C0 ?\r\n                                                   000000000 ?\r\nkkqctCostTransfQB()  call     9fffffffbf2c3420     9FFFFFFFFFFF07B0 ?\r\n+432                                               9FFFFFFFBF2C32E0 ?\r\n                                                   C00000019486D370 ?\r\n                                                   000000000 ?\r\nkkqctdrvJP()+2384    call     9fffffffbf2c3420     9FFFFFFFBF2C32E0 ?\r\n                                                   40000000021D41C0 ?\r\n                                                   000069409 ?\r\n                                                   9FFFFFFFFFFF07B0 ?\r\nkkqjpdttr()+3472     call     0000000000069409     9FFFFFFFBF358D10 ?\r\n                                                   000000100 ?\r\nkkqctdrvTD()+944     call     0000000000069409     9FFFFFFFBF358D10 ?\r\n                                                   4000000003400AD0 ?\r\n                                                   00006870D ? 000000000 ?\r\n                                                   000000001 ?\r\nkkqjpddrv()+384      call     0000000000069409     9FFFFFFFBF557690 ?\r\n                                                   C00000019486D370 ?\r\n                                                   9FFFFFFFFFFF07FC ?\r\nkkqdrv()+992         call     0000000000069409     9FFFFFFFBF557690 ?\r\n                                                   60000000001274D4 ?\r\n                                                   000000000 ?\r\n                                                   400000000320AE60 ?\r\n                                                   6000000000127434 ?\r\n                                                   00006858F ?\r\nkkqctdrvIT()+768     call     0000000000069409     9FFFFFFFBF557690 ?\r\n                                                   9FFFFFFFBF557710 ?\r\n.\r\n.\r\n.\r\nmain()+352           call     _etext_f()+23058430  000000000 ?\r\n                              09017120608          9FFFFFFFFFFFF110 ?\r\nmain_opd_entry()+80  call     _etext_f()+23058430  000000002 ?\r\n                              09017120608          9FFFFFFFFFFFF5C0 ?\r\n                                                   C000000000033910 ?\r\n                                                   000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u9519\u8bef\u53d1\u751f\u5728Oracle\u7684\u9012\u5f52\u8c03\u7528\u8bed\u53e5\uff0c\u5728\u67e5\u8be2DBA_TYPES\u548cDBA_OBJECTS\u89c6\u56fe\u65f6\u62a5\u9519\u3002<br \/>\n\u68c0\u67e5\u4e86MOS\u53d1\u73b0\uff0c\u8fd9\u4e2a\u9519\u8bef\u7684\u63cf\u8ff0\u4e3a\uff1aOra-600 [15160] Joining Dba_objects and Dba_segments [ID 351092.1]\u3002\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u662f\u4e24\u4e2a\u5305\u542bUNION ALL\u7684\u89c6\u56fe\u5173\u8054\u3002<br \/>\n\u5f53\u524d\u7248\u672c\u662f10202\uff0c\u8fd9\u4e2abug\u572810.2.0.3\u4ee5\u4e0a\u7684\u7248\u672c\u88ab\u89e3\u51b3\u3002<br \/>\n\u9664\u4e86\u6253\u8865\u4e01\u4e4b\u5916\uff0c\u8fd8\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u9690\u542b\u53c2\u6570\u6765\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff1a\u8bbe\u7f6e_optimizer_cost_based_transformation\u4e3aoff\u6216\u8005_optimizer_push_pred_cost_based\u4e3afalse\uff0c\u540c\u6837\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u95ee\u9898\u3002\u4e0d\u8fc7\u8fd9\u79cd\u548c\u4f18\u5316\u5668\u76f8\u5173\u7684\u9690\u542b\u53c2\u6570\u7684\u4fee\u6539\uff0c\u53ef\u80fd\u4f1a\u5bf9\u6267\u884c\u8ba1\u5212\u7684\u4f18\u5316\u4ea7\u751f\u4e0d\u5229\u5f71\u54cd\uff0c\u56e0\u6b64\u4fee\u6539\u540e\u6709\u53ef\u80fd\u9020\u6210\u5c11\u90e8\u5206SQL\u8bed\u53e5\u6267\u884c\u8ba1\u5212\u7684\u6539\u53d8\uff0c\u56e0\u6b64\u5728\u786e\u8ba4\u4fee\u6539\u524d\u5e94\u8c28\u614e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002 \u5728\u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u5982\u4e0b\uff1a Wed Nov 2 11:13:17 2011 Errors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], [] Wed Nov 2 11:13:36 2011 Errors in file \/oracleapp\/oracle10g\/admin\/ora10\/udump\/ora10_ora_9007.trc: ORA-00600: internal error code, arguments: [15160], [], &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=306\">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":[227,8,228],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-4W","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/306"}],"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=306"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/306\/revisions"}],"predecessor-version":[{"id":316,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/306\/revisions\/316"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=306"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=306"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=306"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}