Re: AltaVista firewall with Oracle Net8 Listener, SQLNet2 client

The other solution is to use Oracle Connection Manager, an NT service that sits on the database side of the firewall and handles all connections through the firewall on one port. Also it allows for protocol switching ie client to cman via tcp and then cman to database via spx etc etc. It also gets around the problem of not being able to stop the lsnr if using shared sockets...

--
Daniel
Oracle UK




Mario wrote in message <7k5nre$mgk$1_at_news.online.de>...


>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?

>>

>

>