Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HA Events with RAC

20172Apr 18 2006 — edited Apr 19 2006
Is 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2006
Added on Apr 18 2006
3 comments
1,216 views