标签云
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,666)
- DB2 (22)
- MySQL (73)
- Oracle (1,528)
- Data Guard (51)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (559)
- Oracle安装升级 (90)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (77)
- 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)
-
最近发表
- 清空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-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
- 如何修改集群的公网信息(包括 VIP) (Doc ID 1674442.1)
- 如何在 oracle 集群环境下修改私网信息 (Doc ID 2103317.1)
- ORA-600 [kcvfdb_pdb_set_clean_scn: cleanckpt] 相关bug
- ORA-600 krhpfh_03-1210故障处理
标签归档: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.由于此报错并没有对数据库的数据及性能造成损坏及影响,可以忽此错误。