我使用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的版本
墨值悬赏

