Monday, August 4, 2014
Oracle GoldenGate Veridata Installation and Configuration
Oracle GoldenGate Veridata is a product that enables us to compare two sets of data and identify and report on data that is out of synchronization. This is helpful in a 24×7 replication enviornment where takimg downtime to compare sets of data is not an option and Veridata can run concurrently with the Extract and Replicat processes.
Let us look at the different components of GoldenGate Veridata.
Veridata Server - it coordinates the different Veridata tasks, performs data comparisons, sorting where required, reporting
Repository – it makes use of an Oracle or MySQL database for storing data related to user preferences, configuration information, job runtime statistics etc.
Veridata Agent – makes the required database calls on behalf of the Veridaata server to fetch and return rows required for comparions.
Veridata Web - browser based interface to create comparison configurations and run jobs and view reports. B
Note: Veridata also has a command line interface called vericom which performs most of the tasks which can be performed via the web interface from the command line
We are Installing Veridata in Linux x86. I have downloaded the file V35574-01.zip from the E-Delivery web site.
The Veridata Server requires a database user with the required privileges and also a database role called VERIDATA_ROLE. We are using our existing database user which we have used in earlier tutorials GGS_OWNER and have granted the role to this user.
SQL> create role veridata_role;
SQL> grant create session, create table, create view, create procedure, create synonym to veridata_role;
We then unzip this file and it creates another file called GoldenGate_Veridata_redhatAS40_x86.sh