1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

D2K Connectivity to Oracle 9i Over Internet

Discussion in 'Oracle' started by kpsinghskr, Apr 2, 2008.

  1. kpsinghskr

    kpsinghskr New Member

    Joined:
    Apr 2, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  2. xpi0t0s

    xpi0t0s Mentor

    Joined:
    Aug 6, 2004
    Messages:
    3,012
    Likes Received:
    203
    Trophy Points:
    0
    Occupation:
    Senior Support Engineer
    Location:
    England
    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.
     

Share This Page