Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> slow local connections
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 - 19:39:12 CDT
![]() |
![]() |