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