Oracle bug internal error code,ORA-600 [ktecgetsh-inc], [1], [], [], [], [], [], [], [], [], [], [] causing the collectors to fail
2 years ago
Originally Published: 2015-10-19
Article Number
000050492
Applies To
RSA Product Set: Via Lifecycle and Governance( 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
Issue
Collections start failing due to an internal oracle error ORA-600 [ktecgetsh-inc]
Cause
Bug ORA-600 [ktecgetsh-inc]: This bug is only relevant when using Partitioned Tables ALTER TABLE SHRINK LOB on a partitioned table may fail with in ORA-600[ktecgetsh-inc] if there is concurrent DML.
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 13997574
For 11.2.0.3, if you have a patched database, you should see output something similar to this:
13997574   13997574  Fri Sep 18 02:40:05 EDT 2015   ORA-600 [KTECGETSH-INC]

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  :
p13997574_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 p13997574_112030_Linux-x86-64.zip to /home/oracle/patches/ directory
     8.  cd patches
     9.  unzip p13997574_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 13997574
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 13997574
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 13997574
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 13997574
NOTE:This reverts the patches from Oracle Home installed software

 

Related Articles

Trending Articles

Don't see what you're looking for?