Re: Long connect time when one node in RAC goes down

From: Riyaj Shamsudeen <>
Date: Tue, 02 Sep 2008 08:35:16 -0500
Message-ID: <>


    Whole point of VIP is to communicate back to the client quickly that no listener is running in that IP address and so connection will try next failover address. Without VIP, connection has to wait for TCP timeouts and then failover. Default TCP timeout values are long affecting failover speed.

    Can you post your tnsnames string and anything in sqlnet.ora from the client machine? I think, there is a problem in the search order for next failover address.

The Pythian Group Personal :  

Yechiel Adar wrote:
> We are using a switch for interconnect.
> There are no network problems.
> The problem is that after the VIP is moved to the other node,
> connecting through this VIP causes a six seconds wait before sqlnet
> get notification that this VIP is not working and please try the other
> nodes on the RAC.
> Adar Yechiel
> Rechovot, Israel


Received on Tue Sep 02 2008 - 08:35:16 CDT

Original text of this message