Thursday, April 6, 2017

Golden Gate 12.2 Monitoring JAGENT 

Not Starting Post Upgrade


After an upgrade from 12.1 to 12.2 JAGENT, the monitoring agent is not starting up. 


Error - 
[2017-04-05T09:50:33.133-07:00] [JAGENT] [ERROR] [OGGMON-20497] [com.goldengate.monitor.jagent.comm.ws.NotificationsCollector] [tid: StatusCollector] [ecid: 0000Lfr0uKD5mZSpyCd9iW1Oof4E000003,0] Failed to get Status Information. RESTful Web Service might not be available.
[2017-04-05T09:50:38.134-07:00] [JAGENT] [ERROR] [OGGMON-20494] [com.goldengate.monitor.jagent.comm.ws.NotificationsCollector] [tid: StatusCollector] [ecid: 0000Lfr0uKD5mZSpyCd9iW1Oof4E000003,0] Error occurred while registering the OGG process. Exception: [[
 source parameter must not be null
]]

OR 

Exception in thread "StatusCollector" java.lang.NullPointerException
        at com.goldengate.monitor.jagent.comm.ws.NotificationsCollector.checkAndDeleteProcess(NotificationsCollector.java:140)
        at com.goldengate.monitor.jagent.comm.ws.NotificationsCollector.checkAndPublishRegisteredAndDeletedProcess(NotificationsCollector.java:128)


SOLUTION

Login to ggsci prompt and run following 

[ggsadmin@12.2.0]$agctl stop   goldengate xxxx

[ggsadmin@12.2.0]$./ggsci

GGSCI () 1> delete datastore
Are you sure you want to delete the datastore? y
2017-04-06T18:23:20Z  INFO    OGG-06492  Datastore deleted

GGSCI () 2> create datastore
Profile 'Trace' added.
2017-04-06T18:23:27Z  INFO    OGG-06489  Datastore created
GGSCI () 3> exit

[ggsadmin@12.2.0]$agctl start   goldengate xxxxx

Even after this if the agent doesnt start, please check the prm file for the agent. 

[ggsadmin@ bin]$cat /ggsadmin/app/cqxad02p/ggate/12.2.0/dirprm/jagent.prm

COMMAND java -Dconfig.dir=/ggsadmin/app/cqxad02p/ggate/12.2.0/cfg -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=/ggsadmin/app/cqxad02p/ggate/12.2.0/cfg/logging-config.xml -Doracle.core.ojdl.logging.componentId=JAGENT -jar -Xms512m -Xmx1024m /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar

[ggsadmin@cfg]$ll /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar

-rw-r----- 1 ggsadmin oinstall 363165 Oct 12  2015 /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar

the JAGENT.jar file has no executable permissions and hence it was not starting up

[ggsadmin@cfg]$chmod  755 /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar


[ggsadmin@cfg]$ll /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar
-rwxr-xr-x 1 ggsadmin oinstall 363165 Oct 12  2015 /ggsadmin/app/cqxad02p/jagent12.2/oggmon/ogg_agent/dirjar/jagent.jar

After this change, the JAGENT started fine.