（轉載）iptables 轉寄oracle連接埠

標籤：des   style   blog   http   io   ar   color   os   sp   

本文出自 “鄉丅亻” 部落格，請務必保留此出處http://shaowu.blog.51cto.com/627407/514909

 

項目組同事需要將SQL請求轉寄到另一台伺服器上，於是通過iptables實現此功能

[[email protected]1 ~]# echo 1 > proc/sys/net/ipv4/ip_forward[[email protected]-1 ~]# iptables -t nat -A PREROUTING -d 192.168.18.19 -p tcp --dport 1521 -j DNAT --to 192.168.4.74:1521[[email protected]-1 ~]# iptables -t nat -A POSTROUTING -d 192.168.4.74 -p tcp --dport 1521 -j SNAT --to 192.168.18.19

 

查看nat 規則：

[[email protected]1 ~]# iptables -L -n -t natChain PREROUTING (policy ACCEPT)target     prot opt source               destinationDNAT       tcp  --  0.0.0.0/0            192.168.18.19        tcp dpt:1521 to:192.168.4.74:1521Chain POSTROUTING (policy ACCEPT)target     prot opt source               destinationSNAT       tcp  --  0.0.0.0/0            192.168.4.74       tcp dpt:1521 to:192.168.18.19Chain OUTPUT (policy ACCEPT)target     prot opt source               destination

 

Telnet測試：

[[email protected]1 ~]# telnet 192.168.4.74 1521Trying 192.168.4.74...Connected to localhost (192.168.4.74).Escape character is ‘^]‘.

 

儲存iptables設定：

[[email protected]1 ~]# iptables-save >> /etc/sysconfig/iptables

 

（轉載）iptables 轉寄oracle連接埠