Database Software

Hi,

For 2 databases, I'd like to use Clusterware & ASM on a cluser with 3 nodes (but the client does not want RAC...but he could change his mind...)

- 1 ASM instance per node (which share all raw devices on a SAN), each ASM instance handles the two databases
- With 10gR2, a mono-instance database can use an ASM instance of a cluster node (normally)
- node #1 for database A (mono-instance), node #2 for another database B, and node #3 for failover
- Database A or B can therefore work on every node

What I'm not sure is:

- In Rac, there is one oracle-vip per node, when node #1 fails, its oracle-vip is restarted on another node in order to answer "node not available" to the clients that were connected to node #1, so that the client can reconnect to another node....

- Wihtout RAC database, I'd like to know if the client can configure FAILOVER=ON in its tnsnames.ora to reconnect to the active node ? Simply put, can the client detect the failover of the mono-instance database ?


Does anyone did that kind of architecture ?

Thanks in advance