RE: RAC and tcp timeout

David,

What do you mean by 'server1 has died'? It can be that the instance has died, but node is up with the listener on it routing connections to the second node. Appreciate more details on it.

Assuming that your node is down, then if the connections are taking more time, then it could be related to tcp timeout and configuration entries.

If you are using client side load balancing, then try an entry like this :

<connect_string>=
(address_list(         

Address=(protocol=tcp)(host=<your_server2_goes_here>)(port=xxxx) ))

Based on the above entry , if you still see the delay, then it could be from the OS.

Thanks,
-Sudhi.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
Sent: Wednesday, August 10, 2005 1:17 AM To: davidsharples_at_gmail.com; racdba_at_freelists.org Cc: oracle-l_at_freelists.org
Subject: Re: RAC and tcp timeout

David:

Can you pls send the tnsnames and listener file entries. I guess it is related to configuration issues.

Anand/Sudhi,

Do you guys have any ideas, Pls reply to David direclty .

Thanks
Gopal

On 8/10/05, David Sharples <davidsharples_at_gmail.com> wrote:
> 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
>

-- 
Best Regards,
K Gopalakrishnan 
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
http://www.freelists.org/webpage/oracle-l


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