Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> slow local connections

slow local connections

From: Steve Perry <sperry_at_sprynet.com>
Date: Wed, 29 Sep 1999 19:39:12 -0500
Message-ID: <7subb7$e08$1@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 - 19:39:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US