Use the Latest OPatch
First of all, we have to download the latest OPatch utility for GoldenGate. In this case, we downloaded OPatch 11.2.0.3.25 for OUI 11.2.0.3.0.
Stop All OGG Services
Please make sure all OGG services are stopped before applying patch.
GGSCI (ora12c1.example.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED ERPAPP_E 00:00:00 00:00:32
EXTRACT STOPPED ERPAPP_P 00:00:00 00:00:28
GGSCI (ora12c2.example.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
REPLICAT STOPPED ERPAPP_R 00:00:00 00:00:12
Pre-Installation
We should make the home of GoldenGate as our current ORACLE_HOME for later operations.
[oracle@ora12c1 ~]$ export ORACLE_HOME=$OGG_HOME
[oracle@ora12c1 ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@ora12c1 ~]$ which opatch
/u01/app/ogg/OPatch/opatch
Check the version of OPatch.
[oracle@ora12c1 ~]$ opatch version
OPatch Version: 11.2.0.3.25
OPatch succeeded.
List inventory of the current ORACLE_HOME (i.e. the home of GoldenGate) before applying the patch.
[oracle@ora12c1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from : /u01/app/ogg/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2020-09-12_14-40-02PM_1.log
Lsinventory Output file location : /u01/app/ogg/cfgtoollogs/opatch/lsinv/lsinventory2020-09-12_14-40-02PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora12c1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 12.1.2.0.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
Is there any conflict? Let's check.
[oracle@ora12c1 ~]$ cd ~/patches/goldengate/18663806/
[oracle@ora12c1 18663806]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from : /u01/app/ogg/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2020-09-12_14-42-41PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
It seems to be no conflict.
Apply Patch
Now we have more confidence for this patch.
[oracle@ora12c1 18663806]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from : /u01/app/ogg/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2020-09-12_14-44-12PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 18663806
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/ogg')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '18663806' to OH '/u01/app/ogg'
Patching component oracle.oggcore.ora12c, 12.1.2.0.0...
Patch 18663806 successfully applied.
Log file location: /u01/app/ogg/cfgtoollogs/opatch/opatch2020-09-12_14-44-12PM_1.log
OPatch succeeded.
After applying the patch, we can list the inventory again.
[oracle@ora12c1 18663806]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/ogg
Central Inventory : /u01/app/oraInventory
from : /u01/app/ogg/oraInst.loc
OPatch version : 11.2.0.3.25
OUI version : 11.2.0.3.0
Log file location : /u01/app/ogg/cfgtoollogs/opatch/opatch2020-09-12_14-45-09PM_1.log
Lsinventory Output file location : /u01/app/ogg/cfgtoollogs/opatch/lsinv/lsinventory2020-09-12_14-45-09PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: ora12c1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle GoldenGate Core 12.1.2.0.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 18663806 : applied on Thu Sep 12 14:45:02 CST 2020
Unique Patch ID: 17607817
Created on 25 Apr 2014, 10:37:35 hrs PST8PDT
Bugs fixed:
17790908, 18105480, 17911313, 18255804, 18173828, 18188821, 16718963
18329410, 16887800, 17943750, 17663470, 17478991
--------------------------------------------------------------------------------
OPatch succeeded.
Next, you have to apply the same patch at another node.
Start All OGG Services
GGSCI (ora12c1.example.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING ERPAPP_E 00:00:00 00:00:00
EXTRACT RUNNING ERPAPP_P 00:00:00 00:00:03
GGSCI (ora12c2.example.com) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING ERPAPP_R 00:00:00 00:00:02
We have done our job.