Step-by-Step Guide to Configure Oracle GoldenGate Veridata 23c


Oracle Goldengate Veridata is a fast tool that compares data between source and target databases, report differences and fixes them.

Oracle GoldenGate Veridata 23c supports only MySQL Server as the repository database for storing metadata.


The environment consists of:

  • Host: dbsrv01.localdomain: Veridata Agent 23c, Source Database (19c) running on OEL 8.8, extracting HR.REGIONS table using GoldenGate 21.3
  • Host: dbsrv02.localdomain: Veridata Agent 23c, Target Database (19c) running on OEL 8.8, replicating HR.REGIONS table using GoldenGate 21.3
  • Host: dbsrv03.localdomain: Veridata Server 23c, running on OEL 8.8

We will set up the Veridata Server and Veridata Agent 23c for data comparison and synchronization.


1. Download the Oracle Goldengate Veridata installation file from Oracle Software Delivery Cloud.




2. Copy the Oracle Goldengate Veridata installer to the target server and unzip under /tmp.

[oracle@dbsrv03 ~]$ cd /tmp

[oracle@dbsrv03 tmp]$ unzip -qa V1046346-01.zip


3. Install JDK version 17.

[root@dbsrv03 ~]# cd /tmp

[root@dbsrv03 tmp]# yum localinstall jdk-17.0.12_linux-x64_bin.rpm

Installed:

  jdk-17-2000:17.0.12-8.x86_64

Complete!


[root@dbsrv03 tmp]# 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)


4. Run the Oracle Goldengate Veridata installer.






















5. Run the Oracle Goldengate Veridata Configuration Assistant.





















[root@dbsrv03 ~]# /u01/app/oracle/product/vdt23c/script/vdtca/install_configure_mysql.sh

2024-11-23T17:54:02.070858Z 0 [System] [MY-013169] [Server] /u01/app/oracle/product/vdt23c/mysql-commercial-8.0.34-linux-glibc2.17-x86_64-minimal/bin/mysqld (mysqld 8.0.34-commercial) initi

alizing of server in progress as process 2810

2024-11-23T17:54:02.122239Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

2024-11-23T17:54:03.416055Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

2024-11-23T17:54:07.646588Z 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.







6. Install and configure the Oracle GoldenGate Veridata Agent on both source and target database servers


Source (master)

Target (orcl)

(i). Install JDK version 17.

 [root@dbsrv01 tmp]# yum localinstall jdk-17.0.12_linux-x64_bin.rpm

Installed:

  jdk-17-2000:17.0.12-8.x86_64

 

Complete!

 

[root@dbsrv01 tmp]# 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)

(i).Install JDK version 17.

 [root@dbsrv02 tmp]# yum localinstall jdk-17.0.12_linux-x64_bin.rpm

Installed:

  jdk-17-2000:17.0.12-8.x86_64

 

Complete!

 

[root@dbsrv02 tmp]# 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)

 

(ii). Unzip the Oracle Goldengate Veridata Installer, Prepare the response file with below parameter values and start the runInstaller.

 [oracle@dbsrv01 ~]$ cd /tmp

[oracle@dbsrv01 tmp]$ unzip -qa V1046346-01.zip

[oracle@dbsrv01 tmp]$ cd fbo_oggvdt_linux_services_shiphome/Disk1/response/

[oracle@dbsrv01 response]$ vi vdtagent.rsp

 

oracle.install.responseFileVersion=rspfmt_ogginstall_response_schema_v23_1_0

INSTALL_OPTION=AGENT

IS_NEWREPO=false

SOFTWARE_LOCATION=/u01/app/oracle/product/vdt23c

INVENTORY_LOCATION=/u01/app/oraInventory

UNIX_GROUP_NAME=oinstall

 

[oracle@dbsrv01 response]$ cd ..

[oracle@dbsrv01 Disk1]$ ./runInstaller -silent -responsefile /tmp/fbo_oggvdt_linux_services_shiphome/Disk1/response/vdtagent.rsp

Starting Oracle Universal Installer...

 

Checking Temp space: must be greater than 120 MB.   Actual 8650 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 5986 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-11-23_01-09-19AM. Please wait ...

[oracle@dbsrv01 Disk1]$ You can find the log of this install session at:

 /u01/app/oraInventory/logs/installActions2024-11-23_01-09-19AM.log

Successfully Setup Software.

The installation of Oracle Veridata Services was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2024-11-23_01-09-19AM.log' for more details.

 

(ii). Unzip the Oracle Goldengate Veridata Installer, Prepare the response file with below parameter values and start the runInstaller.

[oracle@dbsrv02 ~]$ cd /tmp

[oracle@dbsrv02 tmp]$ unzip -qa V1046346-01.zip

[oracle@dbsrv02 tmp]$ cd fbo_oggvdt_linux_services_shiphome/Disk1/response/

[oracle@dbsrv02 response]$ vi vdtagent.rsp

 

oracle.install.responseFileVersion=rspfmt_ogginstall_response_schema_v23_1_0

INSTALL_OPTION=AGENT

IS_NEWREPO=false

SOFTWARE_LOCATION=/u01/app/oracle/product/vdt23c

INVENTORY_LOCATION=/u01/app/oraInventory

UNIX_GROUP_NAME=oinstall

 

 [oracle@dbsrv02 response]$ cd ..

[oracle@dbsrv02 Disk1]$ ./runInstaller -silent -responsefile /tmp/fbo_oggvdt_linux_services_shiphome/Disk1/response/vdtagent.rsp

Starting Oracle Universal Installer...

 

Checking Temp space: must be greater than 120 MB.   Actual 6580 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 7595 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2024-11-23_12-21-48PM. Please wait ...

[oracle@dbsrv02 Disk1]$ You can find the log of this install session at:

 /u01/app/oraInventory/logs/installActions2024-11-23_12-21-48PM.log

Successfully Setup Software.

The installation of Oracle Veridata Services was successful.

Please check '/u01/app/oraInventory/logs/silentInstall2024-11-23_12-21-48PM.log' for more details.

 

(iii). Deploy and configure the Oracle GoldenGate Veridata Agent

 [oracle@dbsrv01 Disk1]$ cd /u01/app/oracle/product/vdt23c/agent

[oracle@dbsrv01 agent]$ export JAVA_HOME=/usr/java/jdk-17

[oracle@dbsrv01 agent]$ ./agent_config.sh /u01/app/oracle/product/vdtagent_deploy

Successfully deployed the agent.

[oracle@dbsrv01 agent]$ cd ../..

[oracle@dbsrv01 product]$ cd vdtagent_deploy

[oracle@dbsrv01 vdtagent_deploy]$ cp agent.properties.sample agent.properties

[oracle@dbsrv01 vdtagent_deploy]$ vi agent.properties

 

server.port=7862

server.jdbcDriver=ojdbc11-23.2.0.0.jar

database.url=jdbc:oracle:thin:@localhost:1521:master

 

[oracle@dbsrv01 vdtagent_deploy]$ chmod 775 agent.properties

 

 

(iii). Deploy and configure the Oracle GoldenGate Veridata Agent

 [oracle@dbsrv02 Disk1]$ cd /u01/app/oracle/product/vdt23c/agent

[oracle@dbsrv02 agent]$ export JAVA_HOME=/usr/java/jdk-17

[oracle@dbsrv02 agent]$ ./agent_config.sh /u01/app/oracle/product/vdtagent_deploy

Successfully deployed the agent.

[oracle@dbsrv02 agent]$ cd ../..

[oracle@dbsrv02 product]$ cd vdtagent_deploy

[oracle@dbsrv02 vdtagent_deploy]$ cp agent.properties.sample agent.properties

[oracle@dbsrv02 vdtagent_deploy]$ vi agent.properties

 

server.port=7862

server.jdbcDriver=ojdbc11-23.2.0.0.jar

database.url=jdbc:oracle:thin:@localhost:1521:orcl

 

[oracle@dbsrv02 vdtagent_deploy]$ chmod 775 agent.properties

 

(iv). Start the Oracle Goldengate Veridata Agent

 [oracle@dbsrv01 vdtagent_deploy]$ ./agent.sh start agent.properties

 

 

(iv). Start the Oracle Goldengate Veridata Agent

 [oracle@dbsrv02 vdtagent_deploy]$ ./agent.sh start agent.properties



Let's get started with Oracle GoldenGate Veridata.

   1. Log in to the Veridata Server and configure connections to the source and target databases for data comparison.

In Navigation pane

Connections  -> Create  -> Create a Connection




















2. Create groups to organize database objects and set up compare pairs to match source and target tables for data comparison.

Groups and Compare Pairs -> Create Group and Compare Pair
























3. Create a job in Veridata by selecting the compare groups.

Jobs -> Create a Job













4. Run a Job in Veridata to compare the data.

Run Job -> Select a Job -> Run Job







5. Monitor jobs in Veridata to track the progress and check the results of data comparisons.









Comments

Post a Comment

Popular posts from this blog

Step-by-Step Guide to Configure Oracle GoldenGate Plug-in for Enterprise Manager 13cR5

Image
Oracle GoldenGate Enterprise Manager Plug-in helps monitor and manage Goldengate processes through Oracle Enterprise Manager Cloud Control. Environment details: Host: srvdb01.localdomain Operating System: OEL 8.8 OEM Version: 13.5.0.0 OEM Home: /u01/app/oracle/em13c/oraclehome Database Version: 19.23.0.0.0 Database Home: /u01/app/oracle/product/19.0.0/dbhome_1 Goldengate Version: 21.3.0.0.0 Goldengate Home: /u01/app/oracle/product/21.3.0/ogg_1 Goldengate Agent Home: /u01/app/oracle/oggmon_agent122   All components, including Oracle Enterprise Manager 13.5, Oracle Database 19c, Oracle Goldengate 21.3 and Goldengate Monitor Agent 12.2 are configured on the same host srvdb01.localdomain running on OEL 8.8. We will set up the Oracle GoldenGate Plug-in for Enterprise Manager 13cR5. 1. Download the Oracle Goldengate Plug-in for OEM 13.5 from edelivery.oracle.com. https://www.oracle.com/middleware/technologies/goldengate-downloads.html 2. Copy the Oracle Goldengate Plug-in to the OMS ...
Read more

How to Reposition Extract, Data Pump and Replicat in GoldenGate During Trail File Corruption

In this blog, we will walk you through the steps to reposition the Extract, Data Pump and Replicat processes in the event of Extract trail file corruption.   The environment consists of: Host: dbsrv01.localdomain: Source Database (19c) named "master" running on OEL 8.8, Extracting HR.REGIONS table using GoldenGate 21.3. Host: dbsrv02.localdomain: Target Database (19c) named "orcl" running on OEL 8.8, Replicating HR.REGIONS table using GoldenGate 21.3. Source (master) Target (orcl) 1. We have an integrated Extract running on the source database.   [oracle@dbsrv01 ~]$ ggsci   Oracle GoldenGate Command Interpreter for Oracle Version 21.3.0.0.0 OGGCORE_21.3.0.0.0_PLATFORMS_210728.1047_FBO Oracle Linux 7, x64, 64bit (optimized), Oracle Database 21c and lower supported versions on Jul 29 2021 03:59:23 Operating system character set identified as UTF-8.   Copyright (C) 1995, 2021, Oracle and/or its...
Read more