Saturday, July 15, 2023

The Golden Gate Microservices Upgrade from 19c to 21c using GUI Method

Oracle GoldenGate Microservices Architecture (MA) allows you to configure and manage data replication over homogeneous or heterogeneous database environments using RESTful services. These microservices can be accessed using various interfaces including a web interface, command line interface, REST API, or any other service that allows accessing REST-based microservices.


The first part of any upgrade would be to get the binaries from OTN.



For 21c binaries installation, create the directories as below:-




New ORACLE_HOME=/u01/app/ogg/oracle21


Install using the runInstaller










Before:

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/ogg/oracle19/lib

export ORACLE_HOME=/u01/app/ogg/oracle19/

export PATH=$PATH:$ORACLE_HOME/bin

export PATH=$PATH:/bin:$ORACLE_HOME/OPatch


NEW ORACLE_HOME= /u01/app/ogg/oracle21

Note down the extract and replicate trail file numbers and are in sync or not

e.g Extract-trail number- 579, Replicates-trail number-579

Stop the extract and replicate as they are in sync

 Go to the service manager console & check below services




Stop the respective deployments and go to the respective deployments and edit the respective environment variables



Now, do the changes in the Service manager and point it to new Oracle Home.



Do the changes and click apply.

Restart the service manager from service manager console.

If we get the 502 gateway error while accessing the service console page, then bounce the service manager from backend.

export OGG_ETC_HOME=/u02/deployments/ServiceManager/etc
export OGG_VAR_HOME=/u02/deployments/ServiceManager/var
export ORACLE_HOME= /u01/app/ogg/oracle21/

ps -ef|grep Service

Kill all the process from OS

start the service manager

cd $ORACLE_HOME/bin

./ServiceManager

ps -ef|grep Service

Access the service manager console page

Start the respective deployments one by one

Access the admin console page and start the extract & replicate.




References:-https://docs.oracle.com/en/middleware/goldengate/core/21.3/coredoc/overview-oracle-goldengate-microservices-architecture.html#GUID-8079B9E7-3925-46AD-9C45-172C5A248798
https://docs.oracle.com/cd/F44199_01/upgrading/upgrading-oracle-goldengate.pdf












No comments:

Post a Comment