Re: Connection problem ORA 12535 TNS Timeout

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 03 Mar 2004 22:15:32 +0100
Message-ID: <c25hqd$ihd$1@news4.tilbu1.nb.home.nl>

Bernd Maierhofer (dato) wrote:
> As I did a new setup, the machine is now calles oracleserver, but yes, I can
> ping it.

Good.

>

>>2a) your sqlnet.ora file (sits next to tnsnames.ora) contains
>>an entry default_domain = DATO.LOCALHOST, or:

>
> SQLNET.ORA on the remote machine:
> # SQLNET.ORA Network Configuration File:
> C:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = dato.localhost
>

As predicted ;-)
>

> TNSNAMES.ORA on the remote machine:
> # TNSNAMES.ORA Network Configuration File:
> C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> BF1.DATO.LOCALHOST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = bf1)
> )
> )
>

>
you might want to consider chenging:

        (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521)) to:

        (ADDRESS = (PROTOCOL = IPC)(KEY = BF1)
>
> LISTENER.ORA on the remote machine:

OK
> SQLNET on the client:
> # SQLNET.ORA Network Configuration File:
> c:\Oracle\Ora81\network\admin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = dato.localhost
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>

Did you install advanced security? Comment it out, as: # SQLNET.AUTHENTICATION_SERVICES= (NTS)
and see it it speeds up initial connections

> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Lose ONAMES, perhaps HOSTNAME as well:
NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> TNSNAMES.ORA on the client:
> # TNSNAMES.ORA Network Configuration File:
> c:\Oracle\Ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> BF1.DATO.LOCALHOST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = bf1)
> )
> )

To rule out a DNS problem, change (HOST = oracleserver) to (HOST = 10.10.10.xxx)

>
> TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on
> 03-M?R-2004 12:46:56
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver)(PORT=1521))
> OK (9020 msec)
> OK (30 msec)
> OK (30 msec)
> OK (30 msec)
> OK (30 msec)
> OK (30 msec)
> OK (30 msec)
> OK (20 msec)
> OK (30 msec)
> OK (30 msec)
>

inline... lots of snipping...

The above could be security, could be a DNS problem. Try both - all else looks fine to me, as far as I can judge from over here.

-- 

Regards,
Frank van Bortel

Received on Wed Mar 03 2004 - 15:15:32 CST