Oracle GoldenGate Upgrade Considerations
Before you start the upgrade, review the information about upgrading Extract and Replicat.
Even though you may only be upgrading the source or target installations, rather than both, all processes are involved in the upgrade. All processes must be stopped in the correct order for the upgrade, regardless of which component you upgrade, and the trails must be processed until empty.
Oracle recommends that you begin your upgrade with the target rather than the source to avoid the necessity of adjusting the trail file format.
Installation Binaries and Deployments
With Microservice Architecture, there is a strong separation between where the software is installed and the deployment directory structure for the Oracle GoldenGate instance, which contains the parameter files, report files, and trail files. For both these areas, the software binaries and deployment, are strictly separated. So, there is no interference between the old and new software installations related to the deployments. During a software upgrade, the new software will be installed independently. The deployment working with the old software will be stopped. Then, the deployment environment will be adjusted to the new software and the deployment will be restarted.
If you have a reverse proxy configuration on your host machine generated
with OGG_HOME/lib/utl/reverseproxy/ReverseProxySettings
, then
consider reconfiguring it to leverage the enhanced
ReverseProxySetting
utility available with Oracle GoldenGate
21c (21.3) and higher releases.
Considerations for Upgrading Service Manager and other Deployments
When upgrading Oracle GoldenGate, the Service Manager must be updated first. The software version of the Service Manager must be higher or equal to the version of the deployments. There are no issues having a Service Manager running on the highest version and having deployments with lower versions.
After completing the upgrade, run the UPGRADE
HEARTBEATTABLE
command to add extra columns for tables and lag views.
These extra columns are used to track the Extract restart position. See
UPGRADE HEARTBEATTABLE
to
know more.