SOURCE: Oracle 12c (12.1.0.2.0). Running OGG 12.1.2.0.0 for Oracle 12c.
DESTINATION: MSSQL 2014. Running OGG 12.3.0.1.6 for SQL Server.
I am attempting to run initial data load EXTRACT on Oracle 12c, however I am running into the following error in the EXTRACT report:
2018-07-20 14:30:26 WARNING OGG-01223 TCP/IP error 111 (Connection refused), endpoint: 51.140.252.121:7890.
This is the first portion of my EXTRACT initial data capture:
EXTRACT EINI9001
USERID QUOTEVINE, PASSWORD <redacted>
RMTHOST 51.xxx.xxx.121, MGRPORT 7890
RMTTASK REPLICAT, GROUP RINI9001
<followed by TABLE and TABLEEXCLUDES, not relevant>
On the MSSQL Server, if i use "VIEW GGSEVT", all I can see for each attempt is:
| 2018-07-20T14:29:56.918-0000 INFO | OGG-00963 Oracle GoldenGate Manager for SQL Server, MGR.prm: Command received from EXTRACT on host [91.216.93.165]:6540 (START REPLICAT RINI9001 CPU -1 PRI -1 PARAMS ). |
| 2018-07-20T14:29:56.918-0000 INFO | OGG-00960 Oracle GoldenGate Manager for SQL Server, MGR.prm: Access granted (rule #1). |
On the DESTINATION MSSQL server, my REPLICAT task looks like this:
REPLICAT RINI9001
TARGETDB 1pmtestingdsn, USERID quotevine, PASSWORD <redacted>
DISCARDFILE ./dirrpt/RINI9001.txt, PURGE
SOURCEDEFS ./dirdef/1pmoracle.def
MAP QUOTEVINE.*, TARGET QUOTEVINE.*;
On the DESTINATION MSSQL server, my MGR PARAMS file looks like:
PORT 7890
DYNAMICPORTLIST 7891-7900
ACCESSRULE, PROG * IPADDR 91.xxx.xxx.165, ALLOW
The IP there "91.xxx.xxx.165" is the IP of the SOURCE Oracle 12c server. If I remove the ACCESSRULE, and try again, I get "Access Denied" when the EXTRACT abends on SOURCE server.
I have not used OGG 12.3 before, is there something I am missing as to why I am getting connection refused on MGR port 7890?
To clarify, I can telnet to 7890 on DESTINATION server FROM the source Oracle 12c server. So network connectivity/firewalls are all OK, I can reach the server, but OGG is saying connection refused, even when I ahve an ACCESSRULE.