ITPub博客

首页 > Linux操作系统 > Linux操作系统 > GoldenGate MSSQL Oracle的主键问题导致的错误

GoldenGate MSSQL Oracle的主键问题导致的错误

原创 Linux操作系统 作者:abstractcyj 时间:2013-07-16 11:24:19 0 删除 编辑
2013-07-16 11:14:01  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  No unique key is defined for table 'EMP'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2013-07-16 11:14:01  WARNING OGG-03504  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  NLS_LANG character set US7ASCII on the target is different from the source database character set ZHS16GBK. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2013-07-16 11:14:01  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Command received from GGSCI: STATS.
2013-07-16 11:18:31  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Command received from GGSCI: STATS.
2013-07-16 11:18:31  WARNING OGG-01431  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Aborted grouped transaction on 'GGS.EMP', Mapping error.
2013-07-16 11:18:31  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Repositioning to rba 1044 in seqno 0.
2013-07-16 11:18:31  WARNING OGG-01151  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Error mapping from dbo.emp to GGS.EMP.
2013-07-16 11:18:31  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Repositioning to rba 1044 in seqno 0.
2013-07-16 11:18:31  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  Error mapping from dbo.emp to GGS.EMP.
2013-07-16 11:18:31  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, MSREP.prm:  PROCESS ABENDING.

采取的解决方式也很简单,因MSSQL的emp表已经有了主键,所以在oracle数据库里定义好主键就解决了问题

也可以采用KEYCOLS参数定义target的主键

REPLICAT MSREP
USERID ggs@orcl, PASSWORD ggs
SOURCEDEFS dirdef/emp.def
MAP dbo.emp, TARGET ggs.emp,keycols(id);



来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-766373/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    829390