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

标题: OGG-01201 Error reported by MGR : Access denied [打印本页]

作者: 郑全 时间: 2019-5-10 17:30
标题: OGG-01201 Error reported by MGR : Access denied
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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)