Re: Sync two DBs across firewall

Hello,

S S Wan wrote:

> What is the better way to sync. two databases across firewall?

> FTP? SQL*Net/Replication? What about the security risk of
> opening a SQL*Net port in firewall?

If you use a firewall supporting a SQL*Net-Proxy, then only SQL*Net-Calls can cross the firewalls on the defined port, not any other TCP-call. (Its similar to the situation, where firewall-admins dont just open Port 80 for http - they activate an http-proxy).

If your Firewall does not support SQL*Net-Proxy, then you can do following: Install Oracle's Connection Manager behind the firewall (in the companie's Network), and allow for the opened port on the firewall ONLY a connection to that Server. The connection manager will only accept SQL*Net-Calls and allow SQL*Net-Connections only to the defined SID (even if you have more Instances on the Database server you can access the access only to one SID).

Please can you post a diagram, where you show the position of the databases, DMZ, Firewall, Application servers, web servers, which type of replication (bi-directional ?)

Best regards,

Harald Wakonig Received on Sun Dec 26 1999 - 05:37:22 CST