又一个ORA-600(12333)错误。
ORA-600(12333)错误：http://yangtingkun.itpub.net/post/468/526154
ORA-600(12333)错误和ORA-600(ttclxx1)错误：http://yangtingkun.itpub.net/post/468/526078
错误发生在9206RAC环境下：
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]
详细TRACE如下：
*** SESSION ID:(116.15703) 2011-07-12 17:26:57.605 *** 2011-07-12 17:26:57.605 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [12333], [19], [3], [15], [], [], [], [] CURRENT SQL statement FOR this SESSION: 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) ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ? 000000000 ? 00000004A ? FFFFFFFF7FFF9A58 ? 1032E18E8 ? kgeriv()+208 PTR_CALL 0000000000000000 000103705 ? 103705000 ? 103705468 ? 10370A000 ? 000102C00 ? 000000000 ? kgesiv()+108 CALL kgeriv() 1037056C8 ? 10381D0E8 ? 000000258 ? 0000013C8 ? FFFFFFFF7FFFD408 ? 103706A98 ? ksesic3()+92 CALL kgesiv() 1037056C8 ? 10381D0E8 ? 00000302D ? 000000003 ? FFFFFFFF7FFFD408 ? FFFFFFFF7FFFE2B0 ? opitsk()+5088 CALL ksesic3() 00000302D ? 000000000 ? 000000013 ? 000000000 ? 000000003 ? 000000000 ? opiino()+1572 CALL opitsk() 000000000 ? 000003000 ? 000000000 ? 000000000 ? 103707D28 ? FFFFFFFF7FFFEC04 ? opiodr()+1688 PTR_CALL 0000000000000000 000380007 ? 10370C658 ? 1037EE848 ? FFFFFFFF7FFFF940 ? 000000000 ? 5C4447BC8 ? opidrv()+736 CALL opiodr() 000103400 ? 10100C380 ? 10370D808 ? 103705808 ? 103707D40 ? FFFFFFFF7FFFF460 ? sou2o()+16 CALL opidrv() 000000000 ? 000000004 ? 1037051EC ? 00000003C ? 1037056C8 ? 000103400 ? main()+184 CALL sou2o() FFFFFFFF7FFFF960 ? 00000003C ? 000000004 ? FFFFFFFF7FFFF940 ? 000039E70 ? 000000000 ? _start()+380 CALL main() 000000002 ? FFFFFFFF7FFFFAA8 ? FFFFFFFF7FFFFAC0 ? 000000000 ? 000000000 ? 100000000 ? --------------------- Binary Stack Dump --------------------- |
其中在opiino函数中发现存在ORA-1403错误：
========== FRAME [6] (opiino()+1572 -> opitsk()) ========== %l0 FFFFFFFF7FFFDD2B %l1 000000010370D808 %l2 0000000000000000 %l3 000000010370D790 %l4 0000000000000000 %l5 000000010370D800 %l6 0000000000000001 %l7 000000000000000A %i0 0000000000000000 %i1 0000000000003000 %i2 0000000000000000 %i3 0000000000000000 %i4 0000000103707D28 %i5 FFFFFFFF7FFFEC04 %fp FFFFFFFF7FFFE411 rtn-pc 000000010100C9A4 argd FFFFFFFF7FFFD400 stret FFFFFFFF7FFFD400 xtraarg FFFFFFFF7FFFE4C1 locals FFFFFFFF7FFFD438 Dump OF memory FROM 0xFFFFFFFF7FFFD380 TO 0xFFFFFFFF7FFFD780 FFFFFFFF7FFFD380 FFFFFFFF 7FFFDD2B 00000001 0370D808 [.......+.....p..] FFFFFFFF7FFFD390 00000000 00000000 00000001 0370D790 [.............p..] FFFFFFFF7FFFD3A0 00000000 00000000 00000001 0370D800 [.............p..] FFFFFFFF7FFFD3B0 00000000 00000001 00000000 0000000A [................] FFFFFFFF7FFFD3C0 00000000 00000000 00000000 00003000 [..............0.] FFFFFFFF7FFFD3D0 00000000 00000000 00000000 00000000 [................] FFFFFFFF7FFFD3E0 00000001 03707D28 FFFFFFFF 7FFFEC04 [.....p}(........] FFFFFFFF7FFFD3F0 FFFFFFFF 7FFFE411 00000001 0100C9A4 [................] FFFFFFFF7FFFD400 FFFFFFFF 7DDC1A90 00000000 00000000 [....}...........] FFFFFFFF7FFFD410 00000000 00000013 00000000 00000000 [................] FFFFFFFF7FFFD420 00000000 00000003 00000000 00000000 [................] FFFFFFFF7FFFD430 00000000 0000000F 00000000 00000000 [................] FFFFFFFF7FFFD440 FFFFFFFF 7FFFEC08 00000000 00000053 [...............S] FFFFFFFF7FFFD450 00000001 03710D48 00000000 00000778 [.....q.H.......x] FFFFFFFF7FFFD460 00000001 02D67BE8 00000000 00000000 [......{.........] FFFFFFFF7FFFD470 00006FA3 7FFFE5D0 FFFFFFFF 7FFFEC0D [..o.............] FFFFFFFF7FFFD480 00080000 7DDBF3A6 00000001 02EB8304 [....}...........] FFFFFFFF7FFFD490 00004000 037A7A00 FFFFFFFF 7FFFEAB0 [..@..zz.........] FFFFFFFF7FFFD4A0 FFFFFFFF 7FFFE2B0 FFFFFFFF 7FFFE2B0 [................] FFFFFFFF7FFFD4B0 00000001 0370D790 FFFFFFFF 7FFFE2AA [.....p..........] FFFFFFFF7FFFD4C0 00000001 00000000 00000001 037EE740 [.............~.@] FFFFFFFF7FFFD4D0 00000000 FFFFFFFF FFFFFFFF FFFFEBFF [................] FFFFFFFF7FFFD4E0 00000000 00000000 00000000 00000000 [................] FFFFFFFF7FFFD4F0 FFFFFFFF 7DDC1AF8 FFFFFFFF 7DDC1AA8 [....}.......}...] FFFFFFFF7FFFD500 FFFFFFFF 7FFFEC04 FFFFFFFF 7DDC1A88 [............}...] FFFFFFFF7FFFD510 FFFFFFFF 7DDC1A90 00000000 7FFFFFFF [....}...........] FFFFFFFF7FFFD520 FFFFFFFF 4F52412D 30313430 333A206E [....ORA-01403: n] FFFFFFFF7FFFD530 6F206461 74612066 6F756E64 0A000000 [o DATA found....] FFFFFFFF7FFFD540 00000000 00000000 FFFFFFFF 7DDC1AA8 [............}...] FFFFFFFF7FFFD550 FFFFFFFF 7DDC1AB0 00000000 0000000A [....}...........] FFFFFFFF7FFFD560 FFFFFFFF 7DDC1A90 FFFFFFFF 7FFFE523 [....}..........#] FFFFFFFF7FFFD570 FFFFFFFF 7DDBF3A7 FFFFFFFF 7DDBF3BC [....}.......}...] FFFFFFFF7FFFD580 00000000 00000047 00000000 00000000 [.......G........] FFFFFFFF7FFFD590 00000000 00000000 00000000 00000000 [................] FFFFFFFF7FFFD5A0 00000000 00000000 00000047 00000001 [...........G....] FFFFFFFF7FFFD5B0 00000016 00000000 00000000 00000000 [................] FFFFFFFF7FFFD5C0 00000000 00000000 00000001 0359A570 [.............Y.p] FFFFFFFF7FFFD5D0 00000000 00000000 00000001 03590259 [.............Y.Y] FFFFFFFF7FFFD5E0 00000000 00000003 FFFFFFFF 7DDB6F48 [............}.oH] FFFFFFFF7FFFD5F0 FFFFFFFF 7FFFE750 00000000 00000000 [.......P........] FFFFFFFF7FFFD600 FFFFFFFF 7DDBF3A6 00000000 00000053 [....}..........S] FFFFFFFF7FFFD610 00000000 00000000 FFFFFFFF FFFFFFFF [................] FFFFFFFF7FFFD620 00000001 00000000 FFFFFFFF 7DDC1B00 [............}...] FFFFFFFF7FFFD630 FFFFFFFF 7DDBF3BB FFFFFFFF 7DDC1B08 [....}.......}...] FFFFFFFF7FFFD640 00000000 00000000 FFFFFFFF 7DDC1AA0 [............}...] FFFFFFFF7FFFD650 7FFFFFFF FFFFFFFF 00000016 FFFFEBFF [................] FFFFFFFF7FFFD660 FFFFFFFF 7FFFE83F 00000000 00000000 [.......?........] FFFFFFFF7FFFD670 FFFFFFFF 7DDC1AF8 FFFFFFFF 7FFFE849 [....}..........I] FFFFFFFF7FFFD680 FFFFFFFF 7DDC1AB0 FFFFFFFF 7DDC1A88 [....}.......}...] FFFFFFFF7FFFD690 FFFFFFFF 7DDC1A90 00000000 7FFFFFFF [....}...........] FFFFFFFF7FFFD6A0 00000000 00000003 00000001 0359025B [.............Y.[] FFFFFFFF7FFFD6B0 00000000 00000047 00000000 00000000 [.......G........] FFFFFFFF7FFFD6C0 0000002C 00000000 FFFFFFFF 7FFFE727 [...,...........'] FFFFFFFF7FFFD6D0 00000000 00000000 00000001 035901D8 [.............Y..] FFFFFFFF7FFFD6E0 FFFFFFFF 7DDC1AF8 FFFFFFFF 7DDC1AA8 [....}.......}...] FFFFFFFF7FFFD6F0 FFFFFFFF 7DDC1AB0 FFFFFFFF 7DDC1A88 [....}.......}...] FFFFFFFF7FFFD700 FFFFFFFF 7DDC1A90 FFFFFFFF 7DDBF3BD [....}.......}...] FFFFFFFF7FFFD710 00000004 7DDBF3A7 00000000 0000000A [....}...........] FFFFFFFF7FFFD720 00000000 00000047 FFFFFFFF 7FFFDF2E [.......G........] FFFFFFFF7FFFD730 00000000 00000000 00000000 00000000 [................] FFFFFFFF7FFFD740 00000000 00000000 00000000 00000001 [................] FFFFFFFF7FFFD750 00000000 00000000 00000000 00000005 [................] FFFFFFFF7FFFD760 00000000 00000016 0000002C 037EE7C8 [...........,.~..] FFFFFFFF7FFFD770 00000001 037EE848 00000000 00000000 [.....~.H........] |
检查报错CURSOR对应的信息，发现没有绑定变量的值：
Cursor 9 (ffffffff7ca60630): CURBOUND curiob: ffffffff7c956d20 curflg: 44 curpar: 0 curusr: 0 curses 5c43999d0 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) child pin: 0, child LOCK: 5cb8e3a48, parent LOCK: 5cb8e3be0 xscflg: 110424, parent handle: 5d1e23780, xscfl2: 5200008 Dumping cursor sharing failures: 22000 bhp SIZE: 160/600 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=584 offset=0 No bind buffers allocated bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=24 No bind buffers allocated bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=48 No bind buffers allocated bind 3: dty=1 mxl=128(90) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 SIZE=0 offset=72 No bind buffers allocated bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=200 No bind buffers allocated bind 5: dty=1 mxl=128(39) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 SIZE=0 offset=224 No bind buffers allocated bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=352 No bind buffers allocated bind 7: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=376 No bind buffers allocated bind 8: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=03 oacfl2=0 SIZE=0 offset=400 No bind buffers allocated bind 9: dty=1 mxl=128(90) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 SIZE=0 offset=424 No bind buffers allocated bind 10: dty=1 mxl=32(03) mal=00 scl=00 pre=00 oacflg=03 oacfl2=10 SIZE=0 offset=552 No bind buffers allocated END OF cursor dump ksedmp: no CURRENT context area |
由于绝大部分的ORA-600[12333]错误都与通信或网络层异常有关，因此根据上面的信息判断，问题可能发生在会话处理绑定变量时，发现找不到绑定变量的信息，而绑定变量无法找不到多半是客户端与服务器端交互的过程中出现意外，导致数据的丢失。
由于现有的已知bug没有和当前现象接近的，因此也没有明确的解决问题的方案。考虑到这个错误的发生极为偶然，几年的时间只出现了一次，可以考虑忽略这个问题。