Re: Tnslistener dying with 9.2 on Win XP Pro

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 15 Jul 2003 11:43:56 +0200
Message-ID: <3F13CCDC.50302@science-computing.de>

Billy Verreynne wrote:
> srinusee <member33245_at_dbforums.com> wrote
>
>

>>Update your registry with this variable:
>>  Regedit --> HKey_Local_Machine\Software\Oracle\Home0
>>
>>  Create new entry: USE_SHARED_SOCKET=TRUE

>
>
> Why? (I know what this means in socket programming, but there's only
> one listener process on that socket listening and accepting
> connections, right?)
>
> --
> Billy

Not completely. Shared Socket in this context means that the socket is shared between the listener and the oracle process.

The default behaviour is that the listener receives the client request. The listener then contacts the oracle process which in turn spawns a new socket and returns the socket to the listener. The listener gives the socket address back to the client and the client initiates a new connection to that socket.

(Un)fortunately this is exactly what a firewall blocks.

So with shared socket the listener spawns the socket for the client connection and hands it over to oracle.

HTH Holger Received on Tue Jul 15 2003 - 04:43:56 CDT