Re: RAC and tcp timeout

Hi David,
The question is, what type of connection string are you using to connect to the instance? Are you using TAF? If so what type.

You may be using the delay and retries. This could make all connections to server1 wait until they timeout until trying to connect to server2.

-Bryan

Quoting David Sharples <davidsharples_at_gmail.com>:

> HI,
>
> Redhat 2.1, 9.2.0.5, 2 Node RAC.
>
> 2 servers, server1 and server2
>
> server1 has died so all requests for connection are going to server
> two. However new connections are taking somewhere around 3 minutes to
> get in.
>
> tnsping also takes around the same time.
>
> The server2 isn't overloaded (there are no connections).
>
> Does this sound like a tcp timeout issue where the connection is
> waiting too long for a no connection type message. If so which
> setting(s) could it be?
>
> Or could it be something else. The listener setup looks fine on
> visyal inspection
>
> Thanks
> --
> http://www.freelists.org/webpage/oracle-l
>

Bryan Thomas
Senior Performance Consultant
Performance Tuning Corporation
www.perftuning.com
(512)751-5516
bthomas_at_perftuning.com

--
http://www.freelists.org/webpage/oracle-l