oracle端作为源端,,kafka端作为目标段,我想进行数据的初始化
mgr进程和其余复制进程均正常,这里只贴出初始化进程
目标端的初始化配置如下
view param extinit
extract extinit
userid ogg, password ogg
rmthost 172.16.66.152, mgrport 7809
rmttask replicat, group poraini
table test.t1;
add extract extinit,sourceistable
目标端的初始化进程如下:
view param poraini
replicat poraini
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/poraini.dsc, APPEND, MEGABYTES 100
map test.t1, target test.t1;
add replicat poraini, specialrun
目前这两个进程无法启动
源端的错误日志如下:
2019-04-25T21:35:29.560+0800 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host [172.16.68.122]:38935 (START EXTRACT EXTINIT ).
2019-04-25T21:35:29.560+0800 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXTINIT starting.
2019-04-25T21:35:30.920+0800 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, extinit.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2019-04-25T21:35:30.928+0800 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, extinit.prm: EXTRACT EXTINIT starting.
2019-04-25T21:35:30.928+0800 INFO OGG-03059 Oracle GoldenGate Capture for Oracle, extinit.prm: Operating system character set identified as UTF-8.
2019-04-25T21:35:30.928+0800 INFO OGG-02695 Oracle GoldenGate Capture for Oracle, extinit.prm: ANSI SQL parameter syntax is used for parameter parsing.
2019-04-25T21:35:30.939+0800 INFO OGG-01360 Oracle GoldenGate Capture for Oracle, extinit.prm: EXTRACT is running in Initial Load mode.
2019-04-25T21:35:32.791+0800 INFO OGG-01889 Oracle GoldenGate Capture for Oracle, extinit.prm: Flush size (max message size) is set to 27,985.
2019-04-25T21:35:34.708+0800 INFO OGG-03522 Oracle GoldenGate Capture for Oracle, extinit.prm: Setting session time zone to source database time zone '+08:00'.
2019-04-25T21:35:34.745+0800 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, extinit.prm: filecaching started: thread ID: 139673867343616.
2019-04-25T21:35:34.810+0800 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, extinit.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/data/ogg/dirtmp.
2019-04-25T21:35:35.221+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, extinit.prm: Using the following key columns for source table TEST.T1: OBJECT_ID.
2019-04-25T21:35:35.221+0800 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, extinit.prm: EXTRACT EXTINIT started.
2019-04-25T21:35:45.563+0800 WARNING OGG-01194 Oracle GoldenGate Capture for Oracle, extinit.prm: EXTRACT task poraini abended : Unable to open file "dirprm/poraini.properties" (error 2, No such file or directory).
2019-04-25T21:35:45.571+0800 ERROR OGG-01203 Oracle GoldenGate Capture for Oracle, extinit.prm: EXTRACT abending.
2019-04-25T21:35:45.597+0800 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extinit.prm: PROCESS ABENDING.
目标端的错误如下:
2019-04-25T21:28:37.809+0800 INFO OGG-06510 Oracle GoldenGate Delivery: Using the following key columns for target table test.t1: OBJECT_ID.
2019-04-25T21:28:44.447+0800 INFO OGG-00994 Oracle GoldenGate Delivery: REPLICAT poraini stopped normally.
2019-04-25T21:36:07.560+0800 INFO OGG-00963 Oracle GoldenGate Manager, mgr.prm: Command received from EXTRACT on host [172.16.68.122]:28288 (START REPLICAT poraini CPU -1 PRI -1 PARAMS ).
2019-04-25T21:36:07.560+0800 INFO OGG-00960 Oracle GoldenGate Manager, mgr.prm: Access granted (rule #1).
2019-04-25T21:36:07.608+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-04-25T21:36:07.608+0800 INFO OGG-01025 Oracle GoldenGate Delivery: REPLICAT task started by manager (port 7820).
2019-04-25T21:36:07.611+0800 INFO OGG-00963 Oracle GoldenGate Manager, mgr.prm: Command received from RMTTASK on host [::1]:36527 (REPORT 30360 7820).
2019-04-25T21:36:07.611+0800 INFO OGG-00960 Oracle GoldenGate Manager, mgr.prm: Access granted (rule #1).
2019-04-25T21:36:07.611+0800 INFO OGG-00973 Oracle GoldenGate Manager, mgr.prm: Manager started replicat task process (Port 7820).
2019-04-25T21:36:17.674+0800 INFO OGG-01229 Oracle GoldenGate Delivery: Connected to ::ffff:172.16.68.122:16034.
2019-04-25T21:36:17.684+0800 INFO OGG-00995 Oracle GoldenGate Delivery: REPLICAT poraini starting.
2019-04-25T21:36:17.684+0800 INFO OGG-03059 Oracle GoldenGate Delivery: Operating system character set identified as UTF-8.
2019-04-25T21:36:17.684+0800 INFO OGG-02695 Oracle GoldenGate Delivery: ANSI SQL parameter syntax is used for parameter parsing.
2019-04-25T21:36:17.696+0800 INFO OGG-01360 Oracle GoldenGate Delivery: REPLICAT is running in Remote Task mode.
2019-04-25T21:36:17.817+0800 ERROR OGG-01091 Oracle GoldenGate Delivery: Unable to open file "dirprm/poraini.properties" (error 2, No such file or directory).
2019-04-25T21:36:22.819+0800 ERROR OGG-01668 Oracle GoldenGate Delivery: PROCESS ABENDING.
我的问题是:dirprm/poraini.properties这个文件是如何生成的
墨值悬赏

评论
