Webserver to access remote Oracle at WAN

[karan_jhr]

I am running my website on Windows Server 2003
My Application is a on Windows Server 2003 and i will be getting the data from remote oracle database server at WAN running windows server 2000
I want to access my Oracle Database at a remote address on WAN.
Which port shall i enable or via which port the database will be accessible.

[theriver]

You'll be able to find the port in use by examining the relevant entry for that server in the tnsnames.ora file.

Your proposal is risky because:

- you'd be exposing the database server to the Internet, meaning it will be very insecure
- if the database is across the WAN from your application server then the performance may well be quite poor

You'd be better putting the application server in a DMZ attached to the DB server's network, thus protecting the Oracle server and improving bandwidth between the two servers.

[karan_jhr]

thanks theriver
We will be netting the internal IP address with and external IP via IR
It will be having a different IP address internally and externally.