Re: AltaVista firewall with Oracle Net8 Listener, SQLNet2 client

Mario,

[Quoted] The problem is that when you try to establish a session the listener is spawning a connection using a different socket. tnsping will work fine as it doesn't request the listener to spawn a connection.

I haven't seen this happening with UNIX, so I assume (perhaps wrongly) that you are using NT. If so you need to add the registry string under the ORACLE key USE_SHARED_SOCKET=TRUE. All connection will then share the same socket number i.e. 1521.

Chris.

Mario wrote:
>
> We are trying to connect SQL*Net 2 clients through
> an AltaVista Firewall97 to a Net8 Listener.
> TNSPING works just fine but we cannot establish
> a session with any application. We have set up
> a generic port on the firewall to allow the clients
> through to the DB but the moment we try to establish
> a session with SQL'Plus ot any other app
> we are not successful.
>
> Does anyone have any ideas or experience that
> might come in handy?
Received on Sun Jun 13 1999 - 23:54:07 CEST