Installing and Configuring GoldenGate Veridata Agent

Installing and Configuring GoldenGate Veridata Agent

The GoldenGate Veridata Agents execute the database related requests to compare source and target database rows on behalf of the Veridata Server.

At a minimum we need to install two agents – one to retrieve source rows and one to retrieve target rows from the database.

There are two types of agents – one is the Java based agent and the other is the C-Agent.

The Java Agent connects to the database using JDBC and permits data comparisons in heterogeneous environments. A Java environment JRE/JSDK is required to support this agent and a minimum java version is 1.5

We have copied the V19618-01.zip file from the Metalink E-Deilvery site and unzipped it as shown below.

dba1:/u01/ofsad2> mkdir veriagent
dba1:/u01/ofsad2> mv V19618-01.zip ./veriagentdba1:/u01/ofsad2> cd veriagent
dba1:/u01/ofsad2/veriagent> ls
V19618-01.zip
dba1:/u01/ofsad2/veriagent> unzip *
Archive: V19618-01.zip
creating: agent/
creating: agent/classes/
creating: agent/drivers/
creating: agent/lib/
creating: agent/licenses/
inflating: agent/JavaAgent.jar
inflating: agent/agent.bat
inflating: agent/agent.properties.sample
inflating: agent/classes/log4j.properties
inflating: agent/drivers/gvdb2.jar
inflating: agent/drivers/ojdbc5.jar
inflating: agent/drivers/sqljdbc.jar
inflating: agent/lib/commons-dbcp-1.2.2.jar
inflating: agent/lib/commons-pool-1.3.jar
inflating: agent/lib/log4j-1.2.12.jar
inflating: agent/licenses/Apache-LICENSE-2.0.txt
inflating: agent/licenses/notices.txt
inflating: agent/agent.sh

We then need to copy the agents.properties.sample file and create a file called agents.properties as shown below. Here we are providing the port where the agent will run as well as database connection information like the listener port and SID of the database.

dba1:/u01/ofsad2/veriagent/agent> cp agent.properties.sample agent.properties

# The server.port property is the port where the Veridata agent listens
# for connection requests.
server.port=4000
# Oracle sample database connection URL^M
database.url=jdbc:oracle:thin:@redhat346:1522:gavin
server.driversLocation = drivers
server.jdbcDriver=ojdbc5.jar
database.transaction.isolation=READ_COMMITTED

[oracle@redhat346 agent]$ export JRE_HOME=/u01/oracle/jre1.6.0_18
[oracle@redhat346 agent]$ ./agent.sh start

Installing the C Agent

We first download the file V18202-01.zip from the E-Delivery web site and unpack as shown below. We then will launch the GoldenGate Command Interpretor (GGSCI) from the Veridata Agent directory location. We create the sub directories for the agent and configure a manager process for the Veridata Agent – not to be confused with the Manager process that we configured at the very beginning of the GoldenGate installation.

dba1:/u01/ofsad2/veriagent> unzip V18202-01.zip
Archive: V18202-01.zip
inflating: ggs_veridataAgent_aix53_ppc_ora102_64bit_v3.0.0.2_001.tar

dba1:/u01/ofsad2/veriagent> tar -xvf ggs_veridataAgent_aix53_ppc_ora102_64bit_v3.0.0.2_001.tar
x veridata
x veridata/agent
x veridata/agent/mgr, 1848763 bytes, 3611 tape blocks
x veridata/agent/ggsci, 2283442 bytes, 4460 tape blocks
x veridata/agent/ggMessage.dat, 393280 bytes, 769 tape blocks
x veridata/agent/help.txt, 117942 bytes, 231 tape blocks
x veridata/agent/bcrypt.txt, 1725 bytes, 4 tape blocks
x veridata/agent/libxml2.txt, 1668 bytes, 4 tape blocks
x veridata/agent/zlib.txt, 1476 bytes, 3 tape blocks
x veridata/agent/freeBSD.txt, 1968 bytes, 4 tape blocks
x veridata/agent/notices.txt, 176571 bytes, 345 tape blocks
x veridata/agent/libicui18n38.a, 9302329 bytes, 18169 tape blocks
x veridata/agent/libicuuc38.a, 6302602 bytes, 12310 tape blocks
x veridata/agent/libicudata38.a, 11360230 bytes, 22188 tape blocks
x veridata/agent/veriagt, 4438543 bytes, 8670 tape blocks

dba1:/u01/ofsad2/veriagent> cd veridata
dba1:/u01/ofsad2/veriagent/veridata> ls
agent
dba1:/u01/ofsad2/veriagent/veridata> cd agent
dba1:/u01/ofsad2/veriagent/veridata/agent> ls
bcrypt.txt ggMessage.dat help.txt libicui18n38.a libxml2.txt notices.txt zlib.txt
freeBSD.txt ggsci libicudata38.a libicuuc38.a mgr veriagt

dba1:/u01/ofsad2/veriagent/veridata/agent> ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 003
AIX 5L, ppc, 64bit (optimized), Oracle 10 on Sep 21 2009 00:19:47

Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.

GGSCI (devu026) 1>

GGSCI (devu026) 1> create subdirs

Creating subdirectories under current directory /u01/ofsad2/veriagent/veridata/agent

Parameter files /u01/ofsad2/veriagent/veridata/agent/dirprm: created
Report files /u01/ofsad2/veriagent/veridata/agent/dirrpt: created
Checkpoint files /u01/ofsad2/veriagent/veridata/agent/dirchk: created
Process status files /u01/ofsad2/veriagent/veridata/agent/dirpcs: created
SQL script files /u01/ofsad2/veriagent/veridata/agent/dirsql: created
Database definitions files /u01/ofsad2/veriagent/veridata/agent/dirdef: created
Extract data files /u01/ofsad2/veriagent/veridata/agent/dirdat: created
Temporary files /u01/ofsad2/veriagent/veridata/agent/dirtmp: created
Veridata files /u01/ofsad2/veriagent/veridata/agent/dirver: created
Veridata Lock files /u01/ofsad2/veriagent/veridata/agent/dirver/lock: created
Veridata Out-Of-Sync files /u01/ofsad2/veriagent/veridata/agent/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/ofsad2/veriagent/veridata/agent/dirver/oosxml: created
Veridata Parameter files /u01/ofsad2/veriagent/veridata/agent/dirver/params: created
Veridata Report files /u01/ofsad2/veriagent/veridata/agent/dirver/report: created
Veridata Status files /u01/ofsad2/veriagent/veridata/agent/dirver/status: created
Veridata Trace files /u01/ofsad2/veriagent/veridata/agent/dirver/trace: created
Stdout files /u01/ofsad2/veriagent/veridata/agent/dirout: created

GGSCI (devu026) 2> edit params mgr

“/u01/ofsad2/veriagent/veridata/agent/dirprm/mgr.prm” [New file]
PORT 7807
~

GGSCI (devu026) 3> start manager

Manager started.

GGSCI (devu026) 4> info manager

Manager is running (IP port devu026.7807).

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