Install Goldengate Veridata

最新推荐文章于 2021-04-04 08:03:48 发布

原创最新推荐文章于 2021-04-04 08:03:48 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#goldengate #veridata #compare

GoldenGate 专栏收录该内容

29 篇文章

订阅专栏

本文介绍Oracle GoldenGate Veridata的安装过程及基本配置方法，包括搭建VeridataServer与agent环境、配置参数文件及JRE，通过图形界面安装VeridataServer并设置对比数据一致性任务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Goldengate Veridata 是oracle一款对比数据一致性的工具，支持Oracle、Terdata、Sql Server等数据库。下面开始安装：

整体架构：

安装环境：
这里我将Veridata Server直接安装到agent1上面的：

Agent1：
name：zbdba1
OS:redhat 6.3
IP:192.168.56.60

Agent2:
name：zbdba2
OS:redhat 6.3
IP:192.168.56.61

在agent1和agent2上面安装veridata agent：
在安装前确定数据库已经开启，监听已经开启
解压：
[root@zbdba1 database]# unzip V35569-01.zip
进入agent目录，配置参数文件：

cp agent.properties.sample agent.properties
[root@zbdba1 agent]# cat agent.properties
server.port=1261
database.url=jdbc:oracle:thin:@localhost:1521:orcl11g
server.driversLocation = drivers
server.jdbcDriver=ojdbc6.jar
database.transaction.isolation=READ_COMMITTED

配置JRE：

[root@zbdba1 agent]# cat /root/.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export JAVA_HOME1=/jre1.7.0_75/bin
export JAVA_HOME=/jre1.7.0_75/
export PATH=$PATH:$JAVA_HOME:$JAVA_HOME1

启动agent
[root@zbdba1 agent]# ./agent.sh start
监控日志文件：
[root@zbdba1 ~]# tail -100f /database/agent/veridata-agent.log

[root@zbdba1 agent]# ps -ef |grep agent
root      2217  2198  0 22:11 pts/3    00:00:00 tail -100f /database/agent/veridata-agent.log
root      2546     1  0 22:36 pts/0    00:00:03 /jre1.7.0_75//bin/java -Xmx1024M -Xms1024M -Djava.awt.headless=true -XX:+UseParallelGC -jar /database/agent/JavaAgent.jar
root      2760  1491  0 23:05 pts/0    00:00:00 grep agent

在agent2上面执行一样的操作。

在agent1上安装veridata server：

[root@zbdba1 database]# unzip V35572-01.zip
[root@zbdba1 database]# export DISPLAY=192.168.56.1:0.0
[root@zbdba1 database]# ./GoldenGate_Veridata_redhatAS40_x64.sh
根据图形界面一步一步安装即可

安装完成查看veridata server进程是否启动：

[root@zbdba1 database]# ps -ef |grep veridata
root      1770  1750  0 21:27 pts/2    00:00:00 tail -1000f veridataweb.log
root      1852     1  0 21:29 pts/1    00:00:35 /opt/Oracle_GoldenGate_Veridata/jre/bin/java -Xms1024m -Xmx1024m -Djava.awt.headless=true -Dveridata.home=/opt/Oracle_GoldenGate_Veridata -Dveridata.log.dir=/opt/Oracle_GoldenGate_Veridata/shared/logs -Dveridata.log.file=veridataweb.log -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/Oracle_GoldenGate_Veridata/web/conf/logging.properties -Djava.endorsed.dirs=/opt/Oracle_GoldenGate_Veridata/web/common/endorsed -classpath :/opt/Oracle_GoldenGate_Veridata/web/bin/bootstrap.jar:/opt/Oracle_GoldenGate_Veridata/web/bin/commons-logging-api.jar -Dcatalina.base=/opt/Oracle_GoldenGate_Veridata/web -Dcatalina.home=/opt/Oracle_GoldenGate_Veridata/web -Djava.io.tmpdir=/opt/Oracle_GoldenGate_Veridata/web/temp org.apache.catalina.startup.Bootstrap start
root      2217  2198  0 22:11 pts/3    00:00:00 tail -100f /database/agent/veridata-agent.log
root      2778  1491  0 23:07 pts/0    00:00:00 grep veridata

查看日志情况：

[root@zbdba1 logs]# tail -100f /opt/Oracle_GoldenGate_Veridata/shared/logs/veridataweb.log
INFO (2015-03-08 21:27:09,179)  [AbstractEntityManagerFactoryBean:destroy, line 387] - Closing JPA EntityManagerFactory for persistence unit 'VeridataServer'
INFO (2015-03-08 21:29:22,188)  [ContextLoader:initWebApplicationContext, line 182] - Root WebApplicationContext: initialization started
INFO (2015-03-08 21:29:22,279)  [AbstractApplicationContext:prepareRefresh, line 447] - Refreshing Root WebApplicationContext: startup date [Sun Mar 08 21:29:22 EDT 2015]; root of context hierarchy
INFO (2015-03-08 21:29:22,367)  [XmlBeanDefinitionReader:loadBeanDefinitions, line 315] - Loading XML bean definitions from class path resource [context-dao.xml]
INFO (2015-03-08 21:29:23,568)  [XmlBeanDefinitionReader:loadBeanDefinitions, line 315] - Loading XML bean definitions from class path resource [context-bu.xml]
INFO (2015-03-08 21:29:23,915)  [VeridataConfig:<init>, line 99] - No override /veridata.cfg config file
INFO (2015-03-08 21:29:23,946)  [VeridataConfig:<init>, line 124] - veridata.cfg Location: /opt/Oracle_GoldenGate_Veridata/web/webapps/veridata/WEB-INF/classes/../../../../../shared/conf/veridata.cfg
INFO (2015-03-08 21:29:24,281)  [DefaultListableBeanFactory:preInstantiateSingletons, line 532] - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5f4275d4: defining beans [serverPassword,repositoryPassword,connectionWallet,agentPoolManager,comparisonReportsDAO,veridataConfig,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,com.goldengate.veridata.util.VeridataPropertyConfigurer#0,myEmf,veridataDataSource,myTxManager,connectionDAO,jobDAO,profileDAO,finishedStatsDAO,groupDAO,comparePairDAO,userPreferencesDAO,favoriteDAO,performanceStatsDAO,veridataControlDAO,adminDAO,connectionManager,jobManager,groupManager,comparePairManager,profileManager,userPreferencesManager,favoriteTaskManager,runManager,finishedJobsManager,metaLookupManager,oosReportsManager,performanceStatsManager,veridataControlManager,comparisonReportsManager]; root of factory hierarchy
INFO (2015-03-08 21:29:26,438)  [LocalContainerEntityManagerFactoryBean:createNativeEntityManagerFactory, line 221] - Building JPA container EntityManagerFactory for persistence unit 'VeridataServer'
INFO (2015-03-08 21:29:28,118)  [SorterManager:<init>, line 73] - Total sort memory is 766m
INFO (2015-03-08 21:29:28,119)  [SorterManager:<init>, line 84] - Maximum comparison memory is 100m
INFO (2015-03-08 21:29:28,119)  [SorterManager:<init>, line 89] - The maximum number of concurrent writes is 4
INFO (2015-03-08 21:29:28,120)  [SorterManager:<init>, line 92] - The maximum number of concurrent reads is 4
INFO (2015-03-08 21:29:28,203)  [ContextLoader:initWebApplicationContext, line 202] - Root WebApplicationContext: initialization completed in 6012 ms
INFO (2015-03-08 21:29:28,728)  [VersionBean:<init>, line 40] - loading jar:file:/opt/Oracle_GoldenGate_Veridata/web/webapps/veridata/WEB-INF/lib/vericom.jar!/veridata-version.properties
INFO (2015-03-08 21:29:28,728)  [VeridataContextListener:contextInitialized, line 96] - Oracle GoldenGate Veridata Server - Version 11.2.1.0  OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625
INFO (2015-03-08 21:29:28,907)  [VeridataSessionLogger:log, line 97] - EclipseLink, version: Eclipse Persistence Services - 2.1.2.v20101206-r8635
INFO (2015-03-08 21:29:37,094)  [VeridataSessionLogger:log, line 97] - file:/opt/Oracle_GoldenGate_Veridata/web/webapps/veridata/WEB-INF/lib/veridata-server.jar_VeridataServer login successful

使用浏览器登入veridata
http://192.168.56.60:8830/veridata/

输入用户名和密码登录

点击右侧Connection Configuration
new

新建完成后，点击右侧group Configuration
new

新建完成后，点击edit，点击右侧Go to Compare Pair Configuration .
按实际情况选择表进行对比

完成之后，点击job Configuration
new

run job

查看report可以知道具体错误

以后启动veridata的步骤：

启动agent：
[root@zbdba1 agent]# ./agent.sh start
[root@zbdba2 agent]# ./agent.sh start
启动server：
[root@zbdba1 bin]# pwd
/opt/Oracle_GoldenGate_Veridata/web/bin
[root@zbdba1 bin]# ./startup.sh 
CATALINA_HOME: /opt/Oracle_GoldenGate_Veridata/web
JRE_HOME: /opt/Oracle_GoldenGate_Veridata/jre
JAVA_OPTS: -Xms1024m -Xmx1024m -Djava.awt.headless=true -Dveridata.home=/opt/Oracle_GoldenGate_Veridata -Dveridata.log.dir=/opt/Oracle_GoldenGate_Veridata/shared/logs -Dveridata.log.file=veridataweb.log
Using CATALINA_BASE:   /opt/Oracle_GoldenGate_Veridata/web
Using CATALINA_HOME:   /opt/Oracle_GoldenGate_Veridata/web
Using CATALINA_TMPDIR: /opt/Oracle_GoldenGate_Veridata/web/temp
Using JRE_HOME:       /opt/Oracle_GoldenGate_Veridata/jre