Update Oracle GoldenGate Veridata 23c
Update Oracle GoldenGate Veridata 23c contains the steps needed to install a patch. This will update Veridata from 23.1 to 23.2
Table of Contents
Preparation
First we download patch 37311334 from support.oracle.com and place it in the directory /sw/ora_GoldenGate/Veridata/patch/p37311334_231000_Linux-x86-64.zip which is accessible from the Oracle GoldenGate Veridata servers (The installation of the servers is described in this post).
Update GoldenGate Veridata
First we stop all agents on all servers (look here) and after that we shutdown the server.
# as root on the server
su - vdt -c '. vdt.env && cd /u01/app/vdt/vdt23c/bin && ./run.sh stop'
Now we install the patch on all servers with the following command:
# Copy the patch to the server and unpack
su - vdt -c 'unzip -q /sw/ora_GoldenGate/Veridata/patch/p37311334_231000_Linux-x86-64.zip -d ~'
# Check the installed patches before the patch installation
su - vdt -c '. vdt.env ; opatch lsinventory'
# Apply the patch
su - vdt -c '. vdt.env ; opatch apply -silent 37311334'
# Check the installed patches after the patch installation
su - vdt -c '. vdt.env ; opatch lsinventory'
After the installation has finished we start the server:
su - vdt -c '. vdt.env && cd /u01/app/vdt/vdt23c/bin && echo changeme|./run.sh start'
And also the agents on all servers (click).
Sample Output from a server machine:
[root@lin3 ~]# su - vdt -c ". vdt.env && show_agents ; read -p 'Enter the agent name to stop (e.g. agent1): ' ag && /u01/app/vdt/\$ag/agent.sh stop"
=== Currently configured Agents: ===
agent1(port: 7861): tcp6 0 0 :::7861 :::* LISTEN
=== End ===
Enter the agent name to stop (e.g. agent1): agent1
[VERIAGT-BOOT] INFO Looking for home directory.
[VERIAGT-BOOT] INFO Found bootstrap class in file:/u01/app/vdt/vdt23c/agent/JavaAgent.jar!/com/goldengate/veridata/agent/BootstrapNextGen.class.
[VERIAGT-BOOT] INFO Home directory: /u01/app/vdt/vdt23c/agent
[VERIAGT-BOOT] INFO Preparing classpath.
[VERIAGT-BOOT] INFO Driver location: /u01/app/vdt/vdt23c/agent/drivers
[VERIAGT-BOOT] INFO Drivers to load: ojdbc11-23.2.0.0.jar
[VERIAGT-BOOT] INFO Classpath:
[VERIAGT-BOOT] INFO /u01/app/vdt/vdt23c/agent/JavaAgent.jar
[VERIAGT-BOOT] INFO /u01/app/vdt/vdt23c/agent/drivers/ojdbc11-23.2.0.0.jar
[VERIAGT-BOOT] INFO /u01/app/vdt/vdt23c/agent/agent-manifest.jar
[VERIAGT-BOOT] INFO Initializing.
[VERIAGT-BOOT] INFO Invoking startup method: public static void com.goldengate.veridata.agent.VeridataAgentNextGen.main(java.lang.String[])
2025-02-14 17:46:40.469 NOTIFICATION OGGV-60150 Configuring logging.
2025-02-14 17:46:40.517 NOTIFICATION OGGV-60151 Config file for logger is /u01/app/vdt/agent1/config/odl.xml
2025-02-14 17:46:45.583 NOTIFICATION OGGV-60161 Shutdown request complete: OK
[root@lin3 ~]#
[root@lin3 ~]# # as root on the server
[root@lin3 ~]# su - vdt -c '. vdt.env && cd /u01/app/vdt/vdt23c/bin && ./run.sh stop'
4627
Shutting down the server...
[root@lin3 ~]# # Copy the patch to the server and unpack
[root@lin3 ~]# su - vdt -c 'unzip -q /sw/ora_GoldenGate/Veridata/patch/p37311334_231000_Linux-x86-64.zip -d ~'
# Apply the patch
su - vdt -c '. vdt.env ; opatch apply -silent 37311334'
# Check the installed patches after the patch installation
su - vdt -c '. vdt.env ; opatch lsinventory'
[root@lin3 ~]# # Check the installed patches before the patch installation
[root@lin3 ~]# su - vdt -c '. vdt.env ; opatch lsinventory'
Oracle Interim Patch Installer version 12.2.0.1.43
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/vdt/vdt23c
Central Inventory : /u01/app/oraInventory
from : /u01/app/vdt/vdt23c/oraInst.loc
OPatch version : 12.2.0.1.43
OUI version : 12.2.0.9.0
Log file location : /u01/app/vdt/vdt23c/cfgtoollogs/opatch/opatch2025-02-14_17-47-45PM_1.log
Lsinventory Output file location : /u01/app/vdt/vdt23c/cfgtoollogs/opatch/lsinv/lsinventory2025-02-14_17-47-45PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: lin3.fritz.box
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Veridata Services 23.1.0.0.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[root@lin3 ~]# # Apply the patch
[root@lin3 ~]# su - vdt -c '. vdt.env ; opatch apply -silent 37311334'
Oracle Interim Patch Installer version 12.2.0.1.43
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/vdt/vdt23c
Central Inventory : /u01/app/oraInventory
from : /u01/app/vdt/vdt23c/oraInst.loc
OPatch version : 12.2.0.1.43
OUI version : 12.2.0.9.0
Log file location : /u01/app/vdt/vdt23c/cfgtoollogs/opatch/opatch2025-02-14_17-47-47PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 37311334
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '37311334' to OH '/u01/app/vdt/vdt23c'
Patching component oracle.oggvdt.services.server, 23.1.0.0.0...
Patching component oracle.oggvdt.services.agent, 23.1.0.0.0...
Patch 37311334 successfully applied.
Log file location: /u01/app/vdt/vdt23c/cfgtoollogs/opatch/opatch2025-02-14_17-47-47PM_1.log
OPatch succeeded.
[root@lin3 ~]# # Check the installed patches after the patch installation
[root@lin3 ~]# su - vdt -c '. vdt.env ; opatch lsinventory'
Oracle Interim Patch Installer version 12.2.0.1.43
Copyright (c) 2025, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/vdt/vdt23c
Central Inventory : /u01/app/oraInventory
from : /u01/app/vdt/vdt23c/oraInst.loc
OPatch version : 12.2.0.1.43
OUI version : 12.2.0.9.0
Log file location : /u01/app/vdt/vdt23c/cfgtoollogs/opatch/opatch2025-02-14_17-48-01PM_1.log
Lsinventory Output file location : /u01/app/vdt/vdt23c/cfgtoollogs/opatch/lsinv/lsinventory2025-02-14_17-48-01PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: lin3.fritz.box
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Veridata Services 23.1.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 37311334 : applied on Fri Feb 14 17:47:57 CET 2025
Unique Patch ID: 26071773
Patch description: "OGG Veridata Bundle Patch 23.2.0.0.250131 (Server+Agent) - PATCH AUTOMATION TEST"
Created on 31 Jan 2025, 10:02:14 hrs UTC
Bugs fixed:
36626829, 37020034
--------------------------------------------------------------------------------
OPatch succeeded.
[root@lin3 ~]# su - vdt -c '. vdt.env && cd /u01/app/vdt/vdt23c/bin && echo changeme|./run.sh start'
Unknown argument. Starting the server by default.
Java version:17.0.13
mysqladmin: [Warning] Using a password on the command line interface can be insecure. mysqld is alive
MySQL server is up and running in the port: 3306
Schema Migration started! /u01/app/vdt/vdt23c/bin/../vdt-schema-migration-dummy.jar
Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option --illegal-access=warn; support was removed in 17.0
WARNING: package com.sun.net.ssl.internal.ssl not in java.base
2025-02-14T16:48:17+0000 INFO: startup: Launched java jar PID 5666
[root@lin3 ~]# Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option --illegal-access=warn; support was removed in 17.0
WARNING: package com.sun.net.ssl.internal.ssl not in java.base
SLF4J: No SLF4J providers were found.
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See https://www.slf4j.org/codes.html#noProviders for further details.
[EL Warning]: 2025-02-14 17:48:25.863--Overriding the PROPERTY mapping attribute [method getCreatedAt] with the FIELD mapping attribute [field createdAt] from class [com.goldengate.veridata.user.Roles]. To avoid this warning you should mark the attribute [method getCreatedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.869--Overriding the PROPERTY mapping attribute [method getModifiedAt] with the FIELD mapping attribute [field modifiedAt] from class [com.goldengate.veridata.user.Roles]. To avoid this warning you should mark the attribute [method getModifiedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.869--Overriding the PROPERTY mapping attribute [method getName] with the FIELD mapping attribute [field name] from class [com.goldengate.veridata.user.Roles]. To avoid this warning you should mark the attribute [method getName] as transient.
[EL Warning]: 2025-02-14 17:48:25.869--Overriding the PROPERTY mapping attribute [method getDescription] with the FIELD mapping attribute [field description] from class [com.goldengate.veridata.user.Roles]. To avoid this warning you should mark the attribute [method getDescription] as transient.
[EL Warning]: 2025-02-14 17:48:25.87--Overriding the PROPERTY mapping attribute [method getId] with the FIELD mapping attribute [field id] from class [com.goldengate.veridata.user.Roles]. To avoid this warning you should mark the attribute [method getId] as transient.
[EL Warning]: 2025-02-14 17:48:25.875--Overriding the PROPERTY mapping attribute [method getCreatedAt] with the FIELD mapping attribute [field createdAt] from class [com.goldengate.veridata.user.UserGroups]. To avoid this warning you should mark the attribute [method getCreatedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.875--Overriding the PROPERTY mapping attribute [method getModifiedAt] with the FIELD mapping attribute [field modifiedAt] from class [com.goldengate.veridata.user.UserGroups]. To avoid this warning you should mark the attribute [method getModifiedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.875--Overriding the PROPERTY mapping attribute [method getName] with the FIELD mapping attribute [field name] from class [com.goldengate.veridata.user.UserGroups]. To avoid this warning you should mark the attribute [method getName] as transient.
[EL Warning]: 2025-02-14 17:48:25.876--Overriding the PROPERTY mapping attribute [method getDescription] with the FIELD mapping attribute [field description] from class [com.goldengate.veridata.user.UserGroups]. To avoid this warning you should mark the attribute [method getDescription] as transient.
[EL Warning]: 2025-02-14 17:48:25.876--Overriding the PROPERTY mapping attribute [method getId] with the FIELD mapping attribute [field id] from class [com.goldengate.veridata.user.UserGroups]. To avoid this warning you should mark the attribute [method getId] as transient.
[EL Warning]: 2025-02-14 17:48:25.877--Overriding the PROPERTY mapping attribute [method getCreatedAt] with the FIELD mapping attribute [field createdAt] from class [com.goldengate.veridata.user.Users]. To avoid this warning you should mark the attribute [method getCreatedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.877--Overriding the PROPERTY mapping attribute [method getModifiedAt] with the FIELD mapping attribute [field modifiedAt] from class [com.goldengate.veridata.user.Users]. To avoid this warning you should mark the attribute [method getModifiedAt] as transient.
[EL Warning]: 2025-02-14 17:48:25.877--Overriding the PROPERTY mapping attribute [method getName] with the FIELD mapping attribute [field name] from class [com.goldengate.veridata.user.Users]. To avoid this warning you should mark the attribute [method getName] as transient.
[EL Warning]: 2025-02-14 17:48:25.877--Overriding the PROPERTY mapping attribute [method getId] with the FIELD mapping attribute [field id] from class [com.goldengate.veridata.user.Users]. To avoid this warning you should mark the attribute [method getId] as transient.
[EL Warning]: 2025-02-14 17:48:25.882--Overriding the PROPERTY mapping attribute [method getId] with the FIELD mapping attribute [field id] from class [com.goldengate.veridata.user.UserGroupRoleMapping]. To avoid this warning you should mark the attribute [method getId] as transient.
[EL Warning]: 2025-02-14 17:48:25.894--Overriding the PROPERTY mapping attribute [method getComparePairNum] with the FIELD mapping attribute [field comparePairNum] from class [com.goldengate.veridata.finished.ComparePairFinishedStats]. To avoid this warning you should mark the attribute [method getComparePairNum] as transient.
[EL Warning]: 2025-02-14 17:48:26.152--PersistenceUnitInfo VeridataServer has transactionType RESOURCE_LOCAL and therefore jtaDataSource will be ignored
[EL Warning]: 2025-02-14 17:48:26.625--Reverting the lazy setting on the OneToOne or ManyToOne attribute [group] for the entity class [class com.goldengate.veridata.comparison.GroupRunName] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.626--Reverting the lazy setting on the OneToOne or ManyToOne attribute [comparePairStats] for the entity class [class com.goldengate.veridata.finished.ComparePairDelta] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.627--Reverting the lazy setting on the OneToOne or ManyToOne attribute [comparePair] for the entity class [class com.goldengate.veridata.finished.ComparePairRunDetails] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.628--Reverting the lazy setting on the OneToOne or ManyToOne attribute [jobStats] for the entity class [class com.goldengate.veridata.repair.RepairJob] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.628--Reverting the lazy setting on the OneToOne or ManyToOne attribute [connection] for the entity class [class com.goldengate.veridata.connection.ConnectionTypeMapping] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.629--Reverting the lazy setting on the OneToOne or ManyToOne attribute [groupStats] for the entity class [class com.goldengate.veridata.repair.RepairGroup] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.629--Reverting the lazy setting on the OneToOne or ManyToOne attribute [job] for the entity class [class com.goldengate.veridata.comparison.JobRunName] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.63--Reverting the lazy setting on the OneToOne or ManyToOne attribute [groupStats] for the entity class [class com.goldengate.veridata.finished.GroupRunDetails] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.631--Reverting the lazy setting on the OneToOne or ManyToOne attribute [jobStats] for the entity class [class com.goldengate.veridata.finished.JobRunDetails] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.632--Reverting the lazy setting on the OneToOne or ManyToOne attribute [jobName] for the entity class [class com.goldengate.veridata.finished.PerformanceStats] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.632--Reverting the lazy setting on the OneToOne or ManyToOne attribute [groupName] for the entity class [class com.goldengate.veridata.finished.PerformanceStats] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.633--Reverting the lazy setting on the OneToOne or ManyToOne attribute [name] for the entity class [class com.goldengate.veridata.finished.PerformanceStats] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.634--Reverting the lazy setting on the OneToOne or ManyToOne attribute [targConnection] for the entity class [class com.goldengate.veridata.comparison.Job] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.635--Reverting the lazy setting on the OneToOne or ManyToOne attribute [srcConnection] for the entity class [class com.goldengate.veridata.comparison.Job] since weaving was not enabled or did not occur.
[EL Warning]: 2025-02-14 17:48:26.635--Reverting the lazy setting on the OneToOne or ManyToOne attribute [fullProfile] for the entity class [class com.goldengate.veridata.comparison.Job] since weaving was not enabled or did not occur.
[root@lin3 ~]# su - vdt -c ". vdt.env && show_agents ; read -p 'Enter the agent name to start (e.g. agent1): ' ag && /u01/app/vdt/\$ag/agent.sh start"
=== Currently configured Agents: ===
agent1(port: 7861):
=== End ===
Enter the agent name to start (e.g. agent1): agent1
[root@lin3 ~]#

That’s all. Oracle Veridata has been updated from 23.1 to 23.2 🙂
Leave a Reply