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