Hi all,
Is there any way to take advantage of the 10g RAC feature (cluster) using the net option in VCL version ? Or should we implement our proprietary management ?
e.g.: using N orasession components (one for machine in the cluster), cycling on the first that is responding ? This really is not what RAC offers (through Oracle's ODBC you notice only a small pause in a query in case of node crash, and then the query continues on the next alive node of the cluster). Using such a solution (multiple ToraSessions) does not preserve the application from crashing, but at least we could:
- quit and restart the application that automagically should open the "next" live node in the cluster.
- replace our applications when the geometry of cluster changes (should we throw more nodes in the cluster) without reconfiguration.
If ODAC could use the ORACLE naming service, it automatically could gain access at the benefit of RAC: uninterrupted operations.
Thanks
Claudio