Re: Oracle 7 - TCP-IP-Port

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 09 Jul 2002 19:14:32 +0200
Message-ID: <ub6miu8o0d0amocmd2eda58fis1hjk6iq4@4ax.com>

On Tue, 9 Jul 2002 14:53:51 +0100, "Guenter Weckert" <Guenter.Weckert_at_Schaeff.com> wrote:

>Hi,
>what TCP-IP-Port use Oracle 7 to connect the Clients with the Server. I
>think about the ports 1521 and 1526. Are there other ports requiered??
>
>I have to create a connection throuh a firewall.
>Many Thanks
>
>Guenter Weckert
>

sqlnet uses port redirection. You'll get back a random port. Using Oracle 7 there are 2 possible solutions - get firewall software with a socalled sqlnet proxy install on it - configure MTS. This will use a fixed port always.

In Oracle 8 this problem has been solved by use_shared_sockets or connection manager.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 09 2002 - 12:14:32 CDT