An example of ORA-00600 troubleshooting

An example of ORA-00600 troubleshooting

Executing a query in the database throws a ORA-00600 error exception

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

View related trace files

DDE: Problem Key 'ora 600 [kcbzibmlt_lobds_1] 'was flood controlled (0x4) (incident: 309092)
ORA-00600: Internal error code, parameter: [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]

It seems that there is a problem with the library cache pin. After flush buffer_cache and shared_pool, there is no result
Later, the netizen badly went to the official website to help find out the following bug:

Download the patch, fix the problem after the patch is installed, and record the patch process as follows:

[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
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

[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/

[Oracle @ 17-oraba-dg2 Oracle_Opatch] $ mv OPatch $ ORACLE_HOME/
[Oracle @ 17-oraba-dg2 Oracle_Opatch] $ cd 10260808/
[Oracle @ 17-oraba-dg2 10260808] $ ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home:/u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory:/u01/app/oraInventory
From:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst. loc
OPatch version: 11.2.0.3.0
OUI version: 11.2.0.2.0
Log file location:/u01/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/opatch2015-10-21_13-13-53PM_1.log

Lsinventory Output file location:/u01/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/lsinv/lsinventory2015-10-21_13-13-53PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1 ):

Oracle Database 11g 11.2.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.

[Oracle @ 17-oraba-dg2 10260808] $ ORACLE_HOME/OPatch/opatch apply online-connectstring yoursid: system: yoursystempassword:
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory:/u01/app/oraInventory
From:/u01/app/oracle/product/11.2.0/dbhome_1/oraInst. loc
OPatch version: 11.2.0.3.0
OUI version: 11.2.0.2.0
Log file location:/u01/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/10260808_Oct_21_2015_13_15_36/apply2015-10-21_13-15-36PM_1.log
The patch shoshould be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '000000' to oh'/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and padding Ming prerequisite checks...
All checks passed.
Provide your email address to be informed of security issues, install and
Initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y] es, [N] o) [N]: y
Backing up files...

Patching component oracle. rdbms, 11.2.0.2.0...
Installing and enabling the online patch 'bug10260808. pch', on database 'fogdg2 '.
Verifying the update...
Patch 10260808 successfully applied
Log file location:/u01/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/10260808_Oct_21_2015_13_15_36/apply2015-10-21_13-15-36PM_1.log
OPatch succeeded.

[Oracle @ fograc-dg 10260808] $/opt/oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home:/opt/oracle/app/oracle/product/11.2.0/dbhome_1
Central Inventory:/opt/oracle/app/oraInventory
From:/opt/oracle/app/oracle/product/11.2.0/dbhome_1/oraInst. loc
OPatch version: 11.2.0.3.0
OUI version: 11.2.0.2.0
Log file location:/opt/oracle/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/opatch2015-10-21_13-33-30PM_1.log
Lsinventory Output file location:/opt/oracle/app/oracle/product/11.2.0/dbhome_1/export toollogs/opatch/lsinv/lsinventory2015-10-21_13-33-30PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1 ):

Oracle Database 11g 11.2.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1 ):
Patch (online) 10260808: applied on Wed Oct 21 13:08:21 CST 2015
Unique Patch ID: 13555810
Created on 15 Mar 2011, 16:40:38 hrs PST8PDT
Bugs fixed:
10260808
--------------------------------------------------------------------------------
OPatch succeeded.