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.

Source: GoldenGate Veridata Administration Guide

Let us look at some of the screen shots taken from the Veridata Server Installation.

In the next post, we will discuss the installation and configuration of the Veridata Agent as well as using the Veridata Web to create and run some comparison jobs and view reports.

In this instance, we are installing the server on an AIX 5.3 Power series machine. So we have downloaded the file V19619-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_aix53_ppc_v3004_003.sh.

We then configure the DISPLAY variable to point to a valid X Windows and run the same ….

dba1:/u01/ofsad2/veridata> ./GoldenGate_Veridata_aix53_ppc_v3004_003.sh
Unpacking JRE …
Starting Installer …

Anúncios

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Esse post foi publicado em GOLDENGATE. Bookmark o link permanente.

Deixe um comentário

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s