Goldengate Pump Processes Fail to Start Throwing Error "TCP/IP error 111 (Connection refused)"

 Problem:

Goldengate pump processes fail to start on the source site, ggserr.log is reporting this error:

TCP/IP error 111 (Connection refused), endpoint: 10.1.1.1:7809

 Analysis:

First make sure that goldengate ports are opened between both Source & Target sites. If parameter DYNAMICPORTLIST is not configured to define the range of ports goldengate will use, then goldengate can use ports randomly from range starting from port 7819 up to port 12818 along with port 7809 which is being used by the manager process.

I've already checked the route between Source & Target and confirmed that ports are opened:

# telnet 10.1.1.1 7809
Trying 10.1.1.1...
Connected to 10.1.1.1.


# telnet 10.1.1.1 7819
Trying 10.1.1.1...
Connected to 10.1.1.1.

 When checking GLOBALS file, it shows two paths:

# cat /goldengate/gghome/GLOBALS

GGSCHEMA GGOWNER
CHECKPOINTTABLE GGOWNER.CHECKPOINTTAB
ALLOWOUTPUTDIR /goldengate/ggdata_bkp
ALLOWOUTPUTDIR /goldengate/ggdata

While the right path "/goldengate/ggdata" which is being used by Source site is already existed, the other path "/goldengate/ggdata_bkp" is not exist:

# ls -ld /goldengate/ggdata_bkp

ls: cannot access /goldengate/ggdata_bkp: No such file or directory
 

 Solution:

Make sure the path mentioned after ALLOWOUTPUTDIR parameter in GLOBALS file is referring to an exist directory, otherwise remove or hash the line which refers to the non-exist directory, then restart the manager.

I've removed the following line, which refers to a non-exist directory:

# cat /goldengate/gghome/GLOBALS

GGSCHEMA GGOWNER
CHECKPOINTTABLE GGOWNER.CHECKPOINTTAB
ALLOWOUTPUTDIR /goldengate/ggdata

Then, restarted the manager process in the TARGET site:

GGSCI> stop manager

Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y

GGSCI> start manager

 

Then, start the pump processes in the SOURCE site:

GGSCI> start p*

References:

https://docs.oracle.com/en/middleware/goldengate/core/19.1/admin/administering-oracle-goldengate.pdf