{"id":1398,"date":"2013-07-14T23:03:07","date_gmt":"2013-07-14T15:03:07","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1398"},"modified":"2013-07-14T23:03:07","modified_gmt":"2013-07-14T15:03:07","slug":"ora-60017059%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1398","title":{"rendered":"ORA-600(17059)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.4 RAC\u51fa\u73b0\u5927\u91cf\u7684ORA-600[17059]\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Tue May 21 09:55:30 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:32 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:33 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:34 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:36 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:37 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nTue May 21 09:55:38 2013\r\nErrors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []<\/pre>\n<p>\u8be6\u7ec6TRACE\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>*** 2013-07-03 08:16:46.382\r\n*** ACTION NAME:() 2013-07-03 08:16:46.381\r\n*** MODULE NAME:() 2013-07-03 08:16:46.381\r\n*** SERVICE NAME:(SYS$USERS) 2013-07-03 08:16:46.381\r\n*** SESSION ID:(460.3380) 2013-07-03 08:16:46.380\r\nLIBRARY OBJECT HANDLE: handle=c000001349e9a160 mtx=c000001349e9a290(0) cdp=0\r\nname=\r\nINSERT INTO T_R_P_OY@D_UH (S_NUM ,P_CODE ,E_CODE ,CODE_STATE , T_CATE ,O_TYPE_CODE ,P_KEY ,O_TIME , O_DEPART_ID ,O_STAFF_ID ,R_TIME ,REMARK , P_TYPE ,P_ID ,F_TYPE ,FOREGIFT ,RSV1 , RSV2 ,RSV3 ,RSV4 ,RSV5 ,RSV6 , W_CARD_TYPE ,S_CODE ,P_KEY_MODE) VALUES (:B25 ,:B24 ,:B23 ,:B22 , :B21 ,:B20 ,:B19 ,:B18 , :B17 ,:B16 ,:B15 ,:B14 , :B13 ,:B12 ,:B11 ,:B10 ,:B9 , :B8 ,:B7 ,:B6 ,:B5 ,:B4 , :B3 ,:B2 ,:B\r\nhash=191708dff85615cba49f2013927d9b70 timestamp=05-15-2013 16:56:26\r\nnamespace=CRSR flags=RON\/KGHP\/TIM\/OBS\/PN0\/LRG\/DBN\/MTX\/[104100c1]\r\nkkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=10 hpc=7ada hlc=7ada\r\nlwt=c000001349e9a208[c000001349e9a208,c000001349e9a208] ltm=c000001349e9a218[c000001349e9a218,c000001349e9a218]\r\npwt=c000001349e9a1d0[c000001349e9a1d0,c000001349e9a1d0] ptm=c000001349e9a1e0[c000001349e9a1e0,c000001349e9a1e0]\r\nref=c000001349e9a238[c000001349e9a238,c000001349e9a238] lnd=c000001349e9a250[c000001355aa6bf8,c0000013374654c8]\r\n  LOCK OWNERS:\r\n      lock     user  session count mode flags\r\n  -------- -------- -------- ----- ---- ------------------------\r\n  c00000133808f6f0 c00000103d35e2b0 c00000103d35e2b0     1 N    [00]\r\n  LIBRARY OBJECT: object=c000001346657eb8\r\n  type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0\r\n  CHILDREN: size=32768\r\n  child#    table reference   handle\r\n  ------ -------- --------- --------\r\n       0 c00000134fc4cf30 c00000134fc4cba0 c000001340160d80\r\n       1 c00000134fc4cf30 c000001363a76b48 c00000135dabf960\r\n       2 c00000134fc4cf30 c00000135a292320 c00000136988b450\r\n       3 c00000134fc4cf30 c000001337db37a0 c00000133487dac0\r\n       4 c00000134fc4cf30 c00000135dcf2be8 c000001346fd8448\r\n.\r\n.\r\n.\r\n*** 2013-07-03 08:16:46.734\r\nksedmp: internal or fatal error\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], []\r\nNo current SQL statement being executed.\r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\nc000001331c31eb0        31  procedure U_T.P_D_P_O\r\nc000001339ef8bf0         1  anonymous block\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     ksedst1()            000000000 ? 000000001 ?\r\nksedmp()+2176        call     ksedst()             000000000 ?\r\n                                                   C000000000000C9F ?\r\n                                                   4000000003FF5020 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nksfdmp()+48          call     ksedmp()             000000003 ?\r\nkgeriv()+336         call     ksfdmp()             C000000000000695 ?\r\n                                                   000000003 ?\r\n                                                   400000000946EB60 ?\r\n                                                   0000CF507 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nkgesiv()+192         call     kgeriv()             6000000000031370 ?\r\n                                                   6000000000032428 ?\r\n                                                   40000000019EDB40 ?\r\n                                                   000000001 ?\r\n                                                   9FFFFFFFFFFEC3B8 ?\r\nkgesic1()+128        call     kgesiv()             6000000000031370 ?\r\n                                                   9FFFFFFFFD3114C0 ?\r\n                                                   9FFFFFFFFD3114D0 ?\r\n                                                   000000001 ?\r\n                                                   9FFFFFFFFFFEC3B8 ?\r\n$cold_kgltba()+464   call     kgesic1()            6000000000031370 ?\r\n                                                   9FFFFFFFFD3114C0 ?\r\n                                                   0000042A3 ? 000000002 ?\r\n                                                   C000001346657EB8 ?\r\n                                                   C000000000004F26 ?\r\n                                                   4000000003351960 ?\r\n                                                   0000CF54D ?\r\nkglhdgc()+608        call     $cold_kgltba()       6000000000031370 ?\r\n                                                   C000001346657EB8 ?\r\n                                                   C0000013466581D8 ?\r\n                                                   C00000134F0E5288 ?\r\n                                                   60000000000314E0 ?\r\n                                                   C0000013DE36F380 ?\r\n                                                   C00000134F0E5288 ?\r\n                                                   C0000013F2E679D0 ?\r\nkglget()+5536        call     kglhdgc()            6000000000031370 ?\r\n                                                   C000001346657EB8 ?\r\n                                                   9FFFFFFFFFFEC7EE ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   010010000 ?\r\n                                                   C0000013466581D8 ?\r\n                                                   9FFFFFFFFFFEC478 ?\r\nkxsGetLookupLock()+  call     kglget()             6000000000031370 ?\r\n336                                                9FFFFFFFFFFEC7D0 ?\r\n                                                   000000001 ? 000000003 ?\r\n                                                   9FFFFFFFFD370460 ?\r\nkksfbc()+15568       call     kxsGetLookupLock()   6000000000031370 ?\r\n                                                   9FFFFFFFFD370438 ?\r\n                                                   9FFFFFFFFFFEC7D0 ?\r\n                                                   C000000000001EC5 ?\r\n                                                   4000000002EEFB60 ?\r\n                                                   9FFFFFFFFD370458 ?\r\n                                                   9FFFFFFFFD370460 ?\r\n                                                   9FFFFFFFFFFEC7F8 ?\r\nkkspbd0()+1184       call     kksfbc()             9FFFFFFFFFFED910 ?\r\n                                                   400000000324E890 ?\r\n                                                   0000C8213 ?\r\n                                                   9FFFFFFFFFFEC5F4 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   C000001346657FD8 ?\r\n                                                   C000001346657FD8 ?\r\nkksParseCursor()+81  call     kkspbd0()            000003F50 ? 000000003 ?\r\n6                                                  000080000 ?\r\n                                                   60000000000C6208 ?\r\n                                                   9FFFFFFFFD370418 ?\r\n                                                   9FFFFFFFFD370570 ?\r\n                                                   60000000000B5E18 ?\r\nopiosq0()+4320       call     kksParseCursor()     9FFFFFFFFFFEDB80 ?\r\n                                                   C000000000001736 ?\r\n                                                   4000000002E99F80 ?\r\n                                                   9FFFFFFFFD3C1AB0 ?\r\n                                                   0FFDFFFFF ?\r\n                                                   60000000000C4BF0 ?\r\n                                                   60000000000C4F48 ?\r\n                                                   60000000000C4EE0 ?\r\nopipls()+3392        call     opiosq0()            000000003 ?\r\n                                                   9FFFFFFFFFFEE620 ?\r\n                                                   4000000003009120 ?\r\n                                                   00000F1DF ?\r\n                                                   9FFFFFFFFFFEDA40 ?\r\n                                                   60000000000B5E18 ?\r\n                                                   C00000000000224C ?\r\n                                                   0000001ED ?\r\nopiodr()+2128        call     opipls()             9FFFFFFFFFFEEF30 ?\r\n                                                   4000000002E42BA0 ?\r\n                                                   00000E09F ?\r\n                                                   9FFFFFFFFFFEE680 ?\r\n                                                   60000000000B5E18 ?\r\n                                                   9FFFFFFFFFFEEA10 ?\r\nrpidrus()+352        call     opiodr()             000000066 ? 000000006 ?\r\n                                                   4000000001B01EC0 ?\r\n                                                   0000046B0 ?\r\n                                                   9FFFFFFFFFFEEF40 ?\r\n                                                   60000000000B5E18 ?\r\nskgmstack()+288      call     rpidrus()            9FFFFFFFFFFF1680 ?\r\n                                                   9FFFFFFFFFFF10C0 ?\r\n                                                   60000000000B5E18 ?\r\n                                                   9FFFFFFFFFFF1640 ?\r\n                                                   C000000000000716 ?\r\n                                                   4000000002E819C0 ?\r\n                                                   00000E05F ?\r\n                                                   9FFFFFFFFFFF1120 ?\r\n.\r\n.\r\n.<\/pre>\n<p>\u62a5\u9519\u4e3aORA-600(17059)\u7684BUG\u6709\u5f88\u591a\uff0c\u4e0d\u8fc7\u6839\u636e\u62a5\u9519\u5806\u6808\u4fe1\u606f\u4ee5\u53caORA-600\u4e4b\u524d\u51fa\u73b0\u7684LIBRARY CACHE\u4fe1\u606f\uff0c\u53ef\u4ee5\u786e\u8ba4Bug 8922013 &#8211; OERI [17059] \/ excess child cursors for SQL referencing REMOTE objects [ID 8922013.8]\u63cf\u8ff0\u7684\u95ee\u9898\u548c\u5f53\u524d\u4e00\u81f4\u3002<br \/>\n\u5f53\u8bed\u53e5\u901a\u8fc7\u6570\u636e\u5e93\u94fe\u8fdb\u884c\u8fdc\u7aef\u8bbf\u95ee\uff0c\u53ef\u80fd\u4f1a\u9020\u6210\u5b50\u6e38\u6807\u65e0\u6cd5\u91cd\u7528\uff0c\u4ece\u800c\u5bfc\u81f4\u5927\u91cf\u7684ORA-600\u9519\u8bef\u7684\u51fa\u73b0\u3002\u8fd9\u4e2a\u95ee\u9898\u5f71\u54cd10.2.0.4\u548c10.2.0.5\uff0cOracle\u4ecd\u7136\u6ca1\u6709\u5f7b\u5e95\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u4e8b\u5b9e\u4e0a\u662f\u572810.2.0.4\u4e2d\u89e3\u51b3\u4e86Bug 4581334  Cursors accessing remote tables may be repeatedly rebuilt and not used\u7684\u95ee\u9898\uff0c\u800c\u5f15\u53d1\u4e86\u5f53\u524d\u7684BUG\u3002Oracle\u76ee\u524d\u5e76\u6ca1\u6709\u7ed9\u51fa\u4e00\u4e2a\u89e3\u51b3\u65b9\u6848\uff0c\u4e5f\u6ca1\u6709\u660e\u786e\u54ea\u4e2a\u7248\u672c\u4f1a\u4fee\u6b63\u8fd9\u4e2a\u95ee\u9898\u3002\u8fd9\u662f\u9488\u5bf9\u4e00\u4e9b\u5e73\u53f0\u63d0\u4f9b\u4e86\u5355\u72ec\u7684\u8865\u4e01\uff0c\u4f46\u662f\u5b89\u88c5\u8fd9\u4e2a\u8865\u4e01\u610f\u5473\u7740\u64a4\u9500\u5bf9BUG 4581334\u7684\u4fee\u6b63\u3002<br \/>\n\u8fd9\u4e2aBUG\u5e76\u4e0d\u4f1a\u5bfc\u81f4\u4efb\u4f55\u529f\u80fd\u4e0a\u7684\u95ee\u9898\uff0c\u4f46\u662f\u53ef\u80fd\u4f1a\u5728\u77ed\u65f6\u95f4\u5185\u751f\u6210\u5927\u91cf\u7684TRACE\u4ece\u800c\u5c06ORACLE_BASE\u76ee\u5f55\u6491\u6ee1\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.4 RAC\u51fa\u73b0\u5927\u91cf\u7684ORA-600[17059]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Tue May 21 09:55:30 2013 Errors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc: ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], [], [], [] Tue May 21 09:55:32 2013 Errors in file \/oraclelog\/admin\/orcl\/bdump\/orcl1_j000_307.trc: ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801, \u53c2\u6570: [17059], [0xC000001346657EB8], [], [], [], &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1398\">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":[1221,1225,1222,8,1224,1223],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-my","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1398"}],"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=1398"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1398\/revisions"}],"predecessor-version":[{"id":1399,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1398\/revisions\/1399"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}