Friday 27 May 2016

ERROR OGG-01201 Error reported by MGR : Access denied

Today i faced an issue in goldengate

2016-05-27 15:55:42  ERROR   OGG-01201  Error reported by MGR : Access denied.

2016-05-27 15:55:42  ERROR   OGG-01668  PROCESS ABENDING.


What happens in Oracle GoldenGate 12.2 is that MANAGER and related EXTRACT/REPLICAT cannot be started or stopped remotely. So what happens is when the direct load is started on the source server it tries to start replicat remotely on the target server, so this leads to ERROR OGG-01201  Error reported by MGR : Access denied, and this error will be reported in report file of the process.

The solution and the fix i found is that it is necessary to write below lines in the remote manager parameter file  ACCESSRULE, PROG *, IPADDR 192.168.1.161, ALLOW

This will allow source server to make connection and start the replicat process remotely

4 comments:

  1. i have done the same, but it shows the same error. what can be other possibility to fix this error?

    ReplyDelete
  2. i have done the same, but it shows the same error. what can be other possibility to fix this error?

    ReplyDelete
  3. Thanks for sharing, it helped me to fix my issue.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete