Re: Connection problem ORA 12535 TNS Timeout

From: Bernd Maierhofer $dato$ <bernd.maierhofer_at_dato.at>
Date: Wed, 03 Mar 2004 12:02:45 GMT
Message-ID: <FPj1c.166806$174.16930@news.chello.at>

> 1) your remote machine (the server) is called "oracle"; you
> can ping oracle.

As I did a new setup, the machine is now calles oracleserver, but yes, I can ping it.

> 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

> 3) On your server "oracle", you installed 8.1.5 RDBMS, with a SID
> called bf1. You did not give any domain to the database.
Actually it is 8.1.6, the SID is BF1 (I tried both connect via 8.1.5 method as well 8.1.6)

4) Ergo, you listener.ora on the server must be:
> # LISTENER.ORA Network Configuration File:
> D:\oracle\9iAS\network\ADMIN\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora815)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (SID_NAME = bf1)
> )
> )
>
> Can you verify this, and post listener.ora?
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)
    )
  )

LISTENER.ORA on the remote machine:
# LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracleserver)(PORT = 1521)) )
)

SID_LIST_LISTENER =
(SID_LIST =

     (SID_DESC =
       (SID_NAME = bf1)
     )

)

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) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) 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)
    )
  )

>
> Also, tnsping's of 3 to 9 seconds are way too long!
> 600mSec to 1 sec on a WAN, 500msec or less on a LAN.
> I got 50msec on my (tiny) LAN, <10msec local, using tcp/ip.
The initial connect needs 3-9 secs, teh following tnspings are 30msec:

TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on 03-M?R-2004 12:46:56

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)

Thanks for your assistance!

Bernd Received on Wed Mar 03 2004 - 06:02:45 CST