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.
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.
upgrade.
1.
Download
patch p21078123_121217_MSWIN-x86-64 and unzip it.
Download
patch p21078123_121217_MSWIN-x86-64 and unzip it.
After unzip it creates folder 21078123
2.
Login
to server and Check Optach version.
Login
to server and Check Optach version.
D:>cd
%oracle_home%OPatch
%oracle_home%OPatch
D:oracle11204product11.2.0dbhome_1OPatch>
D:oracle11204product11.2.0dbhome_1OPatch>opatch
version
version
OPatch Version:
11.2.0.3.4
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.
the ORACLE_HOME environment variable to the Oracle GoldenGate installation
directory, which is referred to as ORACLE_HOME.
D:>echo
%oracle_home%
%oracle_home%
D:oracle11204product11.2.0dbhome_1
D:>set
oracle_home=D:oraclegg_homeproduct12.1.2.1oggfor11
oracle_home=D:oraclegg_homeproduct12.1.2.1oggfor11
D:>echo
%oracle_home%
%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
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.
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>
D:oracle11204product11.2.0dbhome_1OPatch>opatch
lsinventory
lsinventory
6. Go
to staging directory where you unzip then got patch number directory and
execute opatch apply.
to staging directory where you unzip then got patch number directory and
execute opatch apply.
cd
D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
D:>cd
D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123
D:oraclegg_stagep21078123_121217_MSWIN-x86-6421078123>D:oracle11204product11.2.0dbhome_1OPatchopatch
apply
apply
7.
Verify the version.
Verify the version.
goto gg_home
directory and type ggsci.exe
directory and type ggsci.exe
D:>cd
oraclegg_homeproduct12.1.2.1oggfor11
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.
Leave a Reply