PDA

View Full Version : Check listening on Dbvisit Replicate port


Arjen Visser
10-30-2011, 01:45 PM
How do you check that Dbvisit Replicate is listening on the correct ports to ensure the Oracle replication is working?

Dbvisit Replicate uses the following default ports:
Source server: 7890
Target server: 7891

To check that Dbvisit Replicate is listening on these ports for Linux:
$ netstat -tulpn | grep :7891
tcp 0 0 210.34.63.46:7891 0.0.0.0:* LISTEN 3899/dbvrep

This is showing that the dbvrep command with process id 3899 is listening on port 7891 on the target server which is correct.

Ensure that the firewall port is open on 7891 on the target server. If you are using iptables as the firewall, this can be checked with the following command:
/sbin/iptables -L -n
ACCEPT tcp -- 0.0.0.0/0 0.0.0.0/0 state NEW tcp dpt:7891

This shows that the firewall is open for tcp port 7891 which is correct.

To add port 7891 to iptables firewall:
Add 7891 to iptables in /etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 7891 -j ACCEPT

Restart the firewall


# service iptables restart
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: filter [ OK ]
Unloading iptables modules: [ OK ]
Applying iptables firewall rules: [ OK ]
Loading additional iptables modules: ip_conntrack_netbios_n[ OK ]