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
下载相应的补丁包,打上补丁后问题修复,记录补丁过程如下:
[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