Re: Sqlnet and NT and port numbers

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Tue, 15 Jun 1999 21:19:17 +0100
Message-ID: <3766B545.3DF14BF4@rdbms.freeserve.co.uk>

The work around is to set the additional Oracle registry flag USE_SHARED_SOCKETS=TRUE. This stops the listener spawning a new dedicated service on a different port. ie not 1521.

This is documented in the Net8 and IOC guides. If you have a V7 database, you need to install the Net8 listener

Chris.

Harri Muttilainen wrote:
>
> Could somebody please help.
>
> Is the port number that sqlnet uses for communication
> with the database on an NT server totally random or are
> there some upper and lower limits?
>
> It seems that when establishing the connection the port
> number is 1521, but then it changes to something else when
> the connection has been established.
>
> The problem is that we would like to restrict the ports
> that a reseller could use to access our network, but I
> have not found any documentation either from Oracle or
> Microsoft about the matter.
>
> Please Help
> Harri Muttilainen
Received on Tue Jun 15 1999 - 15:19:17 CDT