ORA-600 [kcbgcur_9]错误的触发原理是 当 buffer被以某种类型顺序pin住以便防止内部死锁时，发现当前buffer被以错误的类型顺序pinned或者同一class中有重复的buffer； 也可能在更新只读表空间时与ORA-372错误一起发生。
该ORA-600 [kcbgcur_9]错误隶属于内核 buffer cache模块
这个ORA-600 [kcbgcur_9]错误一般有4个argument:
Arg [a] The Database Block Address (DBA)
Arg [b] The buffer class
Arg [c] Block class order mask
Arg [d] Block class checking mask
ORA-600 [kcbgcur_9]错误可能的影响是造成进程失败，但一般不会造成数据块的损坏
ORACLE SUPPORT对遇到该问题的主要建议是 检查所有的系统硬件 磁盘和内存， 以便保证不是底层系统造成了该问题。
一些可能造成ORA-600 [kcbgcur_9]的BUG:
| NB | Bug | Fixed | Description |
| 10061015 | 11.2.0.2.3, 11.2.0.2.BP08, 11.2.0.3, 12.1.0.1 | ORA-600 [ktfbhget:clsviol_kcbgcur_9] can occur on transported in tablespace | |
| 9407198 | 11.2.0.3, 12.1.0.1 | “LOG ERRORS INTO” can cause ORA-600 [kcb***] or hang scenarios | |
| 9133601 | 12.1.0.1 | ORA-600 [kcbgcur_9] from MERGE into an IOT | |
| 8459467 | 10.2.0.5, 11.2.0.1 | ORA-600 [ktfbhget:clsviol_kcbgcur_9] attempting to ONLINE a tablespace | |
| 7644703 | 10.2.0.5, 11.2.0.1 | OERI[kcbgcur_9] on alter tablespace online | |
| 6918892 | 11.2.0.1 | ORA-600 [kcbgcur_9] from DML on sys.aud$ | |
| 4917666 | 10.2.0.3, 11.1.0.6 | OERI[kcbgcur_9] from type constructor | |
| 8778379 | 10.2.0.5 | Fix event 10227 in 10.2 ORA-600[kcbgcur_3] or ORA-600[kcbgcur_9] | |
| 3655948 | 10.1.0.5, 10.2.0.1 | OERI:kcbgcur_9 during disconnect with distributed transaction | |
| 3127116 | 9.2.0.5, 10.1.0.2 | OERI:kcbgcur_9 during rollback of DML in ASSM segment | |
| 2771042 | 9.2.0.6, 10.1.0.2 | OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy | |
| 2747873 | 9.2.0.8, 10.1.0.2 | DBMS_SPACE.UNUSED_SPACE may fail with OERI:kcbgcur_9 | |
| 2722809 | 9.2.0.4, 10.1.0.2 | OERI:kcbgcur_9 on direct load into AUTO space managed segment | |
| 2716406 | 10.1.0.2 | OERI[kcbgcur_9] executing DBMS_SPACE.FREE_BLOCKS procedure on bitmapped segment | |
| 2619895 | 9.2.0.8, 10.1.0.2 | Dump / OERI:kcbgcur_9 using PLSQL in SET clause of MERGE .. UPDATE | |
| 2392885 | 9.2.0.4, 10.1.0.2 | Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2 | |
| 2311214 | 9.0.1.4, 9.2.0.2, 10.1.0.2 | OERI:KCBGCUR_9 possible for SQL against IOT | |
| 1785175 | 9.2.0.2, 10.1.0.2 | OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion | |
| 4124059 | 9.2.0.8 | OERI[kcbget_31] / similar KCB errors in single instance | |
| 2202310 | 9.0.1.4, 9.2.0.1 | OERI:KCBGCUR_9 possible from SMON dropping a rollback segment in locally managed tablespace | |
| 2035267 | 9.0.1.3, 9.2.0.1 | OERI:KCBGCUR_9 possible during TEMP space operations | |
| 1804676 | 8.1.7.3, 9.0.1.3, 9.2.0.1 | OERI:KCBGCUR_9 possible from ONLINE REBUILD INDEX with concurrent DML | |
| 1397075 | 8.1.7.2, 9.0.1.0 | OERI:KCBGCUR_9 from SMON during temp seg cleanup for segment in read only LOCALLY MANAGED TABLESPACE |
如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!
Leave a Reply