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,009
    Likes Received:
    203
    Trophy Points:
    63
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice