Sunday, February 3, 2019

Goldengate ENABLEMONITORING in 12.3 and above



In our Current env where we have OGG 12.2 version we use REST API to access/View the GG processes using below url
http://<my_GGserver_name>:7809/groups

           where < my_GGserver_name>  --- > is the server where my OGG is running
                            7809                           ---> is the Port on which my MGR is running
    
But after upgrading OGG from 12.2 to 18.1 above url stopped working which is due to the new feature introduce in 12.3 version called  Performance Metric Server (PMSRVR)

GGSCI (oradev.domain.com) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      RUNNING
PMSRVR      STOPPED
EXTRACT     RUNNING     EXT1    00:00:04      00:00:09
EXTRACT     RUNNING     EXT2    00:00:02      00:00:05
EXTRACT     RUNNING     PXT1    00:00:03      00:00:04
EXTRACT     RUNNING     PXT2    00:26:22      00:00:04

GSCI (oradev.domain.com) 6> start PMSRVR
PMSRVR started

GGSCI (oradev.domain.com) 9> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      RUNNING
PMSRVR      RUNNING
EXTRACT     RUNNING     EXT1    00:00:04      00:00:09
EXTRACT     RUNNING     EXT2    00:00:02      00:00:05
EXTRACT     RUNNING     PXT1    00:00:03      00:00:04
EXTRACT     RUNNING     PXT2    00:26:22      00:00:04

But still the url not working because from 12.3 where PMSRVR is introduced for monitoring using rest API you need to modify GLOBALS param and add below param

ENABLEMONITORING [ UDP ]
ENABLEMONITORING [ UDP ] [ UDPPORT portnumber ] [ HTTPPORT portnumber ]

If you Don’t give any PORT number then it will use default port which is 9004

GGSCI (oradev.domain.com) 3> status PMSRVR

PM Server is Running (HTTP Port oradev.domain.com.9004, Process ID 79277)


After Modifying GLOBALS param just bounce all the GG params including MGR and use the below url

http://<my_GGserver_name>:9004/groups

You will see all the GG processes and some new additional processes which is shown BELOW which shows DOWN since I’m not using GG Micro Services Architecture

Check more on PMSRVR here : 



0 comments:

Post a Comment

Auto Scroll Stop Scroll