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.
$ cp -pR gss ggs_bkp
- Navigate to GoldenGate 11g home and stop the GoldenGate processes
$ ./ggsci
GGSCI> send extract <name>,
logend
GGSCI> info extract <name>
GGSCI > stop er *
- Now, stop the Manager process
$ ./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)
$ ls -l dir*
$ cp -pR dir* /oraggs/app/ggs12c/ggs/
- Verify the directories are copied successfully to GoldenGate 12c home
$ ls -l dir*
- Start GoldenGate process from Oracle GoldenGate 12c home
$ ./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
./ggsci
GGSCI> info all
Conclusion
In this article we have learnt how to Upgrade
Oracle GoldenGate 11g to 12c
2