Replicating Oracle db over firewall 
Author Message
 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



Sun, 23 May 2004 12:29:10 GMT
 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

Quote:

> 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



Sun, 23 May 2004 14:55:01 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Replicating DB from a target replicated DB

2. i restored one replicated database in another replicated db, and now cant delete publishers in EM

3. Replicated transactions appearing in non-replicated DB!

4. %FIREWALL% %FIREWALL% %FIREWALL%

5. How to export data from Oracle which unders Firewall to SQL Server 7 which outside Firewall

6. Trouble replicating through firewall

7. Replicating through a firewall

8. Replicating via firewall

9. Connecting Oracle DB through firewall

10. Connecting to DB Outside of Firewall using OLE DB

11. replicate sql servr 2000 db to oracle 9i or reverse

12. Replicating Oracle DB


 
Powered by phpBB® Forum Software