暂无图片
使用ogg的initload功能对问题
我来答
分享
看戏
2019-11-08
使用ogg的initload功能对问题

我使用ogg从oracle同步数据到kafka,数据初始化采用的是initload,目前看上去是抽取不到数据,我的源端配置如下:
edit param extinit1

extract extinit1
userid ogg,password AACAAAAAAAAAAAJAMHAENCUIYDIIGISFRCDDPELASDJETACE, ENCRYPTKEY DEFAULT
tranlogoptions dblogreader
rmthost 192.168.111.111, mgrport 7809
rmttask replicat, group poraini1
table test.test;

add extract extinit1,sourceistable

目标端配置如下:
edit param poraini1

replicat poraini1
ASSUMETARGETDEFS
TARGETDB LIBFILE libggjava.so SET property=dirprm/kafka01.props
REPORTCOUNT EVERY 1 MINUTES, RATE
map test.test, target test.test;

add replicat poraini1, specialrun

日志均无报错,我的源端日志看起来是执行不到下一步
2019-11-08 13:25:15 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.

2019-11-08 13:25:15 INFO OGG-02696 NON-ANSI SQL parameter syntax is used for parameter parsing.
extract extinit1
userid ogg,password ************************************************, ENCRYPTKEY DEFAULT
rmthost 192.168.111.111, mgrport 7809
rmttask replicat, group poraini1
table test.test;
Using the following key columns for source table test.test: test1, test2.

2019-11-08 13:25:15 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/home/oracle/ogg/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 64G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G

Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Database Language and Character Set:
NLS_LANG = “AMERICAN_AMERICA.AL32UTF8”
NLS_LANGUAGE = “AMERICAN”
NLS_TERRITORY = “AMERICA”
NLS_CHARACTERSET = “AL32UTF8”

目标端日志:
2019-11-08T12:52:47.386+0800 INFO OGG-00963 Oracle GoldenGate Manager, mgr.prm: Command received from EXTRACT on host [网闸ip]:11437 (START REPLICAT PORAINI1 CPU -1 PRI -1 PARAMS ).
2019-11-08T12:52:47.386+0800 INFO OGG-00960 Oracle GoldenGate Manager, mgr.prm: Access granted (rule #3).
2019-11-08T12:52:47.681+0800 INFO OGG-01888 Oracle GoldenGate Delivery: TCP network is configured as

                                            OS DEFAULT          SPECIFIED           ACTUAL VALUE        
                                   IP_DSCP    0                   N/A                 0                 
                                    IP_TOS    0                   N/A                 0                 
                               TCP_NODELAY    0                   N/A                 0                 
                              TCP_QUICKACK    1                   N/A                 1                 
                                  TCP_CORK    0                   N/A                 0                 
                                 SO_SNDBUF    8192                N/A                 8192              
                                 SO_RCVBUF    43690               N/A                 43690.

2019-11-08T12:52:47.681+0800 INFO OGG-01025 Oracle GoldenGate Delivery: REPLICAT task started by manager (port 7822).
2019-11-08T12:52:47.677+0800 INFO OGG-00963 Oracle GoldenGate Manager, mgr.prm: Command received from RMTTASK on host [127.0.0.1]:38646 (REPORT 15776 7822).
2019-11-08T12:52:47.677+0800 INFO OGG-00960 Oracle GoldenGate Manager, mgr.prm: Access granted (rule #1).
2019-11-08T12:52:47.677+0800 INFO OGG-00973 Oracle GoldenGate Manager, mgr.prm: Manager started replicat task process (Port 7822).

请问大佬们,我这个是什么问题,环境就是rac,用的asm,11g的版本

我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏