Re: AltaVista firewall with Oracle Net8 Listener, SQLNet2 client

Chris,

Your assumption was 100% correct
concerning NT. I should have stated that clearly. Your solution also worked immediately.
We manually modified the NT Registry and added the key and restarted the listener. No more problems with the fireall after that point!

The documentation on the part of Oracle is relatively scarce about this parameter, although it is mentioned very briefly in one of their platform specific network
manuals.

The only disadvantage to using a single port is that you cannot restart the Net8 Listener at any time. You need to make sure there are no open connections otherwise the service thinks that the port is occupied. Nevertheless this is a very minor inconvenience.

Thanks for your advice!

Mario

Christopher M. Day wrote in message
<3764287F.CE37F7EB_at_rdbms.freeserve.co.uk>...
>Mario,
>
>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 Tue Jun 15 1999 - 09:30:25 CDT