HA Events with RAC
20172Apr 18 2006 — edited Apr 19 2006Is anybody familiar with the HA Events and RAC?
I use a RAC with 2 instances. After shutting down the instance to which my client is connected, I would expect that the lost connection pool is recreated automatically on the surviving instance. But it isn't.
Using HA Events in the connection string, I receive a failover event on the connection after the instance shutdown. But only 6 minutes later.
6 minutes seems useless to me, maybe it relates to the connection pool management cycle which is 3 minutes according to the documentation.
After doing the failover, the connection pool is not recreated either.
e.g. if I had 3 connections on the crashed instance, I only see 1 connection after the failure (looking at v$session).
I don't think, that this is a setup or configuration problem.
Has anybody some experience on this and can tell me how the HA Events are supposed to work?
Maybe the Oracle development team can help?
Thank you.