Using Compare in a NAT environment (4265328)

Using Compare in a NAT environment

How to run compare in a NAT Environment (Network Address Translation)

When NAT is implemented, the target IP address on the source machine and the IP address on the target machine can be different, which can cause confusion when the compare command is issued.

INSTRUCTIONS:

1.Open a port bi-directionally on the source . Port is a required part of the compare syntax when comparing within a Firewall environment..

. Use a different port number other than the one used for SharePlex .

 2.Set the SP_DEQ_IP_MAPPING parameter on the target , it maps the IP addresses when Network Address Translation (NAT) is

implemented between the source and target systems. Example:

 ON Target :

Set param SP_DEQ_IP_MAPPING SOURCE INTERNAL IP: SOURCE EXTERNAL IP, TARGET INTERNAL IP: TARGET EXTERNAL IP

 sp_ctrl> set param SP_DEQ_IP_MAPPING 10.17.4.226:204.214.145.53,10.10.62.4:207.211.57.130

 The first IP pair to let poster to accept the incoming compare message.

The second IP pair is to let compare client connect to the right source machine.

 3.Make sure there is no backlog in the queues on both source & target.

 4.Issue compare on the source using the port option:

compare table scott.emp to scott.emp target SysB@o.oraB port 1234

In Shareplex 7.5 or up, the compare process uses the same port as used by Shareplex. The precondition here is that both the source and target are on 7.5 or up. For versions lower than 7.5, compare will pick up any available port at random.