View Single Post

   
  #7 (permalink)  
Old 04-08-2008, 11:14 AM
Sybrand Bakker
 
Posts: n/a
Default 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@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
Reply With Quote