In this article, we will be seeing on how to apply the newly released Oracle GoldenGate Veridata 23c patch which is 23.2.0.0.0.

37311334 – OGG Veridata Bundle Patch 23.2.0.0.0 (Server+Agent)

The current version of Oracle GoldenGate Veridata is 23.1.0.0.241015. You can check this by clicking on the “i” (About) icon on the top right corner of the Veridata 23c UI.

vdt23c_patch1

To download the patch from the MOS, you can either directly search with the patch number or you can also select the Product and the release to the get the appropriate patch.

vdt23c_patch2

vdt23c_patch3

vdt23c_patch4

vdt23c_patch5

The Oracle GoldenGate Veridata 23c is installed in /scratch/vdt23c and this is the Veridata 23c Home.

vdt23c_patch6

The patch is already downloaded and moved to the server. It is in /scratch/vdt23c_patch

vdt23c_patch7

Please unzip the patch using the below command.

unzip -q p37311334_231000_Linux-x86-64.zip

vdt23c_patch8

Make sure you had set the JAVA_HOME to JDK 17

java -version
echo $JAVA_HOME

vdt23c_patch9

Now, to apply the patch, we need to stop the Veridata Server. Stop the Veridata Server using the below command.

cd $VERIDATA_HOME/bin

./run.sh stop

vdt23c_patch10

Export ORACLE_HOME variable to your veridata installation location (Veridata Home).

vdt23c_patch11

Navigate to the folder where the patch has been placed.

vdt23c_patch12

Now apply the patch using the below command,

$ORACLE_HOME/OPatch/opatch apply

vdt23c_patch13

Check if the patch is applied properly using the below command.

$ORACLE_HOME/OPatch/opatch lsinventory

vdt23c_patch14

Start the Veridata Server using the below command.

(when prompoted for MySQL password, you can optionally hit ‘Enter’ to use wallet)

cd $VERIDATA_HOME/bin

./run.sh

vdt23c_patch15

The Veridata Server has been started. Check if it is up and running.

ps -ef |grep veridata

vdt23c_patch16

The patch has been successfully applied. You can check this by clicking on the “i” icon (About) on the top right corner of the Veridata 23c UI.

vdt23c_patch17

Note: Make sure to restart all the Veridata Agents after applying the patch.

To know more about Oracle GoldenGate Veridata 23c, please check the below,

How to download the Product:

Documentation

Certification Matrix

Videos

Data Sheet

Upgrade

Blogs