9.4.11 - RAC server support is improved

[IgorM]

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

Could you please explain?

[AlexP]

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).

[albourgz]

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?

[AlexP]

Hello,

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

Code: Select all

OraSession1.ConnectString := 'scott/[email protected],n2.domain:PORT1,PORT2:SID'

[albourgz]

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.

[AlexP]

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.