联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
alert日志出现ORA-00600[17059]
Wed Aug 01 03:19:29 2012 Errors in file /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_5177388.trc (incident=682625): ORA-00600: 内部错误代码, 参数: [17059], [0x700000A18EE85E0], [0x70000085506A820], [0x700000A51F56E40], [], [], [], [] Incident details in: /oracle/diag/rdbms/sgerp5/sgerp5/incident/incdir_682625/sgerp5_ora_5177388_i682625.trc
查看trace文件
Dump continued from file: /oracle/diag/rdbms/sgerp5/sgerp5/trace/sgerp5_ora_5177388.trc
ORA-00600: 内部错误代码, 参数: [17059], [0x700000A3ED7B240], [0x7000007C19384F8], [0x70000078BC51048], [], [], [], []
========= Dump for incident 682624 (ORA 600 [17059]) ========
*** 2012-07-31 22:38:06.130
----- Current SQL Statement for this session (sql_id=03vurqhdanbv6) -----
begin
insert into "000".tbExhRes(DeptCode,ERCode,ERName,CategoryCode,GoodsCategoryCode,TermMoney,IsAllowOwned,CategoryItemCode,GoodsCategoryItemCode)
values('1521','20070115210130','连云港通灌路购物广场地堆130','200701','0201',1200,1,'0000','0000');
insert into "000".tbExhRes(DeptCode,ERCode,ERName,CategoryCode,GoodsCategoryCode,TermMoney,IsAllowOwned,CategoryItemCode,GoodsCategoryItemCode)
values('1521','20070115210131','连云港通灌路购物广场地堆131','200701','0201',1200,1,'0000','0000');
…………近5万条类此sql
end;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+002c bl 105e27f1c
ksedst1()+0064 bl 101fadb74
ksedst()+0028 bl ksedst1() 000000000 ? 000000000 ?
dbkedDefDump()+07fc bl 101faf398
ksedmp()+0048 bl 101fadb70
ksfdmp()+0058 bl ksedmp() 000000000 ?
dbgexPhaseII()+0130 bl _ptrgl()
dbgexProcessError() bl dbgexPhaseII() 110383690 ? 000000000 ?
+09bc 600000006 ?
dbgeExecuteForError bl dbgexProcessError() 110383690 ? 110388B10 ?
()+0040 1729C5E38 ? 000004028 ?
dbgePostErrorKGE()+ bl dbgeExecuteForError FFFFFFFFFFF02C0 ? 110000328 ?
03c0 () FFFFFFFFFFF0350 ?
484222407FFFFFF8 ?
100154D20 ?
dbkePostKGE_kgsf()+ bl dbgePostErrorKGE() 000000258 ? 110000328 ?
003c 25810594518 ?
kgeade()+0300 bl _ptrgl()
kgeriv_int()+0068 bl kgeade() 1070DA620 ? 1070DADB8 ?
1070D9E48 ? 1070DB208 ?
1070DA784 ? 1070DA788 ?
1070DA77C ? 1070DA794 ?
kgeriv()+0020 bl kgeriv_int() 7000007C19384F8 ? 000000000 ?
000000001 ? FFFFFFFFFFF11E0 ?
700000A62228320 ?
7000007C19384F8 ?
kgesiv()+007c bl kgeriv() 10102D590 ? 700000A3ED7B350 ?
700000A62228320 ? 000000005 ?
000000000 ?
kgesic3()+0040 bl kgesiv() 7000007C19384F8 ? 000000000 ?
000000001 ? FFFFFFFFFFF11E0 ?
700000A62228320 ?
kgltba()+0134 bl kgesic3() 110000328 ? 110594518 ?
42A3000042A3 ? 000000002 ?
700000A3ED7B240 ? 000000002 ?
7000007C19384F8 ? 000000002 ?
kglrdtin()+01d4 bl kgltba() FFFFFFFFFFF1470 ? 000000000 ?
FFFFFFFFFFF1318 ? 000000000 ?
000000001 ? 12BFB90F8 ?
kglrtl()+0020 bl kglrdtin() 000000001 ? 000000000 ?
000000001 ? 169F90F18 ?
169F8E7F0 ? 12BFB90F8 ?
FFFFFFFFFFF1470 ?
pdy3M06_Add_Sql_Str bl kglrtl() FFFFFFFFFFF14F0 ?
ing()+00c4 7FFF000000007FFF ?
10262A2A8 ? 11032DD20 ?
26FDBFA00 ?
pdy8M92_Fill_SQD()+ bl pdy3M06_Add_Sql_Str 102683768 ? 000000000 ?
006c ing() 10267265C ?
pdy8M74_Fill_Descri bl 101faf1a4
ptor()+0124
pdy8F07_Materialize bl pdy8M74_Fill_Descri 164B00E58 ? 165BD0380 ?
_Descriptors()+038c ptor() 7000008C99BA368 ?
pdy1F82_Write_MCode bl pdy8F07_Materialize FFFFFFFFFFF3968 ? 000000000 ?
()+0084 _Descriptors()
pdy1F01_Driver()+01 bl pdy1F82_Write_MCode FFFFFFFFFFF18D0 ? 10726667C ?
58 () 7000008EA0F18D8 ?
pdw0F82_Run_Code_Ge bl pdy1F01_Driver() 1028771D4 ? 000000000 ?
n()+0088
pdw0F01_Code_Gen()+ bl pdw0F82_Run_Code_Ge FFFFFFFFFFF1A50 ? 12BFC3E48 ?
0250 n()
phpcog()+0010 bl pdw0F01_Code_Gen() FFFFFFFFFFF3968 ?
70000078BC51048 ? 000000004 ?
phpcmp()+13a0 bl phpcog() 11037D140 ? 700000000003640 ?
pcicog()+0234 bl phpcmp() FFFFFFFFFFF3968 ?
70000078BC51048 ? 000000000 ?
000000000 ? 400000110000BEC ?
FFFFFFFFFFF33F0 ? 000000000 ?
000000000 ?
kkxcog()+01cc bl pcicog() FFFFFFFFFFF3968 ?
70000078BC51048 ?
opitca()+0a50 bl kkxcog() 10009697C ?
kksFullTypeCheck()+ bl opitca() 11082EDB8 ? 7000008C99BA740 ?
001c
rpiswu2()+03c0 bl _ptrgl()
kksLoadChild()+31e4 bl rpiswu2() 700000A717262C8 ?
7000008EA0F1970 ?
7000008C99BAA78 ? 107267650 ?
000000000 ? 55D16B348 ?
FFFFFFFFFFF72B8 ? 000000000 ?
kxsGetRuntimeLock() bl kksLoadChild() 110000328 ? 70000078BC51048 ?
+083c 700000A57852278 ?
kksfbc()+2230 bl kxsGetRuntimeLock() 110000328 ? 11082EDB8 ?
FFFFFFFFFFF72B8 ?
12C00000000 ?
100006300000000 ?
kkspsc0()+106c bl kksfbc() 11082EDB8 ? 3FFFF8150 ?
1085D16C170 ? 149510630 ?
000AE3AD5 ? 000000000 ?
000000000 ? 000000000 ?
kksParseCursor()+00 bl kkspsc0() 1105B2748 ? 149510630 ?
cc 000AE3AD5 ? 31032DD20 ?
600000000 ? A4000000000000 ?
000000000 ?
opiosq0()+0b18 bl 103ecdd38
kpooprx()+019c bl 101fadff0
kpoal8()+04c0 bl kpooprx() FFFFFFFFFFFB454 ? 149510630 ?
AE3AD400AE3AD4 ? 100000001 ?
000000000 ? A40000000000A4 ?
opiodr()+0b48 bl 103ec82b0
ttcpip()+114c bl _ptrgl()
opitsk()+169c bl 103eca2bc
opiino()+09a0 bl opitsk() 1100981E8 ? 000000000 ?
opiodr()+0b48 bl 103ec82b0
opidrv()+0440 bl opiodr() 3C2F736765 ? 41032DD20 ?
FFFFFFFFFFFF8C0 ? 05F353137 ?
sou2o()+0090 bl opidrv() 3C05C052EC ? 4A0071E60 ?
FFFFFFFFFFFF8C0 ?
opimai_real()+01b0 bl 101fad8cc
main()+0090 bl opimai_real() 000000000 ? 000000000 ?
__start()+0070 bl main() 000000000 ? 000000000 ?
--------------------- Binary Stack Dump ---------------------
ORA-00600[17059]错误大部分都是因为高版本导致,对于本库的分析:因为该库的shared pool老化比较频繁,到我介入的时候,发现相关该类此sql已经不能找到,不能非常肯定的找出来原因,猜测可能原因是:这个库(版本为11.1.0.6 FOR AIX)因为开发基本上没有绑定参数,设置cursor_sharing=force,这里5万多条的insert会自动转换为参数形式,因为每个insert参数对应的值长度区别较大,使得BIND_MISMATCH不匹配导致高版本现象严重,从而出现了该Bug 9689310.
解决该问题
1.不要通过程序拼接sql出来,使用绑定参数形式
2.升级到相应新版本解决该问题
3.一次减少执行的sql数量,定时刷新shared pool[临时办法]
补充说明相关bug
Bug 5177766 OERI[17059] with SESSION_CACHED_CURSORS
Bug 8946311 Increase max children before reporting ORA-600 [17059]
BUG 9094984 ORA-600 [17059] WITH VERY HIGH CHILD CURSOR COUNTS BEING GENERATED
Bug 8922013 OERI [17059] / excess child cursors for SQL referencing REMOTE objects
Bug 9689310 Excessive child cursors / high VERSION_COUNT / OERI:17059 due to bind mismatch
BUG 8981059 HIGH VERSION COUNT:BIND_MISMATCH,USER_BIND_PEEK_MISMATCH,OPTIMIZER_MODE_MISMATCH