Re: exception: The Network Adapter could not establish the connection

From: Pasi Kallankari <pasi.kallankari_at_nokia.com>
Date: Fri, 21 Mar 2003 10:51:43 GMT
Message-ID: <39Cea.31043$ws6.620269@news2.nokia.com>

Also you can use USE_SHARED_SOCKET parameter in the registry.

How to enable USE_SHARED_SOCKET on WINNT and Windows 2000

---

As described in Note:66382.1 there is 2 ways to make ORACLE work in a firewall environment.

This can be handled by applying a firewall that has a SQL*Net proxy built in.
The way this works is that the SQL*Net proxy starts another listening process
(usually on port 1610). This causes the firewall to act like a Connection Mananger or Multi Protocol Interchange.

The second way to resolve this issue is to upgrade the server to 8.0.x or 8.1.x
and to set the USE_SHARED_SOCKET parameter in the registry in order to activate port sharing under WINNT. The parameter is available in Windows NT 4.0
(SP3 or higher) and Windows 2000 when Winsock 2 support is installed. With this
method, it is also possible to use firewalls which only supports port filtering
and no SQL*Net proxy. At least for dedicated connections. Multi Threaded Server
(MTS) still needs to redirect the connection to a dynamic port and therefore requires a SQL*Net proxy.

In Windows NT port sharing can be activated by setting

USE_SHARED_SOCKET = TRUE in the system environment (Control Panel, SYSTEM environment). I Windows 2000
this is done also by the SYSTEM button in the control panel, but environment variables are specified and found by clicking the "Advanced" button.

The parameter can also be set within the WINNT registry under \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE (Relases 8.0) or \\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<#> (Release 8i )

Both methods require a shutdown/startup of the nt server

A pitfall of this option is all connections will stay on the Listener port and if the Listener is stopped or restarted, all connections are severed from the database.

---

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:O9pea.4386$dE2.10088_at_newsfeeds.bigpond.com...
> The firewall is probably your problem. Whilst you may open port 1521 on
it,
> that only gets you as far as the Listener. The Listener than spawns a
server
> process to run on any random port number, and it is to that server process
> you then have to connect to make a connection to the instance.
>
> Likely, your firewall is blocking those random ports on which the server
> processes can be contacted.
>
> You'll need to investigate CMAN (connection manager) if you want to use
> Oracle Net Services to drill through the firewall. Or you'll need to
invest
> some dosh in a firewall which is Oracle-aware.
>
> Regards
> HJR
>
>
Received on Fri Mar 21 2003 - 04:51:43 CST