Devart Forums

Hi!
what is "RAC server support is improved" in new features list of ORACLe 9.4.11

Could you please explain?

Hello,

The previous versions didn't support RAC servers in Direct Mode. Now you can specify several hosts or the full record from tnsnames.ora - then ODAC will attempt to connect to the specified hosts one by one (it will connect to the first available one).

I use odac 9.4.14 - C++ builder pro XE6.

Now you can specify several hosts or the full record from tnsnames.ora .
How do I specify several hosts? Suppose I have n1.domain and n2.domain.
Should I type "n1.domain n2.domain" in server?

Hello,

To connect to RAC, you should set the following ConnectionString:

OK I could connect.
As you said, it always connects to the same node (even with scan-name).

Do you think it will soon be feasible to achieve "load-balancing" / to be connected to a random node of the cluster?

If not, I seriously think about dynamically swapping the sequence of the nodes (on a random way) in the connectString at startup.

ODAC connects to the first available server in the list. If you need access to RAC with all its features, you should use the Oracle client.