Installing Oracle database 12.2.0.1 Patch 26609817
Step 1: Download the Patch from My Oracle Support
Step 2: Unzip the Patch
$ unzip p26609817_122010_Linux-x86-64.zip
Step 3: Stop all service managed by the Oracle Home
$ dbshut $ORACLE_HOME
Step 4: For Backup solution, you may take a copy of the Oracle Home as backup.
$ cp -ra $ORACLE_HOME Backup_Oracle_HOME
Step 5: Apply the patch
$ cd 26609817
$ /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-54-38PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 26609817
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 '26609817' to OH '/u01/app/oracle/product/12.1.0/dbhome_1'
Patching component oracle.oracore.rsf, 12.2.0.1.0…
Patching component oracle.ctx, 12.2.0.1.0…
Patching component oracle.rdbms.deconfig, 12.2.0.1.0
Patching component oracle.rdbms.rsf, 12.2.0.1.0…
Patching component oracle.rdbms.rman, 12.2.0.1.0…
Patching component oracle.rdbms, 12.2.0.1.0…
Mot de passePatching component oracle.rdbms.util, 12.2.0.1.0…
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0…
Patching component oracle.tfa, 12.2.0.1.0…
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0…
Patch 26609817 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2020-03-16_19-54-38PM_1.log
OPatch succeeded.
Step 6: Check the Status of the Patch:
$ /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-56-38PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2020-03-16_19-56-38PM.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 (1) :
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 “DATABASE RELEASE UPDATE: 12.2.0.1.170814 (26609817)” is done for Oracle RAC 12c
Pingback: RAC 12cR2 Cluster Bug: HANG DUE TO HIGH GC INDEX OPERATIONS/ENQ: TX ROW LOCK CONTENTION WAITS: Bug resolved via Patch 28023081 | Wadhah DAOUEHI