Re: ODBC-error 'ORA-12535: TNS:operation timed out' when trying to connect to Oracle 9.2.0

On Mon, 28 Aug 2006 11:29:16 +0200, "Christoph Ebner von Eschenbach" <C.EvEschenbach_at_gmx.de> wrote:

>This can be solved by adding a registry entry on the server:
>Under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0, an entry USE_SHARED_SOCKET
>(Type Reg_SZ) has to be added and set to TRUE.
>Then all inside/outside connections will be made only via the predefined
>listener port (1521, if not changed otherwise).
>
>Afterwards communication operated flawlessly.

However be aware, if you stop the listener, all sessions will be disconnected now.

--
Sybrand Bakker, Senior Oracle DBA