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 email@example.com