ogg oracle hadoop,oracle通过OGG FOR BIGDATA实时同步到greenplum问题

源端:

oracle版本: 12.2.0.1

OGG版本:123012

抽取进程extn:

EXTRACT extn

DYNAMICRESOLUTION

USERID C##GGADMIN,PASSWORD ggadmin

DISCARDFILE ./dirrpt/extn.dsc,APPEND,MEGABYTES 1024

EXTTRAIL ./dirdat/na

sourceCatalog pdb_op

table ccps.userinf;

投递进程dpen:

EXTRACT dpen

PASSTHRU

RMTHOST 192.168.11.210,MGRPORT 7809 , COMPRESS

RMTTRAIL ./dirdat/na

table pdb_op.ccps.userinf;

目标端:

greenplum: 5.0

ogg:ogg bigdata 123211

复制进程repn:

replicat repn

TARGETDB LIBFILE libggjava.so SET property=/home/gpadmin/ogg/dirprm/jdbc_datadirect_greenplum.props

GROUPTRANSOPS 1000

MAP pdb_op.ccps.*,TARGET devin.*;

jdbc_datadirect_greenplum.props:

#Configuration to use Oracle branded Datadirect JDBC driver.

gg.handlerlist=jdbcwriter

gg.handler.jdbcwriter.type=jdbc

##Handler properties for Greenplum database target.

gg.handler.jdbcwriter.DriverClass=com.pivotal.jdbc.GreenplumDriver

gg.handler.jdbcwriter.connectionURL=jdbc

4f06a01a81d5603cca001c0e92e5ebda.gifivotal:greenplum://192.168.11.210:2345;DatabaseName=devin

#Example: jdbc:weblogic:greenplum://corpserver1:5432;DatabaseName=ACCTNG";

gg.handler.jdbcwriter.userName=devin

gg.handler.jdbcwriter.password=devin

#Contact Oracle support to get the fmwgenerictoken*.jar and wlgreenplum*.jar files.

gg.classpath=/home/gpadmin/ogg/fmwgenerictoken.jar:/home/gpadmin/ogg/greenplum.jar

goldengate.userexit.writers=javawriter

javawriter.stats.display=TRUE

javawriter.stats.full=TRUE

gg.log=log4j

gg.log.level=INFO

gg.report.time=30sec

javawriter.bootoptions=-Xmx512m -Xms32m -Djava.class.path=.:/home/gpadmin/ogg/ggjava/ggjava.jar:/home/gpadmin/ogg/dirprm:/home/gpadmin/ogg/fmwgenerictoken.jar:/home/gpadmin/ogg/greenplum.jar

测试数据同步的时候报错error mapping

2019-03-21T14:56:24.677+0800  INFO    OGG-02756  Oracle GoldenGate Delivery, repn.prm:  The definition for table PDB_OP.CCPS.USERINF is obtained from the trail file.

2019-03-21T14:56:24.677+0800  INFO    OGG-06511  Oracle GoldenGate Delivery, repn.prm:  Using following columns in default map by name: ID, NAME.

2019-03-21T14:56:24.677+0800  INFO    OGG-06510  Oracle GoldenGate Delivery, repn.prm:  Using the following key columns for target table devin.USERINF: ID.

2019-03-21T14:56:24.752+0800  WARNING OGG-01004  Oracle GoldenGate Delivery, repn.prm:  Aborted grouped transaction on devin.USERINF, Database error 0 ().

2019-03-21T14:56:24.752+0800  WARNING OGG-01003  Oracle GoldenGate Delivery, repn.prm:  Repositioning to rba 1863 in seqno 0.

2019-03-21T14:56:24.752+0800  WARNING OGG-01151  Oracle GoldenGate Delivery, repn.prm:  Error mapping from PDB_OP.CCPS.USERINF to devin.USERINF.

2019-03-21T14:56:24.752+0800  ERROR   OGG-01296  Oracle GoldenGate Delivery, repn.prm:  Error mapping from PDB_OP.CCPS.USERINF to devin.USERINF.

2019-03-21T14:56:24.752+0800  ERROR   OGG-01668  Oracle GoldenGate Delivery, repn.prm:  PROCESS ABENDING.

网上基本搜不到oracle通过ogg bigdata同步到greenplum的文档,求指点

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值