Upgrade Oracle GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10 on Linux

Overview

In this document we will perform Upgrade of oracle GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10

Environment Details

Hostname	Node1 and Node2
Operating system	Linux
Environment	Production
Oracle Home	/u01/app/oracle/product/11.2.0/db
GoldenGate software staging location	/u01/app/oracle/software/OGG12c
GoldenGate Shared Home	/oraggs/app/ggs12c/ggs

Software requirement:

Download the Oracle GoldenGate 12.1.2.1.10 (p21785294_1212110_Linux-x86-64.zip) patch from My Oracle support by entering the following URL into your web browser: http://support.oracle.com

Steps to Upgrade Oracle GoldenGate Software

• Create staging area for GoldenGate software.

$ cd /u01/app/oracle/software/

$ mkdir OGG12c

 Copy downloaded Oracle GoldenGate 12c Base software to Node 1

• Unzip the Goldengate patch from directory OGG12c

$ cd /u01/app/oracle/software/OGG12c

$ unzip p21785294_1212110_Linux-x86-64.zip

• Navigate to Oracle GoldenGate 12c home and validate OraInventory

$ cd /oraggs/app/gg12c

$ cd OPatch

$ ./opatch lsinventory

Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7

Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home       : /oraggs/app/gg12c

Central Inventory : /oraggs/app/oraInventory

from           : /etc/oraInst.loc

OPatch version    : 11.2.0.1.7

OUI version       : 11.2.0.3.0

Log file location : /oraggs/app/gg12c/cfgtoollogs/opatch/opatch2016-01-13_13-21-12PM.log

Lsinventory Output file location : /oraggs/app/gg12c/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_13-21-12PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle GoldenGate Core                                               12.1.2.1.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

OPatch succeeded.

• Verify the Opatch version

$ cd /oraggs/app/gg12c/OPatch

[oracle@Node1 OPatch]$ ./opatch version

Invoking OPatch 11.2.0.1.7

OPatch Version: 11.2.0.1.7

OPatch succeeded.

• Set Oracle Home variable to Oracle GoldenGate 12c software location

$ export ORACLE_HOME=/oraggs/app/gg12c

•  Ensure Oracle GoldenGate Processes are offline.

./ggsci

GGSCI> info all

• Stop Oracle GoldenGate Processes as follows:

./ggsci

GGSCI> stop er *
GGSCI> stop mgr!

• Navigate to GoldenGate patch location and apply the patch

$ cd /oraggs/app/oracle/software/OGG12c/21785294

$ /oraggs/app/gg12c/OPatch/opatch apply

•  Verify the patch is applied to GoldenGate 12c Home

$ cd /oraggs/app/gg12c/OPatch

$ ./opatch lsinventory

Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7

Copyright (c) 2011, Oracle Corporation.  All rights reserved.

Oracle Home       : /oraggs/app/ggs12c/ggs

Central Inventory : /oraggs/app/oraInventory

from           : /etc/oraInst.loc

OPatch version    : 11.2.0.1.7

OUI version       : 11.2.0.3.0

Log file location : /oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/opatch2016-01-13_14-37-10PM.log

Lsinventory Output file location : /oraggs/app/ggs12c/ggs/cfgtoollogs/opatch/lsinv/lsinventory2016-01-13_14-37-10PM.txt

--------------------------------------------------------------------------------

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  21785294     : applied on Mon Nov 23 21:30:51 PST 2015

Unique Patch ID:  19375140

   Created on 3 Sep 2015, 10:27:21 hrs PST8PDT

   Bugs fixed:

     21181052, 19241234, 20660883, 21473564, 20898978, 21180187, 19132627

     20643144, 21131159, 18875912, 20543714, 21079205, 20996660, 20367405

     20803745, 20657667, 19889991, 20659379, 20045536, 19987316, 20554464

     19142865, 19681198, 19813884, 20347665, 20148126, 20917331, 19048634

     21182116, 19920244, 19798268, 19602692, 19535319, 19441114, 21110369

     19374174, 20664851, 21045025, 20681946, 19903590, 19724915, 21165823

     19327073, 20531064, 21226965, 19818362, 20021370, 20724906, 21124385

     21328574, 19264441, 18996447, 21345919, 21329486, 21090428, 19414121

     19545128, 21121987, 20648352, 19721652, 20418503, 21209445, 21246170

     20853556, 20756705, 21103736, 17866697, 16084751, 20778054, 21111031

     20853777, 19244349, 20092876, 20782113, 20343181, 20532340, 20951173

     20660006, 19067094, 19560158, 20577891, 18958026, 17423191, 20641896

     19624524, 19516537, 20563015, 20078949, 21026962, 19681035, 20213167

     19782389, 20679687, 19781984, 19594967, 20878216, 20989581

--------------------------------------------------------------------------------

OPatch succeeded.

• Verify the new Oracle GoldenGate 12c version is 12.1.2.1.10

$ cd /oraggs/app/gg12c

$ ./ggsci –v

$ cd /oraggs/app/ggs12c/ggs

$ ./ggsci –v

Oracle GoldenGate Command Interpreter for Oracle

Version 12.1.2.1.10 21604177 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150902.1337_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Sep  2 2015 20:46:03

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

Conclusion:
In this article we have learnt how to Upgrade Oracle GoldenGate 12c from 12.1.2.1.0 to 12.1.2.1.10