Solved

Oracle Ports - Firewall question

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
use lov values 2 71
Oracle encryption 12 59
Email query results in HTML 6 37
how to tune the query 17 45
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…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
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 video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

685 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