Re: Connection problem ORA 12535 TNS Timeout

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: 26 Feb 2004 09:32:01 -0800
Message-ID: <14a1f766.0402260932.323fb174@posting.google.com>

"Bernd Maierhofer \(dato\)" <bernd.maierhofer_at_dato.at> wrote in message news:<h0l%b.84079$174.57043_at_news.chello.at>...
> Howard,
> thanks for the detailed answer. We have had no trouble using 8.1.5 on Win2k,

Yeah, I know. I had no trouble either. But it still isn't supported, and you can (and will) run into issues.

> only since we tried to setup the server in the VMWare box.

Pretty big "only"!

>But I will pay
> attention to your advice using v9. Btw VMWare is v3.0.0

Well, that's a bit ancient as well. They're up to version 4:6030 these days.  

> The listenr.ora on the server loks like this:
> # C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration
> File:C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora
> # Generated by Oracle Net8 Assistant
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> (PROTOCOL_STACK =
> (PRESENTATION = TTC)
> (SESSION = NS)
I'm sure there's a reason for having the PROTOCOL_STACK section in there, but for the life of me I can't think what it might be. Care to enlighten me?

If your file were to read simply:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
      )

    )
   )

 SID_LIST_LISTENER =
   (SID_LIST =

     (SID_DESC =
       (GLOBAL_DBNAME = bf)
       (ORACLE_HOME = C:\Oracle\Ora81)
       (SID_NAME = bf)
     )

   )

...then what happens?

Regards
HJR Received on Thu Feb 26 2004 - 11:32:01 CST