重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1607|回复: 0

[原创] OGG-01201 Error reported by MGR : Access denied

[复制链接]
发表于 2019-5-10 17:30:14 | 显示全部楼层 |阅读模式
1.现场环境:
     源端:192.168.133.136 初始抽取进程:einit_1
     目标端:192.168.133.137 初始复制进程:rinit_1
     数据库版本:11.2.0.4
     ogg 版本:18.1

2.问题现象:
  我们使用 ogg的初始化进程进行数据初始化时,一启动初始化进程,就停止了,
  如下:

GGSCI (dbserver) 12> start eini_1
Sending START request to MANAGER ...
EXTRACT EINI_1 starting

GGSCI (dbserver) 7> info *,tasks
EXTRACT    EINI_1    Last Started 2019-05-10 16:30   Status STOPPED
Checkpoint Lag       Not Available
Log Read Checkpoint  Table SCOTT.EMP_OGG
                     2019-05-10 16:30:38  Record 8
Task                 SOURCEISTABLE


查看看源库日志:
2019-05-10T16:22:44.774+0800  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Using the following key columns for source table SCOTT.EMP_OGG: EMPNO.
2019-05-10T16:22:44.784+0800  WARNING OGG-06439  Oracle GoldenGate Capture for Oracle, eini_1.prm:  No unique key is defined for table DEPT_OGG. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-05-10T16:22:44.785+0800  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Using the following key columns for source table SCOTT.DEPT_OGG: DEPTNO, DNAME, LOC.
2019-05-10T16:22:44.785+0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT EINI_1 started.
2019-05-10T16:22:44.788+0800  ERROR   OGG-01201  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Error reported by MGR : Access denied.
2019-05-10T16:22:44.789+0800  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, eini_1.prm:  PROCESS ABENDING.


看目标库日志:
2019-05-10T16:22:44.795+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host [192.168.133.136]:20409 (START REPLICAT RINI_1
CPU -1 PRI -1 PARAMS ).
2019-05-10T16:22:44.796+0800  WARNING OGG-00936  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access denied (request from 192.168.133.136, rule #0).


3.问题分析:
   看来是目标端mgr主动拒绝了源端extract启动replicat进程repinit

4.问题原因
   由于GoldenGate 12.2开始的新特性导致的,要想通过远程启动目标端的replicat进程,需要在目标端mgr中增加参数如下:
[color=rgba(0, 0, 0, 0.75)]
ACCESSRULE, PROG *, IPADDR xxx.x.x.x, ALLOW
5.问题解决
   在目标端mgr参数中增加以下行:
  GGSCI (server2 as ogg@orcl) 65> view param mgr
  port 7809
  ACCESSRULE, PROG *, IPADDR 192.168.133.136, ALLOW

  再次重启源端的初始抽取进程,自动启动目标端的初始复制进程。复制完成后,初始抽取复制进程自动停止。

附部分日志:

。。。
2019-05-10T16:40:05.170+0800  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start eini_1.
2019-05-10T16:40:05.172+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.133.136]:30413 (START EXTRACT EINI_1 ).
2019-05-10T16:40:05.175+0800  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EINI_1 starting.
2019-05-10T16:40:05.400+0800  INFO    OGG-01017  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
2019-05-10T16:40:05.400+0800  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT EINI_1 starting.
2019-05-10T16:40:05.400+0800  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Operating system character set identified as UTF-8.
2019-05-10T16:40:05.400+0800  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, eini_1.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2019-05-10T16:40:05.400+0800  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.US7ASCII.
2019-05-10T16:40:05.400+0800  INFO    OGG-01360  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT is running in Initial Load mode.
2019-05-10T16:40:05.400+0800  INFO    OGG-01889  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Flush size (max message size) is set to 27,985.
2019-05-10T16:40:05.569+0800  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, eini_1.prm:  filecaching started: thread ID: 139826315118336.
2019-05-10T16:40:05.582+0800  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Virtual Memory Facilities for: COM
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /u01/app/oracle/product/11.2.0/ogg/dirtmp.
2019-05-10T16:40:05.624+0800  WARNING OGG-06439  Oracle GoldenGate Capture for Oracle, eini_1.prm:  No unique key is defined for table DEPT_OGG. All viable columns will be used to r
epresent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-05-10T16:40:05.624+0800  INFO    OGG-06509  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Using the following key columns for source table SCOTT.DEPT_OGG: DEPTNO, DNAME, L
OC.
2019-05-10T16:40:05.624+0800  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT EINI_1 started.
2019-05-10T16:40:11.305+0800  INFO    OGG-02911  Oracle GoldenGate Capture for Oracle, eini_1.prm:  Processing table SCOTT.DEPT_OGG.
2019-05-10T16:40:13.483+0800  INFO    OGG-00991  Oracle GoldenGate Capture for Oracle, eini_1.prm:  EXTRACT EINI_1 stopped normally.


目标端:
2019-05-10T16:40:05.628+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host [192.168.133.136]:21257 (START REPLICAT RINI_1 CPU -1 PRI -1 PARAMS ).
2019-05-10T16:40:05.629+0800  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).
2019-05-10T16:40:05.771+0800  INFO    OGG-01888  Oracle GoldenGate Delivery for Oracle:  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-05-10T16:40:05.857+0800  INFO    OGG-01025  Oracle GoldenGate Delivery for Oracle:  REPLICAT task started by manager (port 7819).
2019-05-10T16:40:05.877+0800  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from RMTTASK on host [::1]:51715 (REPORT 14530 7819).
2019-05-10T16:40:05.877+0800  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).
2019-05-10T16:40:05.877+0800  INFO    OGG-00973  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started replicat task process (Port 7819).
2019-05-10T16:40:10.918+0800  INFO    OGG-01229  Oracle GoldenGate Delivery for Oracle:  Connected to ::ffff:192.168.133.136:36911.
2019-05-10T16:40:10.919+0800  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle:  REPLICAT RINI_1 starting.
2019-05-10T16:40:10.921+0800  WARNING OGG-02904  Oracle GoldenGate Delivery for Oracle:  Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
2019-05-10T16:40:10.922+0800  INFO    OGG-03059  Oracle GoldenGate Delivery for Oracle:  Operating system character set identified as UTF-8.
2019-05-10T16:40:10.922+0800  INFO    OGG-02695  Oracle GoldenGate Delivery for Oracle:  ANSI SQL parameter syntax is used for parameter parsing.
2019-05-10T16:40:10.922+0800  INFO    OGG-02095  Oracle GoldenGate Delivery for Oracle:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.US7ASCII.
2019-05-10T16:40:10.934+0800  INFO    OGG-01360  Oracle GoldenGate Delivery for Oracle:  REPLICAT is running in Remote Task mode.
2019-05-10T16:40:11.247+0800  INFO    OGG-06451  Oracle GoldenGate Delivery for Oracle:  Triggers will be suppressed by default.
2019-05-10T16:40:11.286+0800  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle:  Virtual Memory Facilities for: COM
                                  anon alloc: mmap(MAP_ANON)  anon free: munmap
                                  file alloc: mmap(MAP_SHARED)  file free: munmap
                                  target directories:
                                  /u01/app/oracle/product/11.2.0/ogg/dirtmp.
2019-05-10T16:40:11.294+0800  INFO    OGG-06604  Oracle GoldenGate Delivery for Oracle:  Database ORCL CPU info: CPU Count 4, CPU Core Count 4, CPU Socket Count 2.
2019-05-10T16:40:11.305+0800  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle:  REPLICAT RINI_1 started.
2019-05-10T16:40:11.306+0800  INFO    OGG-03522  Oracle GoldenGate Delivery for Oracle:  Setting session time zone to source database time zone 'GMT'.
2019-05-10T16:40:11.363+0800  WARNING OGG-02760  Oracle GoldenGate Delivery for Oracle:  ASSUMETARGETDEFS is ignored because trail file  contains table definitions.
2019-05-10T16:40:11.363+0800  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle:  Wildcard MAP resolved (entry scott.*): MAP "SCOTT"."DEPT_OGG", TARGET scott."DEPT_OGG".
2019-05-10T16:40:13.470+0800  WARNING OGG-06439  Oracle GoldenGate Delivery for Oracle:  No unique key is defined for table DEPT_OGG. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-05-10T16:40:13.470+0800  INFO    OGG-02756  Oracle GoldenGate Delivery for Oracle:  The definition for table SCOTT.DEPT_OGG is obtained from the trail file.
2019-05-10T16:40:13.470+0800  INFO    OGG-06511  Oracle GoldenGate Delivery for Oracle:  Using following columns in default map by name: DEPTNO, DNAME, LOC.
2019-05-10T16:40:13.470+0800  INFO    OGG-06510  Oracle GoldenGate Delivery for Oracle:  Using the following key columns for target table SCOTT.DEPT_OGG: DEPTNO, DNAME, LOC.
2019-05-10T16:40:18.482+0800  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle: REPLICAT RINI_1 stopped normally.








回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2022-1-20 21:56 , Processed in 0.072957 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表