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:\oracle\11204\product\11.2.0\dbhome_1
Golden Gate stage	D:\oracle\gg_stage
Golden Gate Home	D:\oracle\gg_home\product\12.1.2.1\ggfor11
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:\oracle\11204\product\11.2.0\dbhome_1\OPatch>

D:\oracle\11204\product\11.2.0\dbhome_1\OPatch>opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

D:\oracle\11204\product\11.2.0\dbhome_1\OPatch>

 

 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:\oracle\11204\product\11.2.0\dbhome_1

D:\>set oracle_home=D:\oracle\gg_home\product\12.1.2.1\oggfor11

D:\>echo %oracle_home%

D:\oracle\gg_home\product\12.1.2.1\oggfor11

  4. Set the PATH environment variable to include the location of the unzip executable.

D:\>echo %path%

D:\oracle\11204\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\\System32\WindowsPowerShell\v1.0\

D:\>set path=%path%:D:\oracle\11204\product\11.2.0\dbhome_1\OPatch

D:\>echo %path%

D:\oracle\11204\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\\System32\WindowsPowerShell\v1.0\:D:\oracle\11204\product\11.2.0\dbhome_1\OPatch

D:\>

5.      Verify the Oracle Inventory, which OPatch accesses to install the patches. To verify the inventory, run the following command.

D:\>cd D:\oracle\11204\product\11.2.0\dbhome_1\OPatch

D:\oracle\11204\product\11.2.0\dbhome_1\OPatch>

D:\oracle\11204\product\11.2.0\dbhome_1\OPatch>opatch lsinventory

6.      Go to staging directory where you unzip then got patch number directory and execute opatch apply.

cd D:\oracle\gg_stage\p21078123_121217_MSWIN-x86-64\21078123

D:\>cd D:\oracle\gg_stage\p21078123_121217_MSWIN-x86-64\21078123

D:\oracle\gg_stage\p21078123_121217_MSWIN-x86-64\21078123>D:\oracle\11204\product\11.2.0\dbhome_1\OPatch\opatch apply

 

7.      Verify the version.

goto gg_home directory and type ggsci.exe

D:\>cd oracle\gg_home\product\12.1.2.1\oggfor11

D:\oracle\gg_home\product\12.1.2.1\oggfor11>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.