Dear All, We have a Oracle databse server in our domain. we are using ERP Application. All the clients have D2K Installed. All the clients are able to connect through LAN to Oracle Database Server. Now we want some users to connect our database and run the application throughout the internet, for that we have taken one Public IP and it is NATed with our oracle server. throughout the internet we are able to trace our server also but unable to connect the database. I Just want to know that any changes should be done in clients computer (TNSNAMES). to connect through Internet to use ERP Application.If possible please send a TNSNAMES.ora sample file which can be useful for connectivity. And the port which should be open for connectivity because we have installed A Hardware Firewall as well. Thanx In Advance................... You can directly reply also kpsinghskr@rediffmail.com
If you have a firewall this could be the cause of the problem if it's not SQL*Net aware. You should check with your firewall provider if it is, and if it isn't there's little choice but to go for a different firewall product. SQL*Net takes an initial connection over the designated port, but the listener then returns a port number to the client through which subsequent communication takes place. This port number is random and this is what the firewall needs to look out for. The firewall should then allow communication through that port; if it does not, then no SQL*Net traffic beyond the initial connection will get through.
