标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 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)
- 操作系统 (102)
- 数据库 (1,678)
- DB2 (22)
- MySQL (73)
- Oracle (1,540)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (67)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (563)
- Oracle安装升级 (92)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (79)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- .wstop扩展名勒索数据库恢复
- Oracle Recovery Tools工具一键解决ORA-00376 ORA-01110故障(文件offline)
- OGG-02771 Input trail file format RELEASE 19.1 is different from previous trail file form at RELEASE 11.2.
- OGG-02246 Source redo compatibility level 19.0.0 requires trail FORMAT 12.2 or higher
- GoldenGate 19安装和打patch
- dd破坏asm磁盘头恢复
- 删除asmlib磁盘导致磁盘组故障恢复
- Kylin Linux 安装19c
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁(RUs+OJVM)
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
标签归档:ORA-600[KSSADP1]
ORA-00600[KSSADP1]
检查数据库发现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.由于此报错并没有对数据库的数据及性能造成损坏及影响,可以忽此错误。