报错“OGG-01201：Error reported by MGR : Access denied”

现象

ERROR OGG-01201 Error reported by Manager: Access denied.
OGG-01201：Error reported by MGR : Access denied

CAUSE: Command received from EXTRACT on host [10.40.30.98]:64316 (START REPLICAT DINIT CPU -1 PRI -1 PARAMS ).
目标端mgr主动拒绝源端初始化进程sinit启动replicat初始化进程dinit

解决

查询资料metalink 2098284.1，2095174.1，这是由于GoldenGate 12.2的新特性导致的，要想可以通过远程启动目标端的replicat进程，目标端mgr添加参数：

参考

Doc ID 2098284.1

MGR report shows "WARNING OGG-01877 Missing explicit accessrule for server collector" or "WARNING OGG-00936 Access denied (request from , rule #0)." (Doc ID 2098284.1)
SYMPTOMS
Source extract abends trying to reach the target mgr with following message

eg.,

Oracle GoldenGate Capture for SQL Server
Version 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
Windows x64 (optimized), Microsoft SQL Server on Nov 10 2015 22:49:02

2016-01-06 13:00:49 ERROR OGG-01201 Error reported by MGR : Access denied.
2016-01-06 13:00:49 ERROR OGG-01668 PROCESS ABENDING.

Target MGR report file has following messages

2016-01-06 12:10:32 WARNING OGG-01877 Missing explicit accessrule for server collector.
2016-01-06 12:10:32 INFO OGG-00960 Access granted (rule #8).
2016-01-06 12:10:32 INFO OGG-00983 Manager started (port 7809).
2016-01-06 12:13:14 INFO OGG-00963 Command received from EXTRACT on host :61815 (START REPLICAT CPU -1 PRI -1 PARAMS ).
2016-01-06 12:13:14 WARNING OGG-00936 Access denied (request from , rule #0).

CAUSE
Source and target are in different subnets

SOLUTION
Adding following to target MGR parameter file resolved the issue

ACCESSRULE, PROG *, IPADDR , ALLOW

The would be the ip as seen in the MGR report file.

Doc ID 2095174.1

OGG 12.2: WARNING OGG-00936 Access denied (request from xxxx, rule #0) (Doc ID 2095174.1)

SYMPTOMS
In ogg version 12.2, by default, the manager (and related extract/replicat) cannot be stopped/started remotely.

e.g.,

1. start manager from a shared drive, then try to stop from another server with same shared directory (like different RAC nodes)

2. start direct initial load.

error:

WARNING OGG-00936 Access denied (request from xxxx, rule #0)

ERROR OGG-01201 Error reported by MGR : Access denied.

CAUSE
In ogg version 12.2, by default, the manager (and related extract/replicat) cannot be stopped/started remotely.

SOLUTION
The manager parameter ACCESSRULE can be used to control connection access to the Manager process and the processes under its control.

It can be specified in the manager parameter file (the default location for the Oracle GoldenGate parameter files is the dirprm sub-directory of the Oracle GoldenGate directory)

e.g.,

ACCESSRULE, PROG , IPADDR , ALLOW