RAC 12cR2 Cluster Bug: HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAITS: Bug resolved via Patch 28023081

Installing the patch 28023081 to resolve the Bug In Oracle database RAC 12.2.0.1 : HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAITS, and as prerequisite we should install the patch 26609817.

Step 1: Install the Patch 26609817

Patch 26609817: DATABASE RELEASE UPDATE 12.2.0.1.170814 (RAC)

Step 2: Download the patch from My Oracle Support

Step 3: Make a backup of your Oracle Home:

$ cp -ar $ORACLE_HOME Backup_Oracle_HOME

Step 4: Unzip the Patch

$ unzip p28023081_12201170814DBRU_Linux-x86-64.zip

Step 5: Stop all Oracle Home Services

$ dbshut $ORACLE_HOME

Step 6: Apply the patch 28023081

$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch apply
 Oracle Interim Patch Installer version 12.2.0.1.6
 Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
 Central Inventory : /u01/app/oraInventory
    from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
 OPatch version    : 12.2.0.1.6
 OUI version       : 12.2.0.1.4
 Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-03-16_19-57-07PM_1.log
Verifying environment and performing prerequisite checks…
 OPatch continues with these patches:   28023081  
Do you want to proceed? [y|n]
 y
 User Responded with: Y
 All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
 (Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_1')
Is the local system ready for patching? [y|n]
 y
 User Responded with: Y
 Backing up files…
 Applying interim patch '28023081' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.rdbms, 12.2.0.1.0…
 Patch 28023081 successfully applied.
 Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-03-16_19-57-07PM_1.log
OPatch succeeded.

Step 6: Check the Patch installation:

$ /u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory
 Oracle Interim Patch Installer version 12.2.0.1.6
 Copyright (c) 2020, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
 Central Inventory : /u01/app/oraInventory
    from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
 OPatch version    : 12.2.0.1.6
 OUI version       : 12.2.0.1.4
 Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-03-16_19-58-41PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-16_19-58-41PM.txt
Local Machine Information::
 Hostname: rac02.oranux.com.tn
 ARU platform id: 226
 ARU platform description:: Linux x86-64
Installed Top-level Products (1): 
Oracle Database 12c                                                  12.2.0.1.0
 There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch  28023081     : applied on Mon Mar 16 19:57:23 GMT+01:00 2020
 Unique Patch ID:  22213259
    Created on 27 May 2018, 11:05:41 hrs PST8PDT
    Bugs fixed:
      28023081
    This patch overlays patches:
      26609817
    This patch needs patches:
      26609817
    as prerequisites
Patch  26609817     : applied on Mon Mar 16 19:55:12 GMT+01:00 2020
 Unique Patch ID:  21483023
 Patch description:  "DATABASE RELEASE UPDATE: 12.2.0.1.170814 (26609817)"
    Created on 10 Aug 2017, 23:23:26 hrs PST8PDT
    Bugs fixed:
      23026585, 24336249, 24929210, 24942749, 25036474, 25110233, 25410877
      25417050, 25427662, 25459958, 25547901, 25569149, 25600342, 25600421
      25606091, 25655390, 25662088, 24385983, 24923215, 25099758, 25429959
      25662101, 25728085, 25823754, 22594071, 23665623, 23749454, 24326846
      24334708, 24560906, 24573817, 24578797, 24609996, 24624166, 24668398
      24674955, 24744686, 24811725, 24827228, 24831514, 24908321, 24976007
      25184555, 25210499, 25211628, 25223839, 25262869, 25316758, 25337332
      25455795, 25457409, 25539063, 25546608, 25612095, 25643931, 25410017
      22729345, 24485174, 24509056, 24714096, 25329664, 25410180, 25607726
      25957038, 25973152, 26024732, 24376878, 24589590, 24676172, 23548817
      24796092, 24907917, 25044977, 25736747, 25766822, 25856821, 25051628
      24534401, 24835919, 25050160, 25395696, 25430120, 25616359, 25715167
      25967985, 26546754, 26546664, 26544823, 26575788

OPatch succeeded.

Conclusion:

The Patch 28023081 fix the bug Oracle Database 12.2.0.1. for RAC: HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAIT