Patching Oracle GoldenGate 12c

For the latest patchset you’ll need access to MOS. At the time of writing the latest patchset is 12.1.2.1.12 and can be downloaded from here: Oracle GoldenGate 12.1.2.1.12 Patch Set Availability (Doc ID 1645495.1).

we need to make sure that no processes are running out of the home that will be patched:

[oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.0 21381983 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150728.2027_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 29 2015 04:52:08
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (ggsrc) 1> stop manager
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (ggsrc) 2>exit
[oracle@host01 ~]$

Unzip the required the OPatch utility from support.

[oracle@host01 ~]$ unzip -d /u01/app/oracle/product/12.1.0/gg_12121/ p6880880_112000_Linux-x86-64.zip
[oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/OPatch/opatch version
OPatch Version: 11.2.0.3.11

OPatch succeeded.

Now we can start the patching

[oracle@host01 ~]$ cd 22927753/
[oracle@host01 ~]$ export PATH=/u01/app/oracle/product/12.1.0/gg_12121/OPatch/:$PATH
[oracle@host01 ~]$ cd 22927753
[oracle@host01 ~]$ opatch apply -oh /u01/app/oracle/product/12.1.0/gg_12121/
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0/gg_12121
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/gg_12121/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/12.1.0/gg_12121/cfgtoollogs/opatch/22927753_Aug_31_2016_07_32_34/apply2016-08-31_07-32-34AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 22927753

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/gg_12121')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '22927753' to OH '/u01/app/oracle/product/12.1.0/gg_12121'

Patching component oracle.oggcore.ora12c, 12.1.2.1.0...

Verifying the update...
Patch 22927753 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0/gg_12121/cfgtoollogs/opatch/22927753_Aug_31_2016_07_32_34/apply2016-08-31_07-32-34AM_1.log

OPatch succeeded.

Now we can check the whether patch apply or not

[oracle@host01 ~]$ export ORACLE_HOME=/u01/app/oracle/product/12.1.0/gg_12121
[oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/OPatch/opatch lsinv

Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/12.1.0/gg_12121
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/gg_12121/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/12.1.0/gg_12121/cfgtoollogs/opatch/opatch2016-08-31_07-39-07AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/gg_12121/cfgtoollogs/opatch/lsinv/lsinventory2016-08-31_07-39-07AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: host1
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle GoldenGate Core 12.1.2.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 22927753 : applied on Mon Aug 31 07:32:58 CEST 2016
Unique Patch ID: 19286493
Created on 30 Jul 2016, 13:43:08 hrs PST8PDT
Bugs fixed:
19241234, 20660883, 21473564, 21180187, 20898978, 19132627, 20643144
18875912, 20543714, 21079205, 20367405, 20803745, 20657667, 19889991
20659379, 20045536, 19987316, 20554464, 19142865, 19681198, 19813884
20347665, 20148126, 20917331, 19048634, 21182116, 19346082, 19920244
19798268, 19602692, 19535319, 19441114, 21110369, 19374174, 20664851
21045025, 20681946, 19903590, 19724915, 21165823, 19327073, 20531064
21226965, 19818362, 20021370, 20724906, 21124385, 21328574, 19264441
18996447, 21090428, 19414121, 19545128, 21121987, 20648352, 19721652
20853556, 21103736, 17866697, 20778054, 20853777, 19244349, 20782113
20092876, 20343181, 20532340, 20951173, 20660006, 19067094, 20577891
19560158, 18958026, 17423191, 19624524, 20641896, 19516537, 20563015
20078949, 21026962, 19681035, 20213167, 19782389, 20679687, 19781984
19594967, 20989581

we can restart the manager and are on the latest release now

[oracle@host01 ~]$ $ORACLE_HOME/ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.12 21381983 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150728.2027_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Jul 29 2015 04:52:08
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (ggsrc) 1> start manager
Manager started.

GGSCI (ggsrc) 2> status manager

Manager is running (IP port ggsrc,7809, Process ID 3879)

Hopefully you like this article, In next article we can configure prerequisite and database user for goldengate