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

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

Bookmark the permalink.
Loading Facebook Comments ...

Leave a Reply