Netsoftmate

Tag: Upgrade Oracle GoldenGate 11g to 12c

  • Upgrade Oracle GoldenGate 11g to 12c

    Overview:
    In this document we will Upgrade
    Oracle GoldenGate 11g to 12c

    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 11g Shared Home
    /oraggs/app/ggs
    GoldenGate 12c Shared Home
    /oraggs/app/ggs12c/ggs



    Configure Goldengate
    12c:

    • Install Oracle GoldenGate 12c software without creating and start manager process in a new home. Look at the steps for installing Oracle GoldenGate 12c at:

    http://netsoftmate.blogspot.in/2017/01/installing-oracle-goldengate-12c-base.html

    • After installing oracle GoldenGate now
      the time to upgrade the existing 11g to 12c GoldenGate.

    Create sub dirs.


    cd /oraggs/app/gg12c
    GGSCI>create subdirs
    Parameter files                /oraggs/app/gg12c/dirprm
    Report files                   /oraggs/app/gg12c/dirrpt
    Checkpoint files               /oraggs/app/gg12c/dirchk
    Process status files           /oraggs/app/gg12c/dirpcs
    SQL script files               /oraggs/app/gg12c/dirsql
    Database definitions files     /oraggs/app/gg12c/dirdef
    Extract data files             /oraggs/app/gg12c/dirdat
    Temporary files                /oraggs/app/gg12c/dirtmp
    Stdout files                   /oraggs/app/gg12c/dirout

    Create
    softlink


    cd /oraggs

    ln -s /oraggs/dirtmp /oraggs/app/gg12c
    ln -s /oraggs/dirsql /oraggs/app/gg12c
    ln -s /oraggs/dirdef /oraggs/app/gg12c
    ln -s /oraggs/dirdat /oraggs/app/gg12c
    ln -s /oraggs/dirout /oraggs/app/gg12c

    Upgrade Oracle GoldenGate 11g to 12c
    • Take backup of existing GlodenGate 11g
      HOME.

    $ cd /oraggs/app

    $ cp -pR gss ggs_bkp
    • Navigate to GoldenGate 11g home and stop
      the GoldenGate processes

    $ cd /oraggs/app/ggs

    $ ./ggsci
    GGSCI> send extract <name>,
    logend
    GGSCI> info extract <name>
    GGSCI > stop er *
    • Now, stop the Manager process

    $ cd /oraggs/app/ggs

    $ ./ggsci
    GGSCI> stop MGR!
    GGSCI> info all
    • Copy the GoldenGate dir* from GoldenGate
      11g home (/oraggs/app/ggs) to GoldenGate 12c home       (/oraggs/app/ggs12/ggs)

    $ cd /oraggs/app/ggs

    $ ls -l dir*
    $ cp -pR dir* /oraggs/app/ggs12c/ggs/
    • Verify the directories are copied
      successfully to GoldenGate 12c home

    $ cd /oraggs/app/ggs12c/ggs

    $ ls -l dir*
    • Start GoldenGate process from Oracle
      GoldenGate 12c home

    $ cd /oraggs/app/ggs12c/ggs

    $ ./ggsci
    GGSCI> info all
    GGSCI> start mgr
    GGSCI> info all
    GGSCI> start er *
    GGSCI> info all
    ln -s /oraggs/dirrpt /oraggs/app/gg12c
    ln -s /oraggs/dirpcs /oraggs/app/gg12c
    ln -s /oraggs/dirchk /oraggs/app/gg12c
    ln –s /oraggs/dirprm /oraggs/app/gg12c
    • Check the goldengate process status ,
      and that should be visible as Abended

    cd /oraggs/app/gg12c

    ./ggsci
    GGSCI> info all

    Conclusion
    In this article we have learnt how to Upgrade
    Oracle GoldenGate 11g to 12c