Re: Replicating Oracle db over firewall

Hi Vesa,

concerning your firewall questions:
- using dedeicated connections it's enough that your firewall   vendor support the sql*net protocol. A lot of firewall vendors   do this already
- using mts, you have to define the port with the mts_dispatcher   parameter

concerning replication:
- three types of replication are available

• read only snapshot
• updateable snapshot (advanced replication)
• master master replication (advanced replication) - master master replication for near realtime replication between two masters - to get only the updates/deletes you have to create snapshot logs so only the changes will be propagted, the frequency can be set by running it as a database job with dbms_job

Regards
Stefan

Vesa Nopanen wrote:

> 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 Wed Dec 05 2001 - 00:55:01 CST