暂无图片
分享
看戏
2019-04-25
ogg同步到kafka初始化数据的问题

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这个文件是如何生成的

收藏
分享
2条回答
默认
最新
看戏

extinit为源端初始化进程,打错了

暂无图片 评论
暂无图片 有用 0
看戏
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏