Re: What are the ports involved with DB Link

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Apr 2005 00:00:08 +0200
Message-ID: <ujva61hbju33f763dudunf1210rhgdj9fo@4ax.com>

On 19 Apr 2005 14:32:14 -0700, "ryerras" <kumarreddi_at_gmail.com> wrote:

>So bob, are you saying the "other" network, needs to open more ports
>than 1521 for the db link to work?

Sqlnet uses two ports by default. Port 1521 for the listener, after which the listener redirects communication to a random port. There are several ways to circumvent that - enable use_shared_sockets in sqlnet.ora Not recommended, as stopping the listener will disconnect all sessions
- Configure multi-threaded server at the database side with a hardwired port. Not recommended as this is an inflexible way to configure MTS and due to the impact of mts, which is best suited for many connections, not recommeded.
- set up Oracle Connection Manager at the database server, to redirect all communications to a fixed port. Recommended

All methods are of course documented in the Net administrators manual no one reads.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Apr 19 2005 - 17:00:08 CDT