Implement RAC ourselves

[bmarotta]

Hi,

we are running Oracle on a RAC and using Direct Mode. Currently we have the problem that if the node we are connecting is not available, we have to manually config the ConnectionStrings in the configs and restart all our services.

We were thinking about having one connection string for each RAC server (currently 2) so that we can switch without having to change the configs. To implement this we have to first be able to identify if a node is alive and second do it always before opening a connection.

The problem is that the Devart Connection Pool is a black box. When using a Context, one never knows when the connection is open and if an error happens in the opening of the connection, it is already too late for switching the Connection String.

Would you have any suggestion how we can intelligently "ping" the servers to know which is the master one, before opening the connections and also without adding too much overhead to the DB communication?

Best regards,

Bruno Marotta

[Pinturiccio]

Its not possible to identify whether a node is alive in dotConnect for Oracle before opening a connection. You can only open a connection to one node, and if it throws an exception, handle it and try connecting to another node.