Is it possible for RAC client to reconnect to VIP2 without having to wait for failover of VIP1?
I have a two node RAC installation, 10.2.0.4, on RHEL 5.4, 64-bit. Some clients are on MS Windows XP, and some are on RHEL 5.4. This is a test system. RAC nodes are installed on vmware virtual machines. The problem that I am describing was detected when working from MS Windows XP client machine.
Situation:
Both nodes are up. Client application connects to database via node 1. Database connection, by design, opens and closes multiple times during application operation. I test failover by shutting down node 1. Immediately after initiating shutdown, I keep making changes in client application, which makes the application try to open new connections to the database. But the problem is, the connections cannot be established. VIP1 fails over to node 2 after approximately 4 minutes. The application succeeds in inserting data into database after about 10 to 15 minutes. If I restart the entire application (not just the database connection), it connets to node