Goldengate Veridata 11.2 for linux安装配置

goldengate除了monitor可以监控进程状态外，还有一套对比源端和目标端数据一致性的工具，也就是Veridata，下面是测试环境下安装配置过程：
下载server和jagent
[img]http://www.orasql.com/bbs/download/file.php?id=121[/img]
安装jagent
[code][oracle@localhost oggveridata]$ ls -l
total 147780
-rw-r--r-- 1 oracle dba 143131697 Aug 21 17:53 GoldenGate_Veridata_redhatAS40_x86.zip
-rw-r--r-- 1 oracle dba 8031559 Aug 24 09:27 V35569-01.zip

[oracle@localhost oggveridata]$ unzip V35569-01.zip

[oracle@localhost V35569-01]$ mv agent/ ../

[oracle@localhost oggveridata]$ ls -l
total 147788
drwxr-xr-x 6 oracle dba 4096 Aug 24 09:28 agent
-rw-r--r-- 1 oracle dba 143131697 Aug 21 17:53 GoldenGate_Veridata_redhatAS40_x86.zip
drwx------ 2 oracle dba 4096 Aug 24 09:28 V35569-01
-rw-r--r-- 1 oracle dba 8031559 Aug 24 09:27 V35569-01.zip

[oracle@localhost oggveridata]$ cd agent/
[oracle@localhost agent]$ cp agent.properties.sample agent.properties
[oracle@localhost agent]$ vim agent.properties

[oracle@localhost agent]$ cat agent.properties |grep -v ^#|grep -v ^$
server.port=5577
database.url=jdbc:oracle:thin:@localhost:1521:orasql
server.driversLocation = drivers
server.jdbcDriver=ojdbc6.jar
database.transaction.isolation=READ_COMMITTED
[oracle@localhost agent]$ ./agent.sh start
[oracle@localhost agent]$ tail -100 veridata-agent.log
INFO:2013-08-24 09:36:58,745 (main) - Veridata Agent Version 11.2.1.0 OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625 built on Thu, 8 Nov 2012 21:21:26 -0800 [VeriAgentVersion:logVersion, line 33]
INFO:2013-08-24 09:36:59,069 (main) - Veridata Agent starting on localhost.localdomain port 5577 [VeridataAgent:serve, line 141]
INFO:2013-08-24 09:38:38,968 () - Starting session 1 [VeridataAgent$Handler:run, line 313]
INFO:2013-08-24 09:38:38,981 (Session: 1) - Received command: STOP A [VeridataAgent$Handler:getRequest, line 455]
INFO:2013-08-24 09:38:43,689 (main) - Veridata Agent stopped on port 5577 [VeridataAgent:serve, line 175]
INFO:2013-08-24 09:38:43,692 (main) - Shutdown request complete [VeridataAgent:processAgentResponse, line 194]
ERROR:2013-08-24 09:38:43,720 (Session: 1) - IO Error encountered: null [VeridataAgent$Handler:run, line 362]
java.nio.channels.ClosedByInterruptException
at java.nio.channels.spi.AbstractInterruptibleChannel.end(AbstractInterruptibleChannel.java:202)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:473)
at com.goldengate.veridata.agent.VeridataAgent$Handler.getRequest(VeridataAgent.java:511)
at com.goldengate.veridata.agent.VeridataAgent$Handler.run(VeridataAgent.java:326)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724)
INFO:2013-08-24 09:38:43,721 (Session: 1) - Session 1 stopped [VeridataAgent$Handler:run, line 371]
INFO:2013-08-24 09:38:51,707 (main) - Veridata Agent Version 11.2.1.0 OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625 built on Thu, 8 Nov 2012 21:21:26 -0800 [VeriAgentVersion:logVersion, line 33]
INFO:2013-08-24 09:38:51,740 (main) - Veridata Agent starting on localhost.localdomain port 5577 [VeridataAgent:serve, line 141][/code]
安装server
[oracle@localhost oggveridata]$ unzip GoldenGate_Veridata_redhatAS40_x86.zip
切换到图形界面
[oracle@localhost oggveridata]$ ./GoldenGate_Veridata_redhatAS40_x86.sh
[img]http://www.orasql.com/bbs/download/file.php?id=122[/img]
选择安装目录 /u01/ogg/oggveridata
data目录 /u01/ogg/oggveridata/shared/data
[img]http://www.orasql.com/bbs/download/file.php?id=123[/img]
create users 下一步
管理员用户 oggveridata/oracle
数据库类型 oracle
确认oracle目录
现在TNS ORASQL
现在创建新用户
填写一个dba权限的用户及密码，用于创建用户

用户名和密码 oggdata/oracle
表空间,根据自己的环境来设置
开始安装
[img]http://www.orasql.com/bbs/download/file.php?id=124[/img]
安装完成。

http://192.168.3.142:8830/veridata/
[img]http://www.orasql.com/bbs/download/file.php?id=125[/img]
登录后，左侧，connection configuration，右侧，new
输入connection name下一步
[img]http://www.orasql.com/bbs/download/file.php?id=126[/img]
输入信息，并验证。下一步
[img]http://www.orasql.com/bbs/download/file.php?id=127[/img]
完成后，安装同样的方式新建另一个connection
[img]http://www.orasql.com/bbs/download/file.php?id=128[/img]
再回到右侧的group configuration，new
[img]http://www.orasql.com/bbs/download/file.php?id=129[/img]
现在目标端和源端
[img]http://www.orasql.com/bbs/download/file.php?id=130[/img]
完成后进入右侧的edit，点击右边的Go to Compare Pair Configuration …，选择手工mapping
[img]http://www.orasql.com/bbs/download/file.php?id=131[/img]
左右2侧选择对应的表后，右下角Generate Compare Pair.
全部选择完后，点击右上角preview
[img]http://www.orasql.com/bbs/download/file.php?id=132[/img]
sava

保存后即可再 existing compare pairs中看到
[img]http://www.orasql.com/bbs/download/file.php?id=133[/img]
再回到右侧的job configuration，new
输入job名下一步
[img]http://www.orasql.com/bbs/download/file.php?id=134[/img]
[img]http://www.orasql.com/bbs/download/file.php?id=135[/img]
然后回到job，run起来

2个表好像必须有唯一索引，不然会报错。
alter table ogg_obj add constraint ogg_obj_pr primary key(object_id);
alter table ogg_seg add constraint ogg_seg_pr primary key(SEGMENT_NAME,PARTITION_NAME);
[img]http://www.orasql.com/bbs/download/file.php?id=137[/img]
[img]http://www.orasql.com/bbs/download/file.php?id=136[/img]
下次启动Veridata过程如下：
[code]][oracle@localhost bin]$ pwd
/u01/ogg/oggveridata/web/bin

[oracle@localhost bin]$ ./veridata_web.sh start
CATALINA_HOME: /u01/ogg/oggveridata/web
JRE_HOME: /u01/ogg/oggveridata/jre
JAVA_OPTS: -Xms1024m -Xmx1024m -Djava.awt.headless=true -Dveridata.home=/u01/ogg/oggveridata -Dveridata.log.dir=/u01/ogg/oggveridata/shared/logs -Dveridata.log.file=veridataweb.log
Using CATALINA_BASE: /u01/ogg/oggveridata/web
Using CATALINA_HOME: /u01/ogg/oggveridata/web
Using CATALINA_TMPDIR: /u01/ogg/oggveridata/web/temp
Using JRE_HOME: /u01/ogg/oggveridata/jre

[oracle@localhost agent]$ ./agent.sh start
[oracle@localhost agent]$ pwd
/u01/ogg/oggveridata/agent [/code]