数据库中执行某个查询会抛出ORA-00600的错误异常

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

查看相关的trace文件

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 p10260808_112020_Linux-x86-64.zip
?Archive:? p10260808_112020_Linux-x86-64.zip
? ? creating: 10260808/
? ? creating: 10260808/files/
? ? creating: 10260808/files/lib/
? ? creating: 10260808/files/lib/libserver11.a/
? inflating: 10260808/files/lib/libserver11.a/kcbz.o?
? ? creating: 10260808/etc/
? ? creating: 10260808/etc/config/
? inflating: 10260808/etc/config/inventory.xml?
? inflating: 10260808/etc/config/actions.xml?
? inflating: 10260808/etc/config/deploy.xml?
? ? creating: 10260808/etc/xml/
? inflating: 10260808/etc/xml/GenericActions.xml?
? inflating: 10260808/etc/xml/ShiphomeDirectoryStructure.xml?
? inflating: 10260808/README.txt? ?
? ? creating: 10260808/online/
? ? creating: 10260808/online/files/
? ? creating: 10260808/online/files/hpatch/
? inflating: 10260808/online/files/hpatch/bug10260808.pch?
? ? creating: 10260808/online/etc/
? ? creating: 10260808/online/etc/config/
? inflating: 10260808/online/etc/config/inventory.xml?
? inflating: 10260808/online/etc/config/actions.xml?
? inflating: 10260808/online/etc/config/deploy.xml?
? ? creating: 10260808/online/etc/xml/