RE: International access to Oracle databases
"pep0" <[email protected]> Thu, 27 Feb 2003 08:16:58 -0000
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Organization | SW16 |
| Message-ID | <LYRIS-1796914-890573-2003.02.27-08.16.18--gcdod-oracle#[email protected]> |
Hello, I used to work for an international company with database servers in 27 countries. The whole network was connected with frame relay VPN Worldcom lines with different bandwidths, between 256 kbps and 2 MB/s depending on the country. I used to work from Spain with Germany over a 512 kbps line, and I had to say that the performance of the line was fine with over 30 users working with an application developed in Forms6, and about 10 more users testing some applications in a CITRIX server. Regarding your question about the Firewall, we used "Checkpoint NG", which has a feature that I suppose is what you are looking for. It's possible to have a rule for example to connect with the port 1521 of a server using net protocol, but this rule it's initially disable until a user try to connect to this machine. Then the user must introduce a Username and a password to enable this rule on the firewall. This authentification is provided by the firewall, and it's completely independent from the database authentification. The security of the data transmitted is given by the encryption boxes at both sides of the VPN, so in theory you'll don't have to worry about that, but Checkpoint has also a feature to encrypt the data transmitted. Hope this helps, best regards, pep0. > -----Mensaje original----- > De: Darren Collard [mailto:[email protected]] > Enviado el: miƩrcoles, 26 de febrero de 2003 22:34 > Para: Oracle > Asunto: [oracle] International access to Oracle databases > > > Does anybody have any advise or experience of accessing > Oracle Databases > over a Wide Area Network? > > Our Worry list currently contains the following items: > > 1. The ability to restrict Access through our firewall to > certain databases > > 2. Performance of SQL*Net / Net*8 over a WAN consisting of > Frame-Relay and > VPN (between 128Mb to 2Gb) - Does Oracle use a "chatty" protocol? > > 3. The security of the data being transmitted. > > I would love to hear from others who have overcome these issues. > > Kind Regards, > > Darren Collard > > > --- > Change your mail options at http://p2p.wrox.com/manager.asp or > to unsubscribe send a blank email to > %%email.unsub%%. > > --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].