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) [Abstra