Oracle GoldenGate Veridata 23c is a powerful tool that helps organizations check and confirm that data is the same across different databases. As companies move data between on-premises systems, cloud platforms, and disaster recovery environments, ensuring accuracy becomes very important.
Veridata 23c makes this easier by providing fast, reliable, and automated data comparison. It quickly identifies any differences, helps users fix them, and works smoothly with GoldenGate 23c for ongoing data replication.
Personally I liked the architecture of veridata, since internally it used MySQL Database for repository purpose and we can view all the veridata configuration using the MySQL Tables. We will go through with all these step by step.
The OGG Veridata software is available in eDelivery and in this entire veridata blog posts we are using 23.1.0.0.0 Version.
We will download the Verdata 23c for Linux 64bit platform. You can also opt for the wget.sh if the network is open for internet.
After downloading or uploading into server, unzip from Oracle user and start the runInstaller as below image.
Here we have an option either to use existing MySQL or Installer can create the new MySQL Database. Since i do not have MySQL installed, I’ve opted for new installation.
Select the location for the Veridata software
Summary of the Installation
Installation is in progress after proceeding with the next step.
Now the installation has completed successfully.
To use the Veridata Configuration Assistant, the JDK version should be 17 but in my case the Java version is 8.
[oracle@gghub ~]$ cd /ogg/veridata/bin/
[oracle@gghub bin]$ ls
run.sh vdtca.sh
[oracle@gghub bin]$ ./vdtca.sh
Found /usr/bin/java to run this product, and the major version of this Java is 8.
The mandatory minimum major version to run this product is 17.
This product cannot run with this Java.
[oracle@gghub bin]$ export JAVA_HOME=/ogg/veridata/jdk
[oracle@gghub bin]$ export PATH=$JAVA_HOME/bin:$PATH
[oracle@gghub bin]$ ./vdtca.sh
Found /ogg/veridata/jdk/bin/java to run this product, and the major version of this Java is 11.
The mandatory minimum major version to run this product is 17.
This product cannot run with this Java.
[oracle@gghub bin]$Either we can use yum repos to download and install (or) JDK17 RPM is available for offline installations.
In my practice i used offline RPM package and installed the JDK 17 as below
-rw-r--r--. 1 oracle oinstall 182484307 Dec 6 09:39 jdk-17.0.12_linux-x64_bin.rpm
[root@gghub softwares]# rpm -ivh jdk-17.0.12_linux-x64_bin.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:jdk-17-2000:17.0.12-8 ################################# [100%]
[root@gghub softwares]#
[oracle@gghub bin]$ java -version
java version "11.0.25" 2024-10-15 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.25+9-LTS-256)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.25+9-LTS-256, mixed mode)
[oracle@gghub bin]$Verify the location of the JDK17 Home
[oracle@gghub bin]$ ls -d /usr/java/* /usr/lib/jvm/* 2>/dev/null
/usr/java/default /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.462.b08-2.0.1.el8.x86_64 /usr/lib/jvm/jre-1.8.0-openjdk-1.8.0.462.b08-2.0.1.el8.x86_64
/usr/java/jdk-17 /usr/lib/jvm/jdk-17.0.12-oracle-x64 /usr/lib/jvm/jre-openjdk
/usr/java/jdk-17-oracle-x64 /usr/lib/jvm/jre-1.8.0
/usr/java/latest /usr/lib/jvm/jre-1.8.0-openjdk
[oracle@gghub bin]$Now we will check the latest Java version after exporting the environment variables
[oracle@gghub bin]$ export JAVA_HOME=/usr/java/jdk-17-oracle-x64
[oracle@gghub bin]$ export PATH=$JAVA_HOME/bin:$PATH
[oracle@gghub bin]$ java -version
java version "17.0.12" 2024-07-16 LTS
Java(TM) SE Runtime Environment (build 17.0.12+8-LTS-286)
Java HotSpot(TM) 64-Bit Server VM (build 17.0.12+8-LTS-286, mixed mode, sharing)
[oracle@gghub bin]$We’ve completed the Veridata Installation and also updated the Java version to 17.
In next blog we will proceed with the Veridata configuration.
