There are many different ways of monitoirng Oracle GoldenGate; I have posted about many of these in earlier blog posts. Additionally, I have talked about the different ways of monitoring Oracle GoldenGate at a few conferences as well. (The slides can be found on my slideshare site if wanted). In both my blog and presentations I highlight many different approaches; yet I forgot one that I think is really cool! This one was shown to me by an Oracle Product Manager before Oracle Open World 2014 back in October (yes, I’m just now getting around to writing about it).
This approach is using the Oracle GoldenGate Manager (port) to view a user friendly version of the XML that is passed by the Oracle Monitor Agent (JAgent) to monitoring tools like Oracle Enterprise Manager or Oracle GoldenGate Director. This approach will not work with older versions of the JAgent.
Note: The Oracle Monitor Agent (JAgent) used in this approach is version 18.104.22.168. It can be found here.
Note: There is a license requirement to use this approach since this is part of the Management Pack for Oracle GoldenGate. Contact you local sales rep for more info.
After the Oracle Monitor Agent (JAgent) is configured for your environment, the XML can be accessed via any web browser. Within my test enviornment, I have servers named OEL and FRED. The URLs needed to to view this cool feature are:
As you can see, by using the port number (15000) of the Manager process, I can directly tap into the information being feed to the management tools for monitoring. The “groups” directory places you at the top level of the monitoring stack. By clicking on a process groups, this will take you down into the process group and show additional items being monitored by the JAgent.
In this example, you are looking at the next level down for the process EXT on OEL. At this point, you can see what is available: monitoring points, messages, status changes and associated files for the extract process.
As you can see, the new Oracle Monitor Agent (JAgent) provides you another way of viewing your Oracle GoldenGate environment without needing direct access to the server. Although this is a cool way of looking at a Oracle GoldenGate environment, it does not replace traditionall monitoring approaches.
Cool Tip: The OS tool “curl” can be used to dump similar XML output to a file (showed to me by the product team).
$ curl --silent http://oel.acme.com:15000/registry | xmllint --format - <?xml version="1.0"?> <?xml-stylesheet type="text/xsl" href="/style/registry.xsl"?> <registry xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://oel.acme.com:15000/schema/registry.xsd"> <process name="PMP" type="4" status="3"/> <process name="EXT" type="2" mode="1" status="3"/> <process name="MGR" type="1" status="3"/> </registry>
In my opinion, many of the complants about the original version of the JAgent have been addressed with the latest release of the Oracle Monitor Agent (JAgent). Give it a try!