Oracle bug ORA-00600 ktecgsc:objdchk_kcbgcur_3 causing the collectors to fail
3 years ago
Originally Published: 2015-10-07
Article Number
000045548
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Jboss with Local database(Database provided by RSA)
RSA Version/Condition: 6.9.1
Platform: Linux
Platform (Other): Server 11
O/S Version: Suse Linux
Product Name:
Product Description:
Issue
Collections start failing due to an internal oracle error ORA-00600 ktecgsc:objdchk_kcbgcur_3
Cause
Bug ORA-600 [ktecgsc:objdchk_kcbgcur_3] : Space management code may use an unnecessary force CR option for a segment header pin which can lead to a block cache object id mismatch in the buffer cache (typically showing as an ORA-600 in kcb* code). This might be due  ORA-600 [ktefctl:clschk_kcbnew_14] problem as well.
Resolution
Engineering has provided patch to
Ensure that the Oracle home on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release (11.2.0.3.0).  Instructions are provided below for each step in the process:
  1. Identify current patch level of your system.
  2. Determine if database patch is needed.
  3. Apply database patch, if needed.
  4. Reverting the database patch

Identify Current Patch Level:

To identify if your database is already patched, run the following command (respective to each patch) as the ‘oracle’ user on the appliance:

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/OPatch/opatch.pl lsinv -bugs_fixed |grep 15974138
For 11.2.0.3, if you have a patched database, you should see output something similar to this:
15974138   15974138  Fri Sep 18 01:52:32 EDT 2015   UNNECESSARY FORCE CR SEGMENT HEADER REQUEST

Note: If any of the results matching then please ignore the respective patch

Determine if Database Patch is Needed

The minimum required patch level requirement to proceed with the current patch is customer Oracle database should be on 11.2.0.3.0

Apply Database Patch

Download the the following file  :
p15974138_112030_Linux-x86-64.zip( Attached to article)
ocm.rsp   (This is response file for the OPatch utility also attached to article)
p6880880_112000_LINUX.zip   (This is latest version of Oracle’s OPatch utility for Linux x86. Contact Support for the file)

Change the Oracle Grid Home permissions.  Login as root server user and run the command:
chmod g+w $ORACLE_GRID_HOME/../grid
Login as the oracle user and run the following commands:
  1. acm stop
  2. acm stoporacle
  3. Copy p6880880_112000_LINUX.zip into /home/oracle directory
  4. Run “unzip p6880880_112000_LINUX.zip”
NOTE:This should produce a directory /home/oracle/OPatch
     5.  Create patches directory under /home/oracle using command “mkdir patches”
     6.  copy ocm.rsp to /home/oracle/patches/ directory
     7.  copy p15974138_112030_Linux-x86-64.zip to /home/oracle/patches/ directory
     8.  cd patches
     9.  unzip p15974138_112030_Linux-x86-64.zip
    10. $ORACLE_HOME/perl/bin/perl /home/oracle/OPatch/opatch.pl napply /home/oracle/patches/ -silent -oh $ORACLE_GRID_HOME -ocmrf /home/oracle/patches/ocm.rsp -id 15974138
NOTE:  This patches the Oracle Grid installed software
    11. $ORACLE_HOME/perl/bin/perl /home/oracle/OPatch/opatch.pl napply /home/oracle/patches/ -silent -oh $ORACLE_HOME -ocmrf /home/oracle/patches/ocm.rsp -id 15974138
NOTE:  This patches the Oracle Home installed software
    12. acm startoracle
     13. acm start

The system is now available. Please login and verify the collection functionality

Reverting the Database Patches

Run the following command(s):
$ORACLE_HOME/perl/bin/perl /home/oracle/OPatch/opatch.pl nrollback /home/oracle/patches/ -silent -oh $ORACLE_HOME -ocmrf /home/oracle/patches/ocm.rsp -id 15974138
NOTE:This revert the patches from Oracle Grid installed software
$ORACLE_HOME/perl/bin/perl /home/oracle/OPatch/opatch.pl nrollback /home/oracle/patches/ -silent -oh $ORACLE_GRID_HOME -ocmrf /home/oracle/patches/ocm.rsp -id 15974138
NOTE:This reverts the patches from Oracle Home installed software


 

Related Articles

Trending Articles

Don't see what you're looking for?