OGG Veridata Installation server treated as a server which has Veridata Installation and also MySQL Repository Database.
After the installation of the Verdata in our previous blog post: https://oracle-ckpt.com/oracle-golden-gate-veridata-23c-installation/ we have the veridata home ready with the location /ogg/veridata.
After the installation now we have to configure the veridata using the binary Veridata Configuration Assisstant vdtca.sh. Please note that we need to export the JDK17 home properly in order to start the vdtca as below.
[oracle@gghub bin]$ export JAVA_HOME=/usr/java/jdk-17-oracle-x64
[oracle@gghub bin]$ export PATH=$JAVA_HOME/bin:$PATHNow from Veridata Home we will initiate the vdtca.sh as below.
We need to provide the verdata user which will be used to login to MySQL Database. In the next screen we have Java heap sizes and we will proceed with the recommended settigns.
Now the installer asks for the administrator account and password, these credentials used in the Veridata WEB UI.
We have few more features to enable the security for the WEB UI, we’ve selected to use self signed certificate. If we have preexisting files those files can be uploaded.
We have selected the default port 8831 for the veridata server.
Summary of the configuration
after this step, configuration provides the shell script to run to complete the configuration of MySQL as below.
[root@gghub ~]# /ogg/veridata/script/vdtca/install_configure_mysql.sh
2025-12-06T07:01:45.871460Z 0 [System] [MY-013169] [Server] /ogg/veridata/mysql-commercial-8.0.34-linux-glibc2.17-x86_64-minimal/bin/mysqld (mysqld 8.0.34-commercial) initializing of server in progress as process 19971
2025-12-06T07:01:45.884372Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-12-06T07:01:46.680763Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-12-06T07:01:48.861706Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
[Info] The Configuration Assistant will set the root user password as what you entered in the next stage of veridata repository creation.
[Info] MySQL has been installed and started.
[Info] Please return to the Configuration Assistant and click "OK" to continue.
[root@gghub ~]#From the logs we can see the MySQL configuration is completed and started with no errors.
After the installation it provides the WEB UI URL, the null to be replaced with the hostname/Ip address.
The veridata configuration completed and now we will try to access the WEB UI as below using the vdadmin credentials.
After login we can see the homepage of the Veridata.
In our next blog post, we will cover the user creation at source and target databases to manage the veridata and also we will install the veridata agents.
