How to Patch Oracle GoldenGate 12c

  • by

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.

Leave a Reply

Your email address will not be published. Required fields are marked *