源端:
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
ivotal: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的文档,求指点