ogg进程有如下报错
OGG-03534
Oracle GoldenGate Delivery for Oracle, rods-hod.prm: Invalid character 'a1' at offset 7 for character set CESU-8 was found while performing character validation of source column ACCT_NUM maps target column ACCT_NUM.
OGG-03521
Invalid character for character set UTF-8
此报错与字符集的转换有关,根本的解决办法是保证源端与目标端的数据库字符集一致,但是,ogg的实际应用中存在很多无法一致的情况,有以下两种解决办法:
--在param文件中修改
1. re requested, comment out: SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
2. add: NOCHARSETCONVERSION