Replicating Oracle db over firewall

Hello!

Our possible customer has Oracle 8.0.6.0.0. running on SunOs 5.7. in protected network and they have another similar configuration in DMZ as database for web applications. So there is at least one firewall between two Oracles.

I have tried to find information what ip ports should be open from protected Oracle to DMZ Oracle and what ip ports should be open from DMZ to protected Oracle (hopefully none) to make one-way replication (actually just cloning the data) to DMZ Oracle.
SQLNet (or should I just say Net8 ?) nor Replication documentation revealed no information to me in this subject. Nor did any searches in internet.

It may be that the only needed ip port would be the listener configured port but I'd like to know that for sure..

Then entirely other matter is the replication. The data on the DMZ Oracle needs to be replicated as they are updated to protected Oracle (a delay should be no more than a few minutes) but the changes on DMZ Oracle do not have to be replicated back.
I looked into Replication manuals on this as well (concentrating mostly on ip ports though) and found out that there are two ways for replicating.. Basic and advanced. Basic is a snapshot replication and in advanced one can configure a transactional replication. Is it possible to configure a snapshot replication to do a snapshot of changes only? And to do that every few minutes or whenever there are commited changes in source database?

Thank you for your time and answers!

Vesa Nopanen Received on Tue Dec 04 2001 - 22:29:10 CST