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
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
i have done the same, but it shows the same error. what can be other possibility to fix this error?
ReplyDeletei have done the same, but it shows the same error. what can be other possibility to fix this error?
ReplyDeleteThanks for sharing, it helped me to fix my issue.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete