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

Are you sure you are referencing *only* the VIP, and *NOT* the physical IP, not only in the connect string definition, but also in the local_listener, and remote_listener parameter, on all nodes? Please check all of these.

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak_at_proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
Sent: Tuesday, September 02, 2008 11:18 AM
Cc: ORACLE-L
Subject: Re: Long connect time when one node in RAC goes down

Problem update:

We run trace level=16 and found that failover works fine. The client
immediately get: NO LISTENER and fails over as expected.
 From time to time the response is bad and we get: TNS TIME OUT instead
of NO LISTENER.

Adar Yechiel
Rechovot, Israel



Yechiel Adar wrote:


> We need some help.

> RAC, Oracle 10.2.0.3 on windows 2003 servers  64 bit.

>

> We did a fail over test. We disconnected one server from the network

> by pulling the network cable.

> The system worked fine, but once in a while a connection will take 6

> seconds instead on 20 ms.

> We understand that this happens because the VIP is moved to the second

> computer and there is

> nothing there to handle calls on that TCP address.

>

> I would like to know how to shorten the time from 6 seconds to almost

> nothing.

>

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


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