Warning OGG-01223 TCP/IP error 111 (connection refused)

I. Problem Description

Ggsci (source_pc) 64> info all

Program Status group lag at chkpt time since chkpt

Manager running
Extract running eora_t1 00:00:00 00:00:06
Extract abended pora_t1 00:00:00 00:12:53

It is found that the status of pora_t1 is abended.

After it was started, it was still running. After several minutes, it was changed to abended (sometimes stopped)

Ggsci (source_pc) 66> View Report pora_t1

The following error is reported:

Warning OGG-01223 TCP/IP error 111 (connection refused)

Ii. Cause of error

The port numbers in the source and target edit Params Mgr are inconsistent, and the mgrport in the edit Params pora_t1 is the target port number. Therefore, the numbers in the source and pora_t1 parameters are inconsistent.

My source end is 7809, the target end is 7808, And the mgrport in edit Params pora_t1 is 7808

Iii. Solution

The port numbers in the source and target edit Params Mgr must be the same (I changed them to 7809 ),

Change the mgrport value in edit Params pora_t1 to 7809.

Then start extract pora_t1 at the source end and it will remain running. No error is reported.

 

Warning OGG-01223 TCP/IP error 111 (connection refused)