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 -> Re: Slow establishing SQL*Net connection to DB

Re: Slow establishing SQL*Net connection to DB

From: John P. Higgins <jh33378nospam_at_deere.com>
Date: 1998/01/31
Message-ID: <34D3DD6D.55AF@deere.com>#1/1

Leigh Satchell wrote:
>
> We have a HP3000 running MPEiX OS and oracle ent server 7.2.3. When
> connecting via a SQL*Net connection it takes about 1 minute to establish
> the connection. After that the speed is fine. All inward connections,
> whether it is via a DB link or using a client tool have this slow
> connection problem. Can anyone shed some light on whether this is a
> listener config problem or something? I don't believe it is name
> resolution related since the xxxx.ora files have the IP address not host
> name.
>
> Thanks in advance,
>
> Leigh.
> City of Greater Geelong
> Australia.
>
> lsatchell_at_geelongcity.vic.gov.au

Check DNS. I have seen this when the server cannot identify the client via DNS. It accepts the unknown address anyway, but first it has to wait for the DNS timeout! Received on Sat Jan 31 1998 - 00:00:00 CST

Original text of this message

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