联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
检查数据库发现ORA-00600[KSSADP1]错误
Thu Apr 19 21:16:45 2012 Errors in file /oracle9/app/admin/crm/udump/crm1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], [] Thu Apr 19 21:16:45 2012 Errors in file /oracle9/app/admin/crm/udump/crm1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], [] Thu Apr 19 21:16:45 2012 Trace dumping is performing id=[cdmp_20120419211645] Thu Apr 19 21:16:46 2012 Errors in file /oracle9/app/admin/crm/udump/crm1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], [] Thu Apr 19 21:16:47 2012 Errors in file /oracle9/app/admin/crm/udump/crm1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], []
分析crm1_ora_442896.trc信息
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
ORACLE_HOME = /oracle9/app/product/9.2.0
System name: AIX
Node name: zwq_crm1
Release: 3
Version: 5
Machine: 00C420B44C00
Instance name: crm1
Redo thread mounted by this instance: 1
Oracle process number: 2354
Unix process pid: 442896, image: oracle@zwq_crm1 (TNS V1-V3)
*** SESSION ID:(927.39278) 2012-04-19 21:16:45.317
*** 2012-04-19 21:16:45.317
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148 bl ksedst 1029746FC ?
ksfdmp+0018 bl 01FD4014
kgerinv+00e8 bl _ptrgl
kgesinv+0020 bl kgerinv 9001000A02B56F8 ?
9001000A02B9450 ?
FFFFFFFFFFF8430 ? 000000458 ?
900000000CBAFA4 ?
ksesin+005c bl kgesinv FFFFFFFFFFF88E0 ? 1101FAF78 ?
900000000C0ECC0 ? 000010000 ?
000000002 ?
kssadpm_stage+00c4 bl ksesin 102973C84 ? 000000000 ?
00000001E ? 000000000 ?
000000069 ? 00000000C ?
000000000 ? 000000000 ?
ksqgel+0138 bl kssadpm_stage 000000000 ? 000000000 ?
000000000 ? 000000000 ?
kcftis+003c bl ksqgel 000000000 ? 4029C61E0 ?
000000002 ? 0FFFFC16C ?
102A7977C ? 000000000 ?
000000003 ? 002A36408 ?
kcfhis+001c bl kcftis
krbbcc+0238 bl kcfhis 11043B590 ?
krbpgc+001c bl krbbcc
ksmupg+0074 bl _ptrgl
ksuded+00b8 bl ksmupg 102924988 ? 000000020 ?
ksupucg+10ec bl ksuded 700000C376F5740 ? 000000000 ?
000000000 ?
opiodr+0474 bl ksupucg 100000001 ?
ttcpip+0cc4 bl _ptrgl
opitsk+0d60 bl ttcpip 11000CF90 ?
442442216B736800 ?
FFFFFFFFFFFBF00 ? 1102E04BC ?
1102D7D20 ? 0000006A0 ?
1102D83C0 ? 0000006A0 ?
opiino+0758 bl opitsk 000000000 ? 000000000 ?
opiodr+08cc bl _ptrgl
opidrv+032c bl opiodr 3C00000018 ? 4101FAF78 ?
FFFFFFFFFFFF840 ? 0A000F350 ?
sou2o+0028 bl opidrv 3C0C000000 ? 4A00E8B50 ?
FFFFFFFFFFFF840 ?
main+0138 bl 01FD3A28
__start+0098 bl main 000000000 ? 000000000 ?
--------------------- Binary Stack Dump ---------------------
Cursor Dump:
----------------------------------------
Cursor 1 (110360418): CURROW curiob: 110369b78
curflg: 46 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: select nvl(max(cpmid),0) from x$kcccp where cpsta = 2
child pin: 0, child lock: 700000d9b9c5bb8, parent lock: 700000d088e0fa0
xscflg: 1100024, parent handle: 70000031d588d88, xscfl2: 4040401
bhp size: 160/600
----------------------------------------
Cursor 2 (110360468): CURBOUND curiob: 1103656f0
curflg: c7 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: SELECT SUBSTR(VERSION,1,INSTR(VERSION,'.') - 1 ) FROM V$INSTANCE
child pin: 0, child lock: 700000d21e60930, parent lock: 700000327837ce0
xscflg: 141024, parent handle: 700000304e2f020, xscfl2: 4000401
bhp size: 160/600
----------------------------------------
Cursor 3 (1103604b8): CURBOUND curiob: 1103b6aa8
curflg: c7 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: SELECT SUBSTR(VERSION,1 + INSTR(VERSION,'.',1,1) ,INSTR(VERSION,'.',1,2) -
INSTR(VERSION,'.',1,1) - 1 ) FROM V$INSTANCE
child pin: 0, child lock: 700000d5e382ee8, parent lock: 700000c93581d40
xscflg: 141024, parent handle: 700000d73daa1c0, xscfl2: 4000401
bhp size: 160/600
----------------------------------------
Cursor 4 (110360508): CURBOUND curiob: 1103b66b8
curflg: c7 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: SELECT SUBSTR(VERSION,1 + INSTR(VERSION,'.',1,2) ,INSTR(VERSION,'.',1,3) -
INSTR(VERSION,'.',1,2) - 1 ) FROM V$INSTANCE
child pin: 0, child lock: 700000d16de7978, parent lock: 700000c44059d30
xscflg: 141024, parent handle: 700000259c4a700, xscfl2: 4000401
bhp size: 160/600
----------------------------------------
Cursor 5 (110360558): CURBOUND curiob: 1103b3868
curflg: 46 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: SELECT SYSDATE FROM SYS.DUAL
child pin: 0, child lock: 700000d589cea48, parent lock: 70000026b311fb0
xscflg: 100024, parent handle: 700000d2eaee328, xscfl2: 4600409
bhp size: 280/632
----------------------------------------
Cursor 6 (1103605a8): CURBOUND curiob: 1103b3408
curflg: 46 curpar: 0 curusr: 0 curses 700000c376f5740
cursor name: SELECT TO_CHAR(SYSDATE,'YYYY','NLS_CALENDAR=Gregorian'),TO_CHAR(SYSDATE,'MM','NLS_CALENDAR=Gregorian'),
TO_CHAR(SYSDATE,'DD','NLS_CALENDAR=Gregorian') FROM X$DUAL
child pin: 0, child lock: 70000033f1753c8, parent lock: 700000db8c6dd18
xscflg: 100024, parent handle: 700000cbc6ad8b0, xscfl2: 4600409
bhp size: 160/600
End of cursor dump
ksedmp: no current context area
----- Dump of the Fixed PGA -----
找到相关文档Note:262996.1,经过分析,产生错误的原因是由在本版本的数据库中SGA管理中存在的漏洞造成,但此错误没有对数据库的数据造成损坏及性能影响.
处理建议
1．当前版本ORACLE已经不再提供补丁支持,建议升级到高版本解决(有sr中介绍10.2中解决);
2．由于此报错并没有对数据库的数据及性能造成损坏及影响,可以忽此错误。