My Blog

GoldenGate pump process start up failure with TCP/IP error 145 (Connection timed out)

by Tushar Nath on 26th January 2017 No comments

Recently, I was at client site to set up Oracle GoldenGate to migrate oracle database from source Solaris to Linux. I hit an issues to start the PUMP process. The Pump process is not starting up and throwing TCP/IP error 145 in ggserr.log file.

The operating system and software details of both source and targets are as below:

Source

Operating system                            : Sun Solaris Sparc

Database: Database Version          : 12.1.0.2.0

Goldengate Version                        : 12.2.0.1

Extract and pump processes are configured at source site

Target

Operating system                           : Redhat Linux

Database: Database Version         : 12.1.0.2.0

Goldengate Version                        : 12.2.0.1

Replicat process is configured at target.

The extract is configured which is running fine. The pump process is failing to start.

Verification of current status of GoldenGate extract and pump process is as below.

GGSCI > info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXABCDE1    00:00:03      00:00:03

EXTRACT     STOPPED      PXABCDP1    00:00:00      00:00:12

The start of PUMP process is not successful. The sample log in Goldengate log file is as below:

2017-01-10 14:55:36  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pxabcdp1.prm:  TCP/IP error 145 (Connection timed out), endpoint: abc.target.com:7819.

2017-01-10 14:55:36  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, pxabcdp1.prm:  PROCESS ABENDING.

Following checks are performed to verify reason of failure to start of pump process

  • Ensure manager on target host is running on default port 7809 (in my case, I left default port as 7809)
  • Verify mgr.prm file of target host and ensure that port is listed correctly.

Sample manager parameter file entry in my case is as below:

PORT 7809

DYNAMICPORTLIST 7810-7819

  • Ensure manager process is up on target
  • Verify pump parameter file for target and ensure that target manager host details are correct.

Sample entry of remote target host details in parameter file is as below:

RMTHOST abc.target.com, MGRPORT 7809

All the above checks are fine. Now, let us go back and verify ggserr.log file at source side.

2017-01-10 14:55:36  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pxabcdp1.prm:  TCP/IP error 145 (Connection timed out), endpoint: abc.target.com:7819.

You can notice that pump is trying to connect a process running on port 7819 on target host, which is failing to connect and throwing exception as TCP/IP error 145 in log file.

Now, connect to target host and verify whether any process is running on port 7819.

You will notice that the process is up 7819. This is collector process.

Now, let us perform a quick basic telnet test from source server by issuing a command like as below:

telnet <target hostname> 7819.

In my case, the basic telnet test is not successful as expected. I verify basic connectivity test for manager port 7809, which is successful.

Further analyzing the open ports in firewall, it is confirmed that only manager port 7809 is open in firewall, not the other range of ports 7810 to 7819, which are configured in manager for DYNAMICPORTLIST settings.

The option for me is to either open the port range from 7810-7819 in firewall or alternatively use a range of available open ports.

To avoid any delay in set up, I reconfigure manager parameter file of both source and target to use available open ports range.

Sample example of latest manager parameter file is as below:

PORT 7809

DYNAMICPORTLIST 9101-9111

Now, restart of PUMP process is successful.

GGSCI > info all

Program     Status      Group       Lag at Chkpt Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXABCDE1    00:00:01      00:00:01

EXTRACT     RUNNING      PXABCDP1    00:00:00      00:00:10

The key observation is that only opening port of manager is not sufficient for pump process to work.

You have to open range of ports which are expected to be configured in parameter DYNAMICPORTLIST.

Tushar NathGoldenGate pump process start up failure with TCP/IP error 145 (Connection timed out)

Join the conversation