OGG异构数据字符集转换问题

利用goldengate同步oracle数据到mysql时， rep进程报错，报错内容如下：

length becomes zero when converting from source column res_date character set UTF-16 to target character set zhs16gbk

ERROR   OGG-03517  Oracle GoldenGate Delivery for Oracle, test.prm:  Conversion from character set UTF-16 of source column description to character set zhs16gbk of target column DESCRIPTION failed because the source column contains a character that is not available in the target character set.
ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, test.prm:  PROCESS ABENDING.

解决方法：
在参数文件中增加以下参数
REPLACEBADCHAR SKIP
经过测试两边的数据一致

用goldengate同步oracle数据到mysql,由于一个字段某行数据的字段集的原因导致 replicat进程报 OGG-03517错
OGG-03517  Conversion from character set zhs16gbk of source column LPL_MERCHANT_NAME to character set UTF-8 of target column lpl_merchant_name failed 
because the source column contains a character that is not available in the target character set

解决方法：在参数文件中增加以下参数
SOURCECHARSET PASSTHRU



PS：
passthru  #透传模式，源表和目标数据库表完全一样,源表与目标表不一致的时候需要用NoPassThru
assumetargetdefs  #源数据表与目标数据库同步的表定义相同时候用此参数,不可以与sourcedefs参数文件同用