Solved

Oracle Ports - Firewall question

Posted on 2000-03-31
3
5,125 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
  • 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 100 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now