{"id":1351,"date":"2012-11-05T23:53:14","date_gmt":"2012-11-05T15:53:14","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1351"},"modified":"2013-07-07T23:58:48","modified_gmt":"2013-07-07T15:58:48","slug":"ora-60012333%e9%94%99%e8%af%af%ef%bc%88%e4%ba%8c%ef%bc%89","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1351","title":{"rendered":"ORA-600(12333)\u9519\u8bef\uff08\u4e8c\uff09"},"content":{"rendered":"<p>\u53c8\u4e00\u4e2aORA-600(12333)\u9519\u8bef\u3002<br \/>\nORA-600(12333)\u9519\u8bef\uff1a<a href=\"http:\/\/yangtingkun.itpub.net\/post\/468\/526154\">http:\/\/yangtingkun.itpub.net\/post\/468\/526154<\/a><br \/>\nORA-600(12333)\u9519\u8bef\u548cORA-600(ttclxx1)\u9519\u8bef\uff1a<a href=\"http:\/\/yangtingkun.itpub.net\/post\/468\/526078\">http:\/\/yangtingkun.itpub.net\/post\/468\/526078<\/a><br \/>\n\u9519\u8bef\u53d1\u751f\u57289206RAC\u73af\u5883\u4e0b\uff1a<br \/>\nTue Jul 12 17:26:57 2011<br \/>\nErrors in file \/opt\/app\/admin\/orcl\/udump\/orcl1_ora_28993.trc:<br \/>\nORA-00600: internal error code, arguments: [12333], [19], [3], [15], [], [], [], []<br \/>\nTue Jul 12 17:26:58 2011<br \/>\nTrace dumping is performing id=[cdmp_20110712172658]<br \/>\n\u8be6\u7ec6TRACE\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>*** SESSION ID:(116.15703) 2011-07-12 17:26:57.605\r\n*** 2011-07-12 17:26:57.605\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [12333], [19], [3], [15], [], [], [], []\r\nCurrent SQL statement for this session:\r\nINSERT INTO BACK_SESSION (SESSION_SEQ, LOGIN_TIME, LOGOUT_TIME, SESSION_ID, TIMEOUT, LOGIN_ADDR, SUM_PAY, USER_SEQ, SUM_ACCESS, UNIQ_TOKEN, STATUS) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?\r\n                                                   000000000 ? 00000004A ?\r\n                                                   FFFFFFFF7FFF9A58 ?\r\n                                                   1032E18E8 ?\r\nkgeriv()+208         PTR_CALL 0000000000000000     000103705 ? 103705000 ?\r\n                                                   103705468 ? 10370A000 ?\r\n                                                   000102C00 ? 000000000 ?\r\nkgesiv()+108         CALL     kgeriv()             1037056C8 ? 10381D0E8 ?\r\n                                                   000000258 ? 0000013C8 ?\r\n                                                   FFFFFFFF7FFFD408 ?\r\n                                                   103706A98 ?\r\nksesic3()+92         CALL     kgesiv()             1037056C8 ? 10381D0E8 ?\r\n                                                   00000302D ? 000000003 ?\r\n                                                   FFFFFFFF7FFFD408 ?\r\n                                                   FFFFFFFF7FFFE2B0 ?\r\nopitsk()+5088        CALL     ksesic3()            00000302D ? 000000000 ?\r\n                                                   000000013 ? 000000000 ?\r\n                                                   000000003 ? 000000000 ?\r\nopiino()+1572        CALL     opitsk()             000000000 ? 000003000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   103707D28 ?\r\n                                                   FFFFFFFF7FFFEC04 ?\r\nopiodr()+1688        PTR_CALL 0000000000000000     000380007 ? 10370C658 ?\r\n                                                   1037EE848 ?\r\n                                                   FFFFFFFF7FFFF940 ?\r\n                                                   000000000 ? 5C4447BC8 ?\r\nopidrv()+736         CALL     opiodr()             000103400 ? 10100C380 ?\r\n                                                   10370D808 ? 103705808 ?\r\n                                                   103707D40 ?\r\n                                                   FFFFFFFF7FFFF460 ?\r\nsou2o()+16           CALL     opidrv()             000000000 ? 000000004 ?\r\n                                                   1037051EC ? 00000003C ?\r\n                                                   1037056C8 ? 000103400 ?\r\nmain()+184           CALL     sou2o()              FFFFFFFF7FFFF960 ?\r\n                                                   00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFF940 ?\r\n                                                   000039E70 ? 000000000 ?\r\n_start()+380         CALL     main()               000000002 ?\r\n                                                   FFFFFFFF7FFFFAA8 ?\r\n                                                   FFFFFFFF7FFFFAC0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   100000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u5176\u4e2d\u5728opiino\u51fd\u6570\u4e2d\u53d1\u73b0\u5b58\u5728ORA-1403\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>========== FRAME [6] (opiino()+1572 -> opitsk()) ==========\r\n%l0 FFFFFFFF7FFFDD2B %l1 000000010370D808 %l2 0000000000000000 \r\n%l3 000000010370D790 %l4 0000000000000000 %l5 000000010370D800 \r\n%l6 0000000000000001 %l7 000000000000000A %i0 0000000000000000 \r\n%i1 0000000000003000 %i2 0000000000000000 %i3 0000000000000000 \r\n%i4 0000000103707D28 %i5 FFFFFFFF7FFFEC04 %fp FFFFFFFF7FFFE411 \r\nrtn-pc 000000010100C9A4 argd FFFFFFFF7FFFD400 stret FFFFFFFF7FFFD400 \r\nxtraarg FFFFFFFF7FFFE4C1 locals FFFFFFFF7FFFD438 \r\nDump of memory from 0xFFFFFFFF7FFFD380 to 0xFFFFFFFF7FFFD780\r\nFFFFFFFF7FFFD380 FFFFFFFF 7FFFDD2B 00000001 0370D808  [.......+.....p..]\r\nFFFFFFFF7FFFD390 00000000 00000000 00000001 0370D790  [.............p..]\r\nFFFFFFFF7FFFD3A0 00000000 00000000 00000001 0370D800  [.............p..]\r\nFFFFFFFF7FFFD3B0 00000000 00000001 00000000 0000000A  [................]\r\nFFFFFFFF7FFFD3C0 00000000 00000000 00000000 00003000  [..............0.]\r\nFFFFFFFF7FFFD3D0 00000000 00000000 00000000 00000000  [................]\r\nFFFFFFFF7FFFD3E0 00000001 03707D28 FFFFFFFF 7FFFEC04  [.....p}(........]\r\nFFFFFFFF7FFFD3F0 FFFFFFFF 7FFFE411 00000001 0100C9A4  [................]\r\nFFFFFFFF7FFFD400 FFFFFFFF 7DDC1A90 00000000 00000000  [....}...........]\r\nFFFFFFFF7FFFD410 00000000 00000013 00000000 00000000  [................]\r\nFFFFFFFF7FFFD420 00000000 00000003 00000000 00000000  [................]\r\nFFFFFFFF7FFFD430 00000000 0000000F 00000000 00000000  [................]\r\nFFFFFFFF7FFFD440 FFFFFFFF 7FFFEC08 00000000 00000053  [...............S]\r\nFFFFFFFF7FFFD450 00000001 03710D48 00000000 00000778  [.....q.H.......x]\r\nFFFFFFFF7FFFD460 00000001 02D67BE8 00000000 00000000  [......{.........]\r\nFFFFFFFF7FFFD470 00006FA3 7FFFE5D0 FFFFFFFF 7FFFEC0D  [..o.............]\r\nFFFFFFFF7FFFD480 00080000 7DDBF3A6 00000001 02EB8304  [....}...........]\r\nFFFFFFFF7FFFD490 00004000 037A7A00 FFFFFFFF 7FFFEAB0  [..@..zz.........]\r\nFFFFFFFF7FFFD4A0 FFFFFFFF 7FFFE2B0 FFFFFFFF 7FFFE2B0  [................]\r\nFFFFFFFF7FFFD4B0 00000001 0370D790 FFFFFFFF 7FFFE2AA  [.....p..........]\r\nFFFFFFFF7FFFD4C0 00000001 00000000 00000001 037EE740  [.............~.@]\r\nFFFFFFFF7FFFD4D0 00000000 FFFFFFFF FFFFFFFF FFFFEBFF  [................]\r\nFFFFFFFF7FFFD4E0 00000000 00000000 00000000 00000000  [................]\r\nFFFFFFFF7FFFD4F0 FFFFFFFF 7DDC1AF8 FFFFFFFF 7DDC1AA8  [....}.......}...]\r\nFFFFFFFF7FFFD500 FFFFFFFF 7FFFEC04 FFFFFFFF 7DDC1A88  [............}...]\r\nFFFFFFFF7FFFD510 FFFFFFFF 7DDC1A90 00000000 7FFFFFFF  [....}...........]\r\nFFFFFFFF7FFFD520 FFFFFFFF 4F52412D 30313430 333A206E  [....ORA-01403: n]\r\nFFFFFFFF7FFFD530 6F206461 74612066 6F756E64 0A000000  [o data found....]\r\nFFFFFFFF7FFFD540 00000000 00000000 FFFFFFFF 7DDC1AA8  [............}...]\r\nFFFFFFFF7FFFD550 FFFFFFFF 7DDC1AB0 00000000 0000000A  [....}...........]\r\nFFFFFFFF7FFFD560 FFFFFFFF 7DDC1A90 FFFFFFFF 7FFFE523  [....}..........#]\r\nFFFFFFFF7FFFD570 FFFFFFFF 7DDBF3A7 FFFFFFFF 7DDBF3BC  [....}.......}...]\r\nFFFFFFFF7FFFD580 00000000 00000047 00000000 00000000  [.......G........]\r\nFFFFFFFF7FFFD590 00000000 00000000 00000000 00000000  [................]\r\nFFFFFFFF7FFFD5A0 00000000 00000000 00000047 00000001  [...........G....]\r\nFFFFFFFF7FFFD5B0 00000016 00000000 00000000 00000000  [................]\r\nFFFFFFFF7FFFD5C0 00000000 00000000 00000001 0359A570  [.............Y.p]\r\nFFFFFFFF7FFFD5D0 00000000 00000000 00000001 03590259  [.............Y.Y]\r\nFFFFFFFF7FFFD5E0 00000000 00000003 FFFFFFFF 7DDB6F48  [............}.oH]\r\nFFFFFFFF7FFFD5F0 FFFFFFFF 7FFFE750 00000000 00000000  [.......P........]\r\nFFFFFFFF7FFFD600 FFFFFFFF 7DDBF3A6 00000000 00000053  [....}..........S]\r\nFFFFFFFF7FFFD610 00000000 00000000 FFFFFFFF FFFFFFFF  [................]\r\nFFFFFFFF7FFFD620 00000001 00000000 FFFFFFFF 7DDC1B00  [............}...]\r\nFFFFFFFF7FFFD630 FFFFFFFF 7DDBF3BB FFFFFFFF 7DDC1B08  [....}.......}...]\r\nFFFFFFFF7FFFD640 00000000 00000000 FFFFFFFF 7DDC1AA0  [............}...]\r\nFFFFFFFF7FFFD650 7FFFFFFF FFFFFFFF 00000016 FFFFEBFF  [................]\r\nFFFFFFFF7FFFD660 FFFFFFFF 7FFFE83F 00000000 00000000  [.......?........]\r\nFFFFFFFF7FFFD670 FFFFFFFF 7DDC1AF8 FFFFFFFF 7FFFE849  [....}..........I]\r\nFFFFFFFF7FFFD680 FFFFFFFF 7DDC1AB0 FFFFFFFF 7DDC1A88  [....}.......}...]\r\nFFFFFFFF7FFFD690 FFFFFFFF 7DDC1A90 00000000 7FFFFFFF  [....}...........]\r\nFFFFFFFF7FFFD6A0 00000000 00000003 00000001 0359025B  [.............Y.[]\r\nFFFFFFFF7FFFD6B0 00000000 00000047 00000000 00000000  [.......G........]\r\nFFFFFFFF7FFFD6C0 0000002C 00000000 FFFFFFFF 7FFFE727  [...,...........']\r\nFFFFFFFF7FFFD6D0 00000000 00000000 00000001 035901D8  [.............Y..]\r\nFFFFFFFF7FFFD6E0 FFFFFFFF 7DDC1AF8 FFFFFFFF 7DDC1AA8  [....}.......}...]\r\nFFFFFFFF7FFFD6F0 FFFFFFFF 7DDC1AB0 FFFFFFFF 7DDC1A88  [....}.......}...]\r\nFFFFFFFF7FFFD700 FFFFFFFF 7DDC1A90 FFFFFFFF 7DDBF3BD  [....}.......}...]\r\nFFFFFFFF7FFFD710 00000004 7DDBF3A7 00000000 0000000A  [....}...........]\r\nFFFFFFFF7FFFD720 00000000 00000047 FFFFFFFF 7FFFDF2E  [.......G........]\r\nFFFFFFFF7FFFD730 00000000 00000000 00000000 00000000  [................]\r\nFFFFFFFF7FFFD740 00000000 00000000 00000000 00000001  [................]\r\nFFFFFFFF7FFFD750 00000000 00000000 00000000 00000005  [................]\r\nFFFFFFFF7FFFD760 00000000 00000016 0000002C 037EE7C8  [...........,.~..]\r\nFFFFFFFF7FFFD770 00000001 037EE848 00000000 00000000  [.....~.H........]<\/pre>\n<p>\u68c0\u67e5\u62a5\u9519CURSOR\u5bf9\u5e94\u7684\u4fe1\u606f\uff0c\u53d1\u73b0\u6ca1\u6709\u7ed1\u5b9a\u53d8\u91cf\u7684\u503c\uff1a<\/p>\n<pre lang='SQL'>Cursor 9 (ffffffff7ca60630): CURBOUND  curiob: ffffffff7c956d20\r\n curflg: 44 curpar: 0 curusr: 0 curses 5c43999d0\r\n cursor name: INSERT INTO BACK_SESSION (SESSION_SEQ, LOGIN_TIME, LOGOUT_TIME, SESSION_ID, TIMEOUT, LOGIN_ADDR, SUM_PAY, USER_SEQ, SUM_ACCESS, UNIQ_TOKEN, STATUS) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)\r\n child pin: 0, child lock: 5cb8e3a48, parent lock: 5cb8e3be0\r\n xscflg: 110424, parent handle: 5d1e23780, xscfl2: 5200008\r\nDumping cursor sharing failures: 22000\r\n bhp size: 160\/600\r\n bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=584 offset=0\r\n   No bind buffers allocated\r\n bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=24\r\n   No bind buffers allocated\r\n bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=48\r\n   No bind buffers allocated\r\n bind 3: dty=1 mxl=128(90) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 size=0 offset=72\r\n   No bind buffers allocated\r\n bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=200\r\n   No bind buffers allocated\r\n bind 5: dty=1 mxl=128(39) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 size=0 offset=224\r\n   No bind buffers allocated\r\n bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=352\r\n   No bind buffers allocated\r\n bind 7: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=376\r\n   No bind buffers allocated\r\n bind 8: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 size=0 offset=400\r\n   No bind buffers allocated\r\n bind 9: dty=1 mxl=128(90) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 size=0 offset=424\r\n   No bind buffers allocated\r\n bind 10: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 size=0 offset=552\r\n   No bind buffers allocated\r\nEnd of cursor dump\r\nksedmp: no current context area<\/pre>\n<p>\u7531\u4e8e\u7edd\u5927\u90e8\u5206\u7684ORA-600[12333]\u9519\u8bef\u90fd\u4e0e\u901a\u4fe1\u6216\u7f51\u7edc\u5c42\u5f02\u5e38\u6709\u5173\uff0c\u56e0\u6b64\u6839\u636e\u4e0a\u9762\u7684\u4fe1\u606f\u5224\u65ad\uff0c\u95ee\u9898\u53ef\u80fd\u53d1\u751f\u5728\u4f1a\u8bdd\u5904\u7406\u7ed1\u5b9a\u53d8\u91cf\u65f6\uff0c\u53d1\u73b0\u627e\u4e0d\u5230\u7ed1\u5b9a\u53d8\u91cf\u7684\u4fe1\u606f\uff0c\u800c\u7ed1\u5b9a\u53d8\u91cf\u65e0\u6cd5\u627e\u4e0d\u5230\u591a\u534a\u662f\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u5668\u7aef\u4ea4\u4e92\u7684\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u610f\u5916\uff0c\u5bfc\u81f4\u6570\u636e\u7684\u4e22\u5931\u3002<br \/>\n\u7531\u4e8e\u73b0\u6709\u7684\u5df2\u77e5bug\u6ca1\u6709\u548c\u5f53\u524d\u73b0\u8c61\u63a5\u8fd1\u7684\uff0c\u56e0\u6b64\u4e5f\u6ca1\u6709\u660e\u786e\u7684\u89e3\u51b3\u95ee\u9898\u7684\u65b9\u6848\u3002\u8003\u8651\u5230\u8fd9\u4e2a\u9519\u8bef\u7684\u53d1\u751f\u6781\u4e3a\u5076\u7136\uff0c\u51e0\u5e74\u7684\u65f6\u95f4\u53ea\u51fa\u73b0\u4e86\u4e00\u6b21\uff0c\u53ef\u4ee5\u8003\u8651\u5ffd\u7565\u8fd9\u4e2a\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c8\u4e00\u4e2aORA-600(12333)\u9519\u8bef\u3002 ORA-600(12333)\u9519\u8bef\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/526154 ORA-600(12333)\u9519\u8bef\u548cORA-600(ttclxx1)\u9519\u8bef\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/526078 \u9519\u8bef\u53d1\u751f\u57289206RAC\u73af\u5883\u4e0b\uff1a Tue Jul 12 17:26:57 2011 Errors in file \/opt\/app\/admin\/orcl\/udump\/orcl1_ora_28993.trc: ORA-00600: internal error code, arguments: [12333], [19], [3], [15], [], [], [], [] Tue Jul 12 17:26:58 2011 Trace dumping is performing id=[cdmp_20110712172658] \u8be6\u7ec6TRACE\u5982\u4e0b\uff1a *** SESSION ID:(116.15703) &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1351\">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":[413,1192,1191,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-lN","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1351"}],"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=1351"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1351\/revisions"}],"predecessor-version":[{"id":1352,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1351\/revisions\/1352"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}