Wednesday, 11 March 2020

WARNING OGG-01742 Command sent to MGR MGR returned with an ERROR response.


Error:
GGSCI (localhost.localdomain) 2> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y

Sending STOP request to MANAGER ...

ERROR: Access denied

2020-03-11 22:41:30  WARNING OGG-01742  Command sent to MGR MGR returned with an ERROR response.


GGSCI (localhost.localdomain) 3> status all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

In GG error log:

[oracle@localhost 18.1.0.0.0]$ tail -f ggserr.log
2020-03-09T20:54:51.270-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle, oby.oby:  GGSCI command (oracle): CREATE SUBDIRS.
2020-03-09T20:54:52.500-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle, oby.oby:  GGSCI command (oracle): START MGR.
2020-03-09T20:54:52.801-0400  WARNING OGG-01877  Oracle GoldenGate Manager for Oracle, mgr.prm:  Missing explicit accessrule for server collector.
2020-03-09T20:54:52.803-0400  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2020-03-09T20:54:53.585-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle, oby.oby:  GGSCI command (oracle): CREATE DATASTORE.
2020-03-11T22:41:28.754-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop mgr.
2020-03-11T22:41:30.535-0400  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host [192.168.50.176]:20313 (STOP).
2020-03-11T22:41:30.559-0400  WARNING OGG-00936  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access denied (request from 192.168.50.176, rule #0).
2020-03-11T22:41:30.559-0400  WARNING OGG-01742  Oracle GoldenGate Command Interpreter for Oracle:  Command sent to MGR MGR returned with an ERROR response.
2020-03-11T22:42:06.704-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit param mgr.

solution:
   It happen only if the manager process hung or mgr running from other node..
 
GGSCI (localhost.localdomain) 5> kill mgr
Killed process (29033) for MGR

GGSCI (localhost.localdomain) 6> status all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED


GGSCI (localhost.localdomain) 7> start mgr
Manager started.


GGSCI (localhost.localdomain) 8> status all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING


GGSCI (localhost.localdomain) 9> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?yes

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.


GGSCI (localhost.localdomain) 10> status all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED


GGSCI (localhost.localdomain) 11> start mgr
Manager started.


GGSCI (localhost.localdomain) 12> status all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING


No comments:

Post a Comment

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...