swgsw 发表于 2015-3-27 17:18:48

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.

望大家指点迷津!

swgsw 发表于 2015-3-27 19:12:33

一些疑问

1、安装 Java Agent on a UNIX or Linux System

agent.properties文件内容中

database.url=  这个串填写的是 源端数据库连接串还是 veridata 库的连接串?

swgsw 发表于 2015-3-28 01:07:13

跟踪了一下

源端的 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]
查看完整版本: Oracle GoldenGate Veridata 比较表报错