Netsoftmate

Tag: GG 12.1.2.1.0 to 12.1.2.1.10

  • 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