DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, August 4, 2014

Oracle GoldenGate Veridata Installation and Configuration


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;
Role created.
SQL> grant create session, create table, create view, create procedure, create synonym to veridata_role;
Grant succeeded.

We then unzip this file and it creates another file called  GoldenGate_Veridata_redhatAS40_x86.sh




























1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.