Re: How to use Sql*plus cross Fairwall

From: Daniel <nospam_at_nospam.com>
Date: Mon, 14 Dec 1998 12:20:56 -0000
Message-ID: <752v3i$868$1@inet16.us.oracle.com>

>AFAIK the trouble with oracle's network protocol is that
>it opens arbitrary ports.
>
>the server listens on the port that is configured in listener.ora
>(often 1526 or 1521). After a client connect another port is negotiated.
>you can
>see that using a tool like "netstat".
>
>Perhaps anyone does how this can be avoided or the range be pre-defined?

On NT in the Oracle section of the registry set;

use_shared_socket = TRUE

This will stop the re-direct taking place and keep all client connections on the port the lsnr is running on...

Daniel... Received on Mon Dec 14 1998 - 06:20:56 CST