This post demonstrates the process of patching Oracle GoldenGate Microservices Architecture (MA) using OPatch.
Before applying the patch, it is important to verify that the Oracle GoldenGate environment is healthy and that replication between the source and target databases is fully synchronized. All GoldenGate processes, including Extracts, Replicats, Distribution Paths, and Receiver Services, should be stopped to ensure a clean patching operation. Additionally, all deployment services and the Service Manager must be shut down before patch installation.
Environment:
==========
GoldenGate Version: 19.32
Patch Version to Be Applied : 19.33
DB Version: Oracle 19.27
DB Type: Standalone Multitenant
GoldenGate Home: /app/ogg19cma
Goldengate Architecture: Microservices
Deployment Name: Deployment1
1. Check the GoldenGate sync before applying the patch.
Check the Oracle GoldenGate replication status and ensure that the source and target databases are fully synchronized before applying the patch.
–Navigate to the bin directory
[oracle@oggsrc ~]$ cd /app/ogg19cma/bin/
–Connect to the deployment1
OGG (not connected) 5> CONNECT http://oggsrc:7000 DEPLOYMENT Depolyment1 USER oggadmin PASSWORD oracle
OGG (http://oggsrc:7000 Depolyment1) 6>
[oracle@oggsrc bin]$ ./adminclient
Oracle GoldenGate Administration Client for Oracle
Version 19.31.0.0.260421 OGGCORE_19.31.0.0.0OGGRU_PLATFORMS_260409.1230
–Check all services running or not
OGG (http://oggsrc:7000 Depolyment1) 11> info all
Program Status Group Type Lag at Chkpt Time Since Chkpt
ADMINSRVR RUNNING
DISTSRVR RUNNING
PMSRVR RUNNING
RECVSRVR RUNNING
EXTRACT RUNNING EXTSRC1 INTEGRATED 00:00:00 00:00:03
–check the lag of a Distribution Path
OGG (http://oggsrc:7000 Depolyment1) 13> INFO DISTPATH ALL
DistPathFrom_PMPSRC1 running
OGG (http://oggsrc:7000 Depolyment1) 14> INFO DISTPATH DistPathFrom_PMPSRC1 DETAIL
Path Name: DistPathFrom_PMPSRC1
Status: running
Source: trail://192.168.56.172:7002/services/v2/sources?trail=es
Target: ogg://192.168.56.173:7003/services/v2/targets?trail=es
SizeMB: 500
Sequence Length: 9
Encryption Algorithm: NONE
Compression: Off
Begin Position: seqno: 0 rba: 0
AutoRestart: retries 10, delay 2
EOF Delay: 100 CSecs
Critical: no
Process Id: 11821
Thread Id: 11835
Last Started: 2026-11-19T04:10:33.780Z
Source Database Name: GGSRC
Processing Lag: 0
Since Lag Reported: 6
Encryption Profile: LocalWallet
2. Unzip the GoldenGate Patch ZIp file.
[oracle@oggsrc GG_19.33]$ unzip p40108493_1933000OGGRU_Linux-x86-64.zip
[oracle@oggsrc GG_19.33]$ ls -lrt
total 233236
-rwxrwxrwx. 1 oracle oinstall 333377 Oct 14 22:54 release-notes-oracle-goldengate-19.33.0.0.261020.pdf
drwxr-xr-x. 4 oracle oinstall 4096 Oct 14 23:26 40108493
-r–r—–. 1 oracle oinstall 1414 Oct 15 09:54 OGG-19.1.0.0-README.txt
-r–r—–. 1 oracle oinstall 4504 Oct 15 11:56 README_ora19c.txt
-rw-r–r–. 1 oracle oinstall 238478469 Oct 25 06:22 p40108493_1933000OGGRU_Linux-x86-64.zip
3. Upgrade OPatch to the latest available version.
[oracle@oggsrc GG_19.33]$ cd /app/ogg19cma
[oracle@oggsrc ogg19cma]$ mv OPatch OPatch_old
[oracle@oggsrc ogg19cma]$ unzip p6880880_190000_Linux-x86-64.zip
[oracle@oggsrc ogg19cma]$ cd OPatch
[oracle@oggsrc OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.54
OPatch succeeded.
4. Set the ORACLE_HOME environment variable to the Oracle GoldenGate installation directory.
–Unset the existing HOME environments
[oracle@oggsrc ~]$ unset ORACLE_HOME
[oracle@oggsrc ~]$ unset ORACLE_SID
–Set the ORACLE_HOME environment variable to the GoldenGate installation directory
[oracle@oggsrc ~]$ export ORACLE_HOME=/app/ogg19cma
[oracle@oggsrc ~]$ echo $ORACLE_HOME
/app/ogg19cma
5. Verify the Oracle Inventory to identify the installed patches.
[oracle@oggsrc ~]$ unset ORACLE_HOME
[oracle@oggsrc ~]$ export ORACLE_HOME=/app/ogg19cma
[oracle@oggsrc ~]$ /app/ogg19cma/OPatch/opatch lsinventory
[oracle@oggsrc ~]$ /app/ogg19cma/OPatch/opatch lspatches
39174552;Oracle GoldenGate 19.31.0.0.260421 for Oracle 19c
OPatch succeeded.
6. Run the OPatch prerequisite checks and confirm that it passes without errors.
–-Navigate to the unzipped patch directory
[oracle@oggsrc ~]$ cd /misc/oracle/GG_19.33/40108493/
–-Run the OPatch prerequisites check and verify that it passes.
[oracle@oggsrc 40108493]$ /app/ogg19c/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.54
Copyright (c) 2026, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /app/ogg19cma
Central Inventory : /u01/app/oraInventory
from : /app/ogg19cma/oraInst.loc
OPatch version : 12.2.0.1.54
OUI version : 12.2.0.4.0
Log file location : /app/ogg19cma/cfgtoollogs/opatch/opatch2026-11-19_10-36-34AM_1.log
Invoking prereq “checkconflictagainstohwithdetail”
Prereq “checkConflictAgainstOHWithDetail” passed.
OPatch succeeded.
7. Stop the all processes of GoldenGate Microservices.
Before applying the Oracle GoldenGate patch, ensure that all deployment-related processes, including Extracts, Replicats, and Distribution Paths, are stopped. Additionally, shut down all services associated with the deployments to avoid any interruptions or conflicts during the patching process.
[oracle@oggsrc ~]$ cd /app/ogg19cma/bin/
[oracle@oggsrc bin]$ ./adminclient
Oracle GoldenGate Administration Client for Oracle
Version 19.31.0.0.260421 OGGCORE_19.31.0.0.0OGGRU_PLATFORMS_260409.1230
Copyright (C) 1995, 2025, Oracle and/or its affiliates. All rights reserved.
Linux, x64, 64bit (optimized) on Apr 9 2026 17:22:42
Operating system character set identified as UTF-8.
OGG (not connected) 1> CONNECT http://oggsrc:7000 DEPLOYMENT Depolyment1 USER oggadmin PASSWORD oracle
OGG (http://oggsrc:7000 Depolyment1) 2>
–Stop the Distribution Paths
OGG (http://oggsrc:7000 Depolyment1) 2> STOP DISTPATH ALL
2026-11-19T05:11:00Z INFO OGG-08514 The path ‘DistPathFrom_PMPSRC1’ has been stopped.
–Stop all extracts
OGG (http://oggsrc:7000 Depolyment1) 3> STOP EXTRACT *
2026-11-19T05:11:50Z INFO OGG-08100 Sending STOP request to EXTRACT EXTSRC1
2026-11-19T05:11:50Z INFO OGG-00979 EXTRACT EXTSRC1 is down (gracefully)
–Stop the Microservices
OGG (http://oggsrc:7000 Depolyment1) 5> STOP SERVICE *
Service ‘ADMINSRVR’ was stopped
Service ‘DISTSRVR’ was stopped
Service ‘PMSRVR’ was stopped
Service ‘RECVSRVR’ was stopped
–Verify all processes are Stopped or not
OGG (http://oggsrc:7000 Depolyment1) 6> info all
Program Status Group Type Lag at Chkpt Time Since Chkpt
ADMINSRVR STOPPED
DISTSRVR STOPPED
PMSRVR STOPPED
RECVSRVR STOPPED
–Stop the Service Manager
[root@oggsrc ~]# systemctl stop OracleGoldenGate
Note: If multiple deployments are configured, connect to each deployment individually and stop all associated processes before proceeding with the patching activity.
8. Take the Goldengate home backup.
[oracle@oggsrc ~]$ cd /app/
[oracle@oggsrc app]$ tar -pcvf /misc/oracle/oggma_home_bkp.tar ogg19cma
[oracle@oggsrc ~]$ ls -l /misc/oracle/oggma_home_bkp.tar
-rw-r–r–. 1 oracle oinstall 2148116480 Nov 19 10:49 /misc/oracle/oggma_home_bkp.tar
9. Apply the patch.
[oracle@oggsrc ~]$ /app/ogg19cma/OPatch/opatch apply -oh /app/ogg19cma -local /misc/oracle/GG_19.33/40108493
Oracle Interim Patch Installer version 12.2.0.1.54
Copyright (c) 2026, Oracle Corporation. All rights reserved.
Oracle Home : /app/ogg19cma
Central Inventory : /u01/app/oraInventory
from : /app/ogg19cma/oraInst.loc
OPatch version : 12.2.0.1.54
OUI version : 12.2.0.4.0
Log file location : /app/ogg19cma/cfgtoollogs/opatch/opatch2026-11-19_10-51-27AM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 40108493
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/app/ogg19cma’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘40108493’ to OH ‘/app/ogg19cma’
Patching component oracle.oggcore.services.ora19c, 19.1.0.0.0…
Patch 40108493 successfully applied.
Sub-set patch [39174552] has become inactive due to the application of a super-set patch [40108493].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /app/ogg19cma/cfgtoollogs/opatch/opatch2026-11-19_10-51-27AM_1.log
OPatch succeeded.
10. Verify the Oracle Inventory to identify the installed patches.
[oracle@oggsrc ~]$ /app/ogg19cma/OPatch/opatch lsinventory
[oracle@oggsrc ~]$ /app/ogg19cma/OPatch/opatch lspatches
40108493;Oracle GoldenGate 19.33.0.0.261020 for Oracle 19c
OPatch succeeded.
11. Once the patch has been successfully applied, restart the Service Manager, start the deployment services, and resume all Oracle GoldenGate processes.
–Start the Service Manager
[root@oggsrc ~]# systemctl start OracleGoldenGate
–Start the Admin Client and connect to the deployment.
[oracle@oggsrc ~]$ cd /app/ogg19cma/bin/
[oracle@oggsrc bin]$ ./adminclient
Oracle GoldenGate Administration Client for Oracle
Version 19.33.0.0.261020 OGGCORE_19.33.0.0.0OGGRU_PLATFORMS_261013.0850
Copyright (C) 1995, 2025, Oracle and/or its affiliates. All rights reserved.
Linux, x64, 64bit (optimized) on Oct 13 2026 12:38:35
Operating system character set identified as UTF-8.
OGG (not connected) 1> CONNECT http://oggsrc:7000 DEPLOYMENT Deployment1 USER oggadmin PASSWORD oracle
–Start the services
OGG (http://oggsrc:7000 Depolyment1) 3> START SERVICE *
Service ‘ADMINSRVR’ was started
Service ‘DISTSRVR’ was started
Service ‘PMSRVR’ was started
Service ‘RECVSRVR’ was started
–Start the extract
OGG (http://oggsrc:7000 Depolyment1) 5> start EXTSRC1
2026-11-19T05:43:03Z INFO OGG-00975 EXTRACT EXTSRC1 starting
2026-11-19T05:43:03Z INFO OGG-15426 EXTRACT EXTSRC1 started
–Verify the services and processess runnings status
OGG (http://oggsrc:7000 Depolyment1) 6> info all
Program Status Group Type Lag at Chkpt Time Since Chkpt
ADMINSRVR RUNNING
DISTSRVR RUNNING
PMSRVR RUNNING
RECVSRVR RUNNING
EXTRACT RUNNING EXTSRC1 INTEGRATED 00:00:00 00:31:22
12. Verify the replication sync after patching.
–Insert record in source table of soure database.
SQL> select * from hr.test order by id;
ID NAME
———- ——————–
1 ABC
2 XYZ
3 DEF
4 UVW
5 GHJ
SQL> insert into hr.test(id,name) values(6,’KLM’);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from hr.test order by id;
ID NAME
———- ——————–
1 ABC
2 XYZ
3 DEF
4 UVW
5 GHJ
6 KLM
6 rows selected.
–Verify the target table in the target database to confirm that the newly created record has been successfully replicated.
SQL> show con_name
CON_NAME
——————————
GGTGTPDB1
SQL> select * from hr.test order by id;
ID NAME
———- ——————–
1 ABC
2 XYZ
3 DEF
4 UVW
5 GHJ
6 KLM
6 rows selected.
This confirms that Oracle GoldenGate replication is functioning successfully.
The patch was applied successfully, and all post-patching validations were completed without issues.
Disclaimer:
Please note the above information is only for educational purpose and practised in personal test database only. Always test in test database before implementing in production database. The pre-requisites and ways of implementing may vary from one environment to another. Hence, not providing guarantee that it will work in your environment.