Hi,
I am migrating from OGG 11.2 to OGG 12.2.0.1.161220, both on Oracle RDBMS 11.2.0.4
I'm using similar script, but I've got an error when I try to know remotely the status of a passive pump or when I try to start it.
can you see what I'm doing wrong ?
In the GLOBALS 12.2 file, I set USEIPV4 and add the _DISABLEFIX21427144 parameter to avoid a grant error (https://support.oracle.com/epmos/faces/DocContentDisplay?id=2100019.1 )
Client and server have the same network mask, so I'm certain there's no network firewall between them.
The server is on Windows 10, the client on Windows 7. Both have firewall and antivirus disabled.
I've got also a direct pump extract from client to server (bidirectionnal use) : it works well, so the server manager is running.
server side : PD000001.prm
EXTRACT PD000001
USERID OGG@127.0.0.1/server.world, PASSWORD xxx
RMTTRAIL dirdat\PD000001\pd
RMTHOSTOPTIONS timeout 60
REPORTCOUNT EVERY 10 SECONDS, RATE
table ../..
ADD EXTRACT PD000001, PASSIVE, TRANLOG, BEGIN NOW,EXTTRAILSOURCE dirdat\X2000000\x2
ADD RMTTRAIL dirdat\PD000001\pd, EXTRACT PD000001";
client side :
ADD EXTRACT PD000001, rmthost 192.168.1.20,mgrport 7700
GGSCI (client) 2> info PD000001
EXTRACT PD000001 Initialized 2017-06-23 20:09 Status STOPPED
ALIAS PD000001 192.168.1.20:7700
Forwarding command to PD000001@192.168.1.20:7700
Error 3, retrieving port for GGSCI (Timeout waiting for message)
GGSCI (client) 3> start PD000001
Sending START request to MANAGER@192.168.1.20:7700 ...
Timeout waiting for message
in the server ggserror.log :
| 2017-06-26 14:06:51 INFO | OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GUI on host 192.168.1.19:49373 (START GGSCI ). |
| 2017-06-26 14:06:51 INFO | OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1). |
| 2017-06-26 14:06:51 INFO | OGG-00976 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started 'ggsci' process on port 0. |
2017-06-26 14:06:52 ERROR OGG-01224 Oracle GoldenGate Command Interpreter for Oracle: opening port to MGR from GGSCI failed with 1:TCP/IP error: Connection refused.
2017-06-26 14:06:52 ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.
| |
| 2017-06-26 14:14:11 INFO | OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 192.168.1.19:49401 (START EXTRACT PD000001 ). |
| 2017-06-26 14:14:11 INFO | OGG-00960 Oracle GoldenGate Manager for Oracle, mgr.prm: Access granted (rule #1). |
| 2017-06-26 14:14:11 INFO | OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT PD000001 starting on port 0. |
2017-06-26 14:14:12 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, PD000001.prm: opening port to MGR from EXTRACT failed with 1:TCP/IP error: Connection refused.
2017-06-26 14:14:12 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, PD000001.prm: PROCESS ABENDING.
Thanks for your help.
Pierre