[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5198
  • Last Modified:

Oracle Ports - Firewall question

I'm trying to connect to an Oracle DB.  The Cleint is behind one firewall, and the server is behind another firewall. Both the client and server are on the internet.   I'm tring to use TCP/IP and SQL/NET8.  The tnsnames file is using port 1521.  I can't TNSPING the server. Is this because port 1521 is being blocked?  Is port 1521 commonly blocked?  What is the correct way to accomplish this?

Thanks

Jeff
0
jeffg_91911
Asked:
jeffg_91911
  • 2
1 Solution
 
mshaikhCommented:
You will have to set up a PAT (Port Address translation) on the firewall so that the port 1521 is mapped to the Oracle server. Then on the client you have to specify the firewall's address in the tnsnames.ora.

Or,
If you firwall allows  open up the port. That will work to.
0
 
mshaikhCommented:
You can also set up a proxy server on the firewall or on another machine accessible to the extranet.
0
 
aloxeCommented:
"[Oracle] Listeners on NT commonly listen on port 1521.  It is a common misconception that
if you allow access in to and out of the firewall by enabling access through
port 1521, that SQL*Net clients will be able to connect.

2. Use Connection Manager so the TNS CONNECT following the REDIRECT happens the
server side of the firewall.

3. If you are on Oracle 8, you can use a WINSOCK V2 API feature called Shared
Sockets . This allows a socket to be shared (or passed) between multiple
processes. To use this functionality in a single Oracle Home enviroment, set
USE_SHARED_SOCKET = TRUE in the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE section of
the registry."

see http://asktom.oracle.com/pls/ask/f?p=4950:8:11117456287419232851::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:264415410962,
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now