Re: slow local connections

allow me to take a wild guess.

since you can connect locally without using @connectstring, and you can get the connection immediately on other server/workstation thru sqlnet. I really don't think it's anything to do with the listener or the database. How about the resolve names of the system? Would it be that this system has a DNS server to resolve the name and the entry of that name is wrong, it got timed out and then dumped back to the /etc/hosts file to resolve the name? (as I said.. just a wild guess!)

Winnie Liu
DBA
Infonet Services Corporation
mailto:winnie_liu_at_infonet.com

Steve Perry wrote in message <7subb7$e08$1_at_nntp2.atl.mindspring.net>...
>I'm stumped on this. When I try and connect locally to a database using
>sqlplus system_at_sid or exp... It hangs for several minutes and then
connects.
>the same thing happens when I tnsping it (see below). If I switch over to
>another server or my workstation, it comes back immediately. I can set the
>sid and connect immediately on the server. It chokes when I use the "@sid".
>This is on a E10000. Solaris 2.6 and oracle 8.0.5. I did compare other
>servers and the sqlnet and listener files use the same settings. The only
>difference I noticed was when I typed "adapters", The e10000 didn't return
>anything, but most servers had all the protocols.
>If I tnsping it with the connect string (i.e. tnsping
>"(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=pbvisprod)(Port=1526))"
)
>, it returns immediately.
>
>Anyone want to venture a guess???
>
>Thanks,
>Steve
>
>date; tnsping pbvis; date
>
>(begin time)
>
>Wed Sep 29 17:59:31 CDT 1999
>
>TNS Ping Utility for Solaris: Version 8.0.5.0.0 - Production on
>29-SEP-9917:59:31
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>Attempting to contact
>(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=pbvisprod)(Port=1526))
>OK (0 msec) <--- 0 msecs but check the end time...
>
>(end time)
>
>Wed Sep 29 18:02:53 CDT 1999
>
>Lapse time 3.5 minutes...
>
>
Received on Wed Sep 29 1999 - 23:47:07 CDT