-
加我微信(17813235971)
加我QQ(107644445)
标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-01595 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,769)
- DB2 (22)
- MySQL (77)
- Oracle (1,610)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (166)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (69)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (592)
- Oracle安装升级 (97)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (86)
- PostgreSQL (30)
- pdu工具 (6)
- PostgreSQL恢复 (9)
- SQL Server (32)
- SQL Server恢复 (13)
- TimesTen (7)
- 达梦数据库 (3)
- 达梦恢复 (1)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (39)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (22)
-
最近发表
- 2025年的Oracle 8.0.5数据库恢复
- ORA-600 kokiasg1故障分析(obj$中核心字典序列全部被恶意删除)
- ORA-00756 ORA-10567故障数据0丢失恢复
- 数据库文件变成32k故障恢复
- tcp连接过多导致监听TNS-12532 TNS-12560 TNS-00502错误
- 文件系统格式化MySQL数据库恢复
- .sstop勒索加密数据库恢复
- 解决一次硬件恢复之后数据文件0kb的故障恢复case
- Error in invoking target ‘libasmclntsh19.ohso libasmperl19.ohso client_sharedlib’问题处理
- ORA-01171: datafile N going offline due to error advancing checkpoint
- linux环境oracle数据库被文件系统勒索加密为.babyk扩展名溯源
- ORA-600 ksvworkmsgalloc: bad reaper
- ORA-600 krccfl_chunk故障处理
- Oracle Recovery Tools恢复案例总结—202505
- ORA-600 kddummy_blkchk 数据库循环重启
- 记录一次asm disk加入到vg通过恢复直接open库的案例
- CHECKDB 发现了 N 个分配错误和 M 个一致性错误
- 达梦数据库dm.ctl文件异常恢复
- Oracle Recovery Tools修复ORA-00742、ORA-600 ktbair2: illegal inheritance故障
- 可能是 tempdb 空间用尽或某个系统表不一致故障处理
分类目录归档：ORA-xxxxx
因为高版本引起ORA-00600[17059]
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
truncate table强制终止导致ORA-00600[ktspfundo-2]
朋友的金蝶erp系统异常abort,让我帮忙分析原因.
ORA-00600[ktspfundo-2]错误
Fri Jul 27 08:53:33 2012 Errors in file /u01/oracle/admin/finance/udump/finance_ora_7687.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] ORA-01013: user requested cancel of current operation Fri Jul 27 08:53:33 2012 Errors in file /u01/oracle/admin/finance/udump/finance_ora_7687.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] ORA-01013: user requested cancel of current operation Fri Jul 27 08:54:16 2012 Errors in file /u01/oracle/admin/finance/udump/finance_ora_7687.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] ORA-01013: user requested cancel of current operation Fri Jul 27 08:57:12 2012 Errors in file /u01/oracle/admin/finance/bdump/finance_smon_4156.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] Fri Jul 27 08:57:20 2012 ORACLE Instance finance (pid = 15)-Error 600 encountered while recovering transaction (8, 3) on object 34294107. Fri Jul 27 08:57:20 2012 Errors in file /u01/oracle/admin/finance/bdump/finance_smon_4156.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] Fri Jul 27 09:07:14 2012 Errors in file /u01/oracle/admin/finance/bdump/finance_smon_4156.trc: ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], [] Fri Jul 27 09:07:15 2012 Errors in file /u01/oracle/admin/finance/bdump/finance_pmon_4130.trc: ORA-00474: SMON process terminated with error
从这里可以大概看出数据库在进行一个参数,然后用户终止该操作导致,导致ORA-00600[ktspfundo-2]错误,然后出现smon回滚,因为回滚失败从而使得数据块down掉
分析trace文件
*** 2012-07-27 08:53:33.293
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktspfundo-2], [], [], [], [], [], [], []
ORA-01013: user requested cancel of current operation
Current SQL statement for this session:
TRUNCATE TABLE VTC3B8DR2G7J926FWOBK839XOR
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFF41B0EE70 ? 7FFF41B0EED0 ?
7FFF41B0EE10 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFF41B0EE70 ? 7FFF41B0EED0 ?
7FFF41B0EE10 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFF41B0EE70 ? 7FFF41B0EED0 ?
7FFF41B0EE10 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FFF41B0EE70 ? 7FFF41B0EED0 ?
7FFF41B0EE10 ? 000000000 ?
kgeasnmierr()+163 call kgerinv() 0068966E0 ? 2AE87C6E1168 ?
7FFF41B0EED0 ? 7FFF41B0EE10 ?
000000000 ? 000000000 ?
ktspfundo()+3902 call kgeasnmierr() 0068966E0 ? 2AE87C6E1168 ?
7FFF41B0EED0 ? 7FFF41B0EE10 ?
000000010 ? 00689C0C0 ?
kcoubk()+351 call ktspfundo() 7FFF41B10810 ? 2AE80C800CFA ?
4D6EE6014 ? 000000002 ?
000000010 ? 7FFF41B11128 ?
ktundo()+1208 call kcoubk() 7FFF41B111F8 ? 7FFF41B10810 ?
2AE87E384024 ? 000000002 ?
000000002 ? 000000000 ?
ktubko()+499 call ktundo() 000000001 ? 010E5C341 ?
2AE87E384020 ? 000000058 ?
000008430 ? 7657E9990 ?
ktuabt()+810 call ktubko() 7657E9990 ? 7FFF41B1188C ?
000000002 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
ktcrab()+292 call ktuabt() 7657E98F8 ? 000000002 ?
000000002 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
ktccle()+516 call ktcrab() 7657E98F8 ? 000000002 ?
000000002 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
ksepop()+384 call ktccle() 000000006 ? 000000002 ?
000000002 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
kgepop()+123 call ksepop() 0068966E0 ? 000000006 ?
000000002 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
kgesev()+315 call kgepop() 0068966E0 ? 2AE87C6E1168 ?
0000003F5 ? 7FFF41B11648 ?
7FFF41B11570 ? 7FFF41B11870 ?
ksesec0()+186 call kgesev() 0068966E0 ? 2AE87C6E1168 ?
0000003F5 ? 000000000 ?
7FFF41B11B30 ? 7FFF41B11870 ?
ksqcmi()+2322 call ksesec0() 000000000 ? 000000000 ?
000001000 ? 000000000 ?
000000013 ? 000000005 ?
ksqcnv()+496 call ksqcmi() 77E586B88 ? 000000006 ?
00000FFFF ? 00147AE14 ?
7FFF41B126A0 ? 7FFF41B128A8 ?
ksqcov()+44 call ksqcnv() 77E586B88 ? 000000006 ?
000000000 ? 00147AE14 ?
7FFF41B128A8 ? 000000004 ?
kcbo_reuse_obj()+14 call ksqcov() 77E586B68 ? 000000006 ?
09 000000000 ? 00147AE14 ?
7FFF41B128A8 ? 000000004 ?
kcbrbo()+1126 call kcbo_reuse_obj() 7FFF41B12F04 ? 7FFF41B12F0C ?
000000001 ? 00147AE14 ?
7FFF41B128A8 ? 000000004 ?
ktsstrn_segment()+3 call kcbrbo() 7FFF41B12F04 ? 7FFF41B12F0C ?
941 000000001 ? 00147AE14 ?
7FFF41B128A8 ? 000000004 ?
kkbtts_trunc_tbl_se call ktsstrn_segment() 7FFF41B13180 ? 000000000 ?
g()+1018 0020C6444 ? 000000000 ?
7FFF41B14C00 ? 7FFF00000001 ?
kkbtrn()+8156 call kkbtts_trunc_tbl_se 735ACA058 ? 77BC78D18 ?
g() 000000000 ? 000000002 ?
000000000 ? 7FFF41B14C00 ?
opiexe()+15805 call kkbtrn() 735ACA058 ? 000000000 ?
718831208 ? 000000000 ?
000000002 ? 7FFF00000000 ?
opiosq0()+3316 call opiexe() 000000004 ? 000000000 ?
7FFF41B15F48 ? 00000000B ?
000000002 ? 7FFF00000000 ?
kpooprx()+315 call opiosq0() 000000003 ? 00000000E ?
7FFF41B160B8 ? 0000000A4 ?
000000002 ? 7FFF00000000 ?
kpoal8()+799 call kpooprx() 7FFF41B19264 ? 7FFF41B17280 ?
000000029 ? 000000001 ?
000000000 ? 7FFF00000000 ?
opiodr()+984 call kpoal8() 00000005E ? 000000017 ?
7FFF41B19260 ? 000000001 ?
000000001 ? 7FFF00000000 ?
ttcpip()+1012 call opiodr() 00000005E ? 000000017 ?
7FFF41B19260 ? 000000000 ?
0059C09B0 ? 7FFF00000000 ?
opitsk()+1322 call ttcpip() 00689E3B0 ? 7FFF41B17248 ?
7FFF41B19260 ? 000000000 ?
7FFF41B18D58 ? 7FFF41B193C8 ?
opiino()+1026 call opitsk() 000000003 ? 000000000 ?
7FFF41B19260 ? 000000001 ?
000000000 ? 4E58D8C00000001 ?
opiodr()+984 call opiino() 00000003C ? 000000004 ?
7FFF41B1A428 ? 000000000 ?
000000000 ? 4E58D8C00000001 ?
opidrv()+547 call opiodr() 00000003C ? 000000004 ?
7FFF41B1A428 ? 000000000 ?
0059C0460 ? 4E58D8C00000001 ?
sou2o()+114 call opidrv() 00000003C ? 000000004 ?
7FFF41B1A428 ? 000000000 ?
0059C0460 ? 4E58D8C00000001 ?
opimai_real()+163 call sou2o() 7FFF41B1A400 ? 00000003C ?
000000004 ? 7FFF41B1A428 ?
0059C0460 ? 4E58D8C00000001 ?
main()+116 call opimai_real() 000000002 ? 7FFF41B1A490 ?
000000004 ? 7FFF41B1A428 ?
0059C0460 ? 4E58D8C00000001 ?
__libc_start_main() call main() 000000002 ? 7FFF41B1A490 ?
+244 000000004 ? 7FFF41B1A428 ?
0059C0460 ? 4E58D8C00000001 ?
_start()+41 call __libc_start_main() 000723088 ? 000000002 ?
7FFF41B1A5E8 ? 000000000 ?
0059C0460 ? 000000002 ?
--------------------- Binary Stack Dump ---------------------
这里可以得到更加准确的信息,数据库在truncate table的时候,有人异常终止程序,导致数据库出现ORA-00600[ktspfundo-2].查询mos未发现相关bug记录,从这些信息初步判断是因为oracle的bug导致在truncate表的时候异常终止,然后出现该对象上的回滚记录异常(当然truncate本身不需要回滚,但是可能记录一些附带的回滚信息),然后出现对象回滚异常是的数据库down.重启数据库,对象回滚段信息已经自动回滚完成,数据库正常.因为truncate表被异常终止的情况本身不多见,引发该bug更不常见,如果只是偶尔发生一次,建议忽略该错误.当然如果有时间和兴趣,可以提交sr
客户端版本导致ORA-00600[kssadd_stage: null parent]
有客户一台应用不能正常工作,报ORA-00600[kssadd_stage: null parent]错误，重启中间件后工作正常.
alert日志
ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], [] Tue Jul 17 14:57:37 2012 Trace dumping is performing id=[cdmp_20120717145742] Tue Jul 17 14:57:39 2012 Errors in file /oracle/10g/admin/fdjdb/udump/fdjdb2_ora_307720.trc: ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], [] Tue Jul 17 14:57:45 2012 Errors in file /oracle/10g/admin/fdjdb/udump/fdjdb2_ora_357344.trc: ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []
trace文件
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/10g/db
System name: AIX
Node name: ora2
Release: 1
Version: 6
Machine: 00CCFD354C00
Instance name: fdjdb2
Redo thread mounted by this instance: 2
Oracle process number: 89
Unix process pid: 111068, image: oracle@ora2
*** ACTION NAME:() 2012-07-17 15:08:42.043
*** MODULE NAME:(gsrvr.exe) 2012-07-17 15:08:42.043
*** SERVICE NAME:(fdjdb) 2012-07-17 15:08:42.043
*** SESSION ID:(991.44140) 2012-07-17 15:08:42.043
*** 2012-07-17 15:08:42.043
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kssadd_stage: null parent], [], [], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c bl ksedst1 40D1A9663F9E7ABB ?
6ED89E14D59386B5 ?
ksedmp+0290 bl ksedst 104A2CDB0 ?
ksfdmp+0018 bl 03F2735C
kgerinv+00dc bl _ptrgl
kgeasnmierr+004c bl kgerinv 11041D938 ? 700000220FFBFC8 ?
110000770 ? 7000004FDF0C700 ?
FFFFFFFFFFF89C0 ?
kssadd_stage+0080 bl kgeasnmierr 110195490 ? 110450040 ?
104AC46B8 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 7000004F0FA9208 ?
kqreqa+0058 bl kssadd_stage 105670038 ? 104CF7BA0 ?
000000000 ? 000000000 ?
kqrpre1+0850 bl kqreqa 100203514 ? 1101A2B20 ?
kqrpre+001c bl kqrpre1 710000770 ? 000000009 ?
FFFFFFFFFFF9088 ?
28A4202200000000 ?
10012AEE4 ? FFFFFFFFFFF9080 ?
000000000 ? 11022A3E0 ?
opiosq0+009c bl kqrpre 000000000 ? 000000000 ?
000000000 ? 1101A2B20 ?
FFFFFFFFFFF9198 ? 1104B7C60 ?
FFFFFFFFFFF9458 ?
kpooprx+0168 bl opiosq0 4A00000001 ? 000000001 ?
000000000 ? A40000000000FF ?
kpoal8+0400 bl kpooprx FFFFFFFFFFFB964 ?
FFFFFFFFFFFB680 ?
5000000050 ? 100000001 ?
000000000 ? A40000000000A4 ?
000000000 ? 1103A1AD8 ?
opiodr+0ae0 bl _ptrgl
ttcpip+1020 bl _ptrgl
opitsk+1124 bl 01F971E8
opiino+0990 bl opitsk 000000000 ? 000000000 ?
opiodr+0ae0 bl _ptrgl
opidrv+0484 bl 01F96034
sou2o+0090 bl opidrv 3C02D9A29C ? 4A006E298 ?
FFFFFFFFFFFF8A0 ?
opimai_real+01bc bl 01F939B4
main+0098 bl opimai_real 000000000 ? 000000000 ?
__start+0070 bl main 000000000 ? 000000000 ?
--------------------- Binary Stack Dump ---------------------
咨询客户得知访问该数据库的是通过中间件(OCI)+10g Release 1 (10.1) for Windows访问数据库,然后查询MOS[ID 752149.1]发现stack trace
kssadd_stage <- kqreqa <- kqrpre1 <- kqrpre <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- main <- start 和客户端版本和访问环境都和unpublished Bug 4937225相似
处理建议
客户端升级到10.2.0.3或者更高版本