Compare/Repair is timing out when replicating through a firewall (4243887)

When replicating shareplex through a firewall with port 2100 opened, running a Compare/Repair creates a log on source and target, but nothing is done.

The target log appears as follow:

FILE: /vardir/log/ilp_declt-28359-01.log
DATE: Mon Nov 12 17:33:41 2001
LOG#: 1

Debug flag: 0x00000000

Session ID : 28359
Source Table: owner.tablename
Source Node : source
Target Table: owner.tablename
Target Route: route@o.sid
Batch Size : 10000 rows
Repair : Off
Where Clause:
Select Hint :

sp_declt PID: 1992

OS Version : SunOS 5.6 Generic_105181-16
Machine : sun4u
Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
Error 145 calling connect in de_sock_connect_to_server
Error 145: Connection timed out
eintr_count = 0, eisconn_count = 0, ealready_count = 0
Error 145 connecting to server
Exiting

Compare/Repair randomly picks a port which is not open on firewall.

Compare/Repair needs to run on a different port than the sp_cop process. Normally shareplex will get a port number from the operating system. This port is randomly assigned by the operating system. The C/R command has the ability to specify the port number in the command using the following syntax.

Compare table scott.tab1 to scott.dest1 target sunws@o.ora8 port 6789.

This facility is available in shareplex version 3.0.0.8 and higher. The ports that C/R is run on needs to be open both ways.