Tuesday 3 January 2017

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

    No comments:

    Post a Comment

    Comparing Oracle Database Appliance X8-2 Model Family

    September 2019 Oracle announced Oracle Database Appliance X8-2 (Small, Medium and HA). ODA X8-2 comes with more computing resources com...