Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.stueberl.de!newsfeed.utanet.at!newsfeed01.chello.at!news.chello.at.POSTED!53ab2750!not-for-mail
From: "Bernd Maierhofer \(dato\)" <bernd.maierhofer@dato.at>
Newsgroups: comp.databases.oracle.server
References: <mc5%b.76818$174.71933@news.chello.at> <14a1f766.0402251551.a2df89a@posting.google.com> <h0l%b.84079$174.57043@news.chello.at> <14a1f766.0402260932.323fb174@posting.google.com> <nlG%b.97290$174.53470@news.chello.at> <c1nqn9$828$1@news2.tilbu1.nb.home.nl> <9DF0c.146839$174.73348@news.chello.at> <c206ll$89m$1@news4.tilbu1.nb.home.nl> <1OX0c.156762$174.48887@news.chello.at> <c22rmb$lmf$1@news3.tilbu1.nb.home.nl>
Subject: Re: Connection problem ORA 12535 TNS Timeout
Lines: 141
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <FPj1c.166806$174.16930@news.chello.at>
Date: Wed, 03 Mar 2004 12:02:45 GMT
NNTP-Posting-Host: 80.110.251.38
X-Complaints-To: abuse@news.chello.at
X-Trace: news.chello.at 1078315365 80.110.251.38 (Wed, 03 Mar 2004 13:02:45 CET)
NNTP-Posting-Date: Wed, 03 Mar 2004 13:02:45 CET
Organization: Customers chello Austria
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256192

> 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

(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)


Thanks for your assistance!

Bernd