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
Solved

Oracle Ports - Firewall question

Posted on 2000-03-31
3
5,137 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.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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

808 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