IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    ORA-00600: internal error code, arguments:[kcbgcur_9] 错误解析

    PDSERVICE发表于 2016-06-01 06:44:00
    love 0

    如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

    诗檀软件专业数据库修复团队

    服务热线 : 400-690-3643 备用电话: 13764045638 邮箱:service@parnassusdata.com

     

    ORA-00600: internal error code, arguments:[kcbgcur_9]

     

     

    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专业数据库修复团队成员帮您恢复!



沪ICP备19023445号-2号
友情链接