Re: Connection problem ORA 12535 TNS Timeout

From: Bernd Maierhofer $dato$ <bernd.maierhofer_at_dato.at>
Date: Tue, 02 Mar 2004 08:42:37 GMT
Message-ID: <1OX0c.156762$174.48887@news.chello.at>

On my client I have

BF1.DATO.LOCALHOST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = bf1)
    )
  )

The error with BEQ was logged at the server´s, so I think there is something wrong with the server´s protocol?

> >>Hold your horses! - this is BEQ, i.e. local.
> >>Your ORACLE_SID environment variable is not set!

> The client should do (this is from the CLI):
>
> sqlplus system/manager_at_myserver
>
> Your client should have a tnsnames.ora file (default location
> is %OH%\network\admin), with the entry:
>
> MYSERVER =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> )
> )
>
> Of course, your HOST = entry, and SID = would be different in your case.
>
> Let's take it from there.
>
> BTW - you run Win2k + VMWare + Win2K Pro just to test a server?
We have VMWare boxes for the various DBServers/Configurations we need for development.

brgds
Bernd Received on Tue Mar 02 2004 - 02:42:37 CST