Oracle GoldenGate Veridata 比较表报错
本帖最后由 swgsw 于 2015-3-27 17:23 编辑节点一（源）
操作系统版本：hpux 11.31
节点数：4
数据库类型：Rac
DB版本： 10.2.0.5
节点二（目标）
操作系统版本：OEL 6.5 64bit
数据库类型：单实例
DB版本： 11.2.0.4
Oracle GoldenGate Veridata 部署在< 节点二> 上面
版本：11.2.1.0 OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625
比较源和目标的同一张表 报错
两个表均有主键
2015-03-27 03:00:38 Agent message (999): Expected inflated size to be 72 but got 71
Comparison terminated with errors.
望大家指点迷津！
一些疑问
1、安装 Java Agent on a UNIX or Linux System
agent.properties文件内容中
database.url= 这个串填写的是 源端数据库连接串还是 veridata 库的连接串？
跟踪了一下
源端的 veridata-agent.log 在运行 job 的比对时候 有一条关于 Could not set the Session Time Zone to 'GMT+08:00' 的警告。
这个有关系吗？
INFO:2015-03-27 23:53:59,088 (Session: 17) - Driver version: 11.2.0.3.0
INFO:2015-03-27 23:53:59,089 (Session: 17) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options'
INFO:2015-03-27 23:54:00,436 (Session: 17) - Starting source initial compare for BUSINESS.J_GRZHB
INFO:2015-03-27 23:54:03,306 () - Starting session 18
WARN:2015-03-27 23:54:03,379 (Session: 18) - Could not set the Session Time Zone to 'GMT+08:00'
745]
INFO:2015-03-27 23:54:03,380 (Session: 18) - Driver version: 11.2.0.3.0
INFO:2015-03-27 23:54:03,380 (Session: 18) - user 'veridata' connected to 'Oracle Database 10g Enterprise Edition Release 10.2.
0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options'
INFO:2015-03-27 23:54:03,675 (Session: 18) - Session 18 stopped
INFO:2015-03-27 23:54:03,910 (Session: 17) - Session 17 stopped
目标端 veridata-agent.log 在运行 job 后内容如下：
INFO:2015-03-27 23:54:00,207 () - Starting session 29
INFO:2015-03-27 23:54:00,208 (Session: 29) - Driver version: 11.2.0.3.0
INFO:2015-03-27 23:54:00,209 (Session: 29) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options'
INFO:2015-03-27 23:54:00,467 (Session: 29) - Starting target initial compare for BXBIZ.J_GRZHB
INFO:2015-03-27 23:54:03,426 () - Starting session 30
INFO:2015-03-27 23:54:03,460 (Session: 30) - Driver version: 11.2.0.3.0
INFO:2015-03-27 23:54:03,461 (Session: 30) - user 'veridata' connected to 'Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options'
INFO:2015-03-27 23:54:03,696 (Session: 30) - Session 30 stopped
INFO:2015-03-27 23:54:03,959 (Session: 29) - Session 29 stopped
INFO:2015-03-27 23:54:04,107 (Session: 29) - Processed 222912 rows and waited on full queue: 0
页:
[1]