Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Net port

Re: SQL Net port

From: <sybrandb_at_hccnet.nl>
Date: Sat, 05 May 2007 16:25:02 +0200
Message-ID: <jj4p339dqmrc7g44c2hai387ia0r1fjg9k@4ax.com>


On Sat, 5 May 2007 15:35:20 +0200, "astalavista" <nobody_at_nowhere.com> wrote:

>Hi,
>
>I am trying to connect to a database through a firewall
>according the documentation sometimes
>a port redirection arise:
>- to UNIX : no port redirection
>- to windows : port redirection
>- with MTS : port redirection
>
>am I right ?
>
>so if I have to connect to a UNIX database (no MTS)
>I only have to open the listener port (1521), no ?
>
>Thanks for your lights ...
>

Could you point to the *Oracle* documentation in which you have been reading this? If you really read that, you should submit that as a documentation bug.

There is *always* port redirection, on whatever platform. There are three situations where you won't have port redirection (and I posted them over and over again, but I appreciate people like you can't be bothered with searching the archives)

1 sqlnet.use_shared_sockets = true in sqlnet.ora *on the server* (Unix) or registry key USE_SHARED_SOCKETS=true (Windows) Disadvantage: when you stop the listener all sessions are disconnected 2 setting up MTS on a *hardcoded* port in the dispatcher parameter. Disadvantage: need to configure your database for MTS 3 Setting up Connection Manager, and change your tnsnames.ora accordingly.
This is the only option that doesn't have any disadvantages.

Sybrand Bakker
Senior Oracle DBA Received on Sat May 05 2007 - 09:25:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US