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.