Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle Ports - Firewall question

Posted on 2000-03-31
3
Medium Priority
?
5,163 Views
Last Modified: 2008-03-17
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
Comment
Question by:jeffg_91911
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Expert Comment

by:mshaikh
ID: 2674019
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
 
LVL 6

Accepted Solution

by:
mshaikh earned 300 total points
ID: 2674031
You can also set up a proxy server on the firewall or on another machine accessible to the extranet.
0
 

Expert Comment

by:aloxe
ID: 12493986
"[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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious sideā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question