00600 错误解决一例

DDE: Problem Key 'ORA 600 [kcbzibmlt_lobds_1]' was flood controlled (0x4) (incident: 309092)
 ORA-00600: 内部错误代码, 参数: [kcbzibmlt_lobds_1], [], [], [], [], [], [], [], [], [], [], []
 ds flg=0x00100001, flg2=0x00000800
 BH (0x7ef79138) file#: 13 rdba: 0x0343ee36 (13/257590) class: 1 ba: 0x7e1ce000
  set: 23 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,0
  dbwrid: 0 obj: 191590 objn: 191590 tsn: 10 afn: 13 hint: f
  hash: [0x1981bc910,0x1981bc910] lru: [0xb7fc5940,0x83fa47a0]
  ckptq: [NULL] fileq: [NULL] objq: [0xb7fc5968,0x189122f88] objaq: [0xb7fc5978,0x189122f78]
  use: [0x199a1a4d8,0x199a1a4d8] wait: [NULL]
  st: READING md: EXCL tch: 0
  flags: only_sequential_access
  cr pin refcnt: 0 sh pin refcnt: 0
  Using State Objects
    ----------------------------------------
    SO: 0x199a1a458, type: 38, owner: 0x18910ee98, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
      proc=0x19fb51f28, name=buffer handle, file=kcb2.h LINE:2629, pg=0
    (buffer) (CR) PR: 0x19fb51f28 FLG: 0x0
    class bit: 0x0
      cr[0]:
      sh[0]:
    kcbbfbp: [BH: 0x7ef79138, LINK: 0x199a1a4d8]
    type: normal pin
    multiblock read ptr: 0x19ede49a0, count: 7
    kcbbfmbr[0]: [BH: 0x70f7cc98, LINK: 0x19ede49b0]
    type: normal pin
    kcbbfmbr[1]: [BH: 0x82fdce68, LINK: 0x19ede4a00]
    type: normal pin
    kcbbfmbr[2]: [BH: 0xa6fa7d58, LINK: 0x19ede4a50]
    type: normal pin
    kcbbfmbr[3]: [BH: 0xcbf800d8, LINK: 0x19ede4aa0]
    type: normal pin
    kcbbfmbr[4]: [BH: 0x7dfdf0d8, LINK: 0x19ede4af0]
    type: normal pin
    kcbbfmbr[5]: [BH: 0x8cfde168, LINK: 0x19ede4b40]
    type: normal pin
    kcbbfmbr[6]: [BH: 0xa7fdaac8, LINK: 0x19ede4b90]

貌似是library cache的pin有问题,flush buffer_cache和shared_pool后无果
 后来网友badly 去官方帮忙查出如下bug

00600 错误解决一例

下载相应的补丁包,打上补丁后问题修复,记录补丁过程如下:

[Oracle@17-oraba-dg2 Oracle_Opatch]$ unzip p6880880_112000_Linux-x86-64.zip
 Archive:  p6880880_112000_Linux-x86-64.zip
    creating: OPatch/
    creating: OPatch/oplan/
  inflating: OPatch/oplan/README.html 
  inflating: OPatch/oplan/README.txt 
    creating: OPatch/oplan/jlib/
  inflating: OPatch/oplan/jlib/oplan.jar 
  inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar 
  inflating: OPatch/oplan/jlib/automation.jar 
  inflating: OPatch/oplan/jlib/OsysModel.jar 
  inflating: OPatch/oplan/jlib/EMrepoDrivers.jar 
    creating: OPatch/oplan/jlib/apache-commons/
  inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar 
    creating: OPatch/oplan/jlib/jaxb/
  inflating: OPatch/oplan/jlib/jaxb/activation.jar 
  inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar 
  inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar 
  inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar 
  inflating: OPatch/oplan/jlib/osysmodel-utils.jar 
  inflating: OPatch/oplan/jlib/CRSProductDriver.jar 
  inflating: OPatch/oplan/oplan     
    creating: OPatch/docs/
  inflating: OPatch/docs/FAQ       
  inflating: OPatch/docs/Users_Guide.txt 
  inflating: OPatch/docs/Prereq_Users_Guide.txt 
    creating: OPatch/jlib/
  inflating: OPatch/jlib/opatch.jar 
  inflating: OPatch/jlib/opatchsdk.jar 
  inflating: OPatch/jlib/oracle.opatch.classpath.jar 
  inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar 
  inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar 
    creating: OPatch/opatchprereqs/
    creating: OPatch/opatchprereqs/opatch/
  inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml 
  inflating: OPatch/opatchprereqs/opatch/rulemap.xml 
  inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml 
    creating: OPatch/opatchprereqs/oui/
  inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml 
  inflating: OPatch/opatchprereqs/prerequisite.properties 
  inflating: OPatch/opatch         
  inflating: OPatch/opatch.bat     
  inflating: OPatch/opatch.pl       
  inflating: OPatch/opatch.ini     
  inflating: OPatch/opatchdiag     
  inflating: OPatch/opatchdiag.bat 
  inflating: OPatch/emdpatch.pl     
  inflating: OPatch/README.txt     

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/40ff4461944bf4aaff075ed77d85ae5f.html