Netsoftmate

Tag: upgrading

  • Oracle Golden Gate Upgrade from 12.1.2.1.0 to 12.1.2.1.7 on Windows Operating System.

    Overview
    This Blog
    contains steps to perform upgrading Oracle GoldenGate from 12.1.2.1.0 to
    12.1.2.1.7. This chapter contains minimal upgrade that deploys only the updated
    core functionality, it is best practice to perform a minimal upgrade first, so
    that you can trouble shoot more easily in the event that any problems arise.
    Environment details
    Operating system
    Windows server 2012 R2
    Environment
    production
    Oracle Home
    D:oracle11204product11.2.0dbhome_1
    Golden Gate stage
    D:oraclegg_stage
    Golden Gate Home
    D:oraclegg_homeproduct12.1.2.1ggfor11
    OGG Source version
    12.1.2.1.0
    OGG Target Version
    12.1.2.1.7
    Steps to perform Oracle Golden Gate
    upgrade.

    1.  
    Download
    patch p21078123_121217_MSWIN-x86-64 and unzip it.
    After unzip it creates folder 21078123
    2.  
    Login
    to server and Check Optach version.
    D:>cd
    %oracle_home%OPatch

    D:oracle11204product11.2.0dbhome_1OPatch>

    D:oracle11204product11.2.0dbhome_1OPatch>opatch
    version

    OPatch Version:
    11.2.0.3.4

    OPatch succeeded.

    D:oracle11204product11.2.0dbhome_1OPatch>

     

     3.      Set
    the ORACLE_HOME environment variable to the Oracle GoldenGate installation
    directory, which is referred to as ORACLE_HOME    .
    D:>echo
    %oracle_home%
    D:oracle11204product11.2.0dbhome_1
    D:>set
    oracle_home=D:oraclegg_homeproduct12.1.2.1oggfor11
    D:>echo
    %oracle_home%
    D:oraclegg_homeproduct12.1.2.1oggfor11
     
    4. Set
    the PATH environment variable to include the location of the unzip executable.
    D:>echo %path%
    D:oracle11204product11.2.0dbhome_1bin;C:Windowssystem32;C:Windows;C:WindowsSystem32System32WindowsPowerShellv1.0
    D:>set
    path=%path%:D:oracle11204product11.2.0dbhome_1OPatch
    D:>echo %path%
    D:oracle11204product11.2.0dbhome_1bin;C:Windowssystem32;C:Windows;C:WindowsSystem32System32WindowsPowerShellv1.0:D:oracle11204product11.2.0dbhome_1OPatch
    D:>

    5.      Verify
    the Oracle Inventory, which OPatch accesses to install the patches. To verify
    the inventory, run the following command.
    D:>cd
    D:oracle11204product11.2.0dbhome_1OPatch
    D:oracle11204product11.2.0dbhome_1OPatch>
    D:oracle11204product11.2.0dbhome_1OPatch>opatch
    lsinventory

    6.      Go
    to staging directory where you unzip then got patch number directory and
    execute opatch apply.
    cd
    D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
    D:>cd
    D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
    D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123>D:oracle11204product11.2.0dbhome_1OPatchopatch
    apply

     
    7.     
    Verify the version.
    goto gg_home
    directory and type ggsci.exe
    D:>cd
    oraclegg_homeproduct12.1.2.1oggfor11
    D:oraclegg_homeproduct12.1.2.1oggfor11>ggsci

    Conclusion

    In this Blog we have performed Oracle Golden Gate upgradation
    from 12.1.2.1.0 to 12.1.2.1.7 on Windows operating system. We have seen
    upgrading Oracle Golden Gate Software on Windows is very simple and straight
    forward using OPatch Utility.
    About Author



    Name: Mirza Hidayathullah Baig
    Designation: Senior Database Engineer
    Organization: NetSoftMate IT Solutions.