#GoldenGate Manager Access Rules
Starting in Oracle GoldenGate 12.2.0.1, the manager process is more secure than in previous releases of Oracle GoldenGate. After the inital install and running of the Manager process, you may run into the following warning message upon a restart of the Oracle GoldenGate environment:
WARNING OGG-01877 Missing explicit accessrule for server collector.
The inital description of the error message doesn’t make much sense. Using OGGERR, you can find out more about this error message:
$ oggerr ogg-01877 01877, 00000, "Missing explicit accessrule for server collector." // *Cause: There was no explict ACCESSRULE specified for SERVER. // *Action: Only allow accessing SERVER from hosts where data pump(s) might // send trail files to this host.
As you can tell, the error message is pointing you to the ACCESSRULE parameter.
Now that you have more detail, you know that there is a new parameter called ACCESSRULE that needs to be specificed in the manager parameter file. To find out more information on the ACCESSRULE parameter look at this link.
The defnition of this parameter is:
“Use ACCESSRULE to control connection access to the Manager process and the processes under its control. You can establish multiple rules by specifying multiple ACCESSRULE statements in the parameter file and control their priority. To establish priority, you can either list the rules in order from most important to least important,or you can explicitly set the priority of each rule with the PRI option.”
This parameter is not a default configured parameter for the manager process. This is something that you will need to decided on and how to control access to your environments. The syntax for this parameter is as follows:
ACCESSRULE[, PROG program_name][, IPADDR address][, PRI rule][, login_ID]{,ALLOW | DENY}
There are multiple example of how to define an access rule in the Oracle GoldenGate 12.2.0.1 documentation. The example that I’m providing here is how I resolved the warning message in my Vbox test environment.
ACCESSRULE, PROG * ALLOW
With this access rule, you can now start the manager process without issue. You would be allowing access to all processes in the Oracle GoldenGate environment.
Enjoy!
-Bobby
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good. https://accounts.binance.com/ka-GE/register?ref=RQUR4BEO
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Foci of activity in the soft tissues of the face eg, hot nose and scalp may be mistaken for focal activity in the brain, particularly if these tissues are hyperemic because of trauma or surgery priligy review
can i get cytotec These macula densa cells release chemical signals and interact with specific cells, called juxtaglomerular cells, in the afferent arteriole just proximal to the glomerulus