Direct mode and RAC server

TZ · Post by TZ » Tue 18 Oct 2011 14:16

Can ODAC connect in direct mode using Service_Name instead of SID?
We have RAC environment and Service_Name is different then SIDs behind it. If I connect dirrectly to SID I am bypassing cluster altogether and connecting directly to a node? any suggestions?

Thanks

Taras

AlexP · Post by **AlexP** » Wed 19 Oct 2011 06:01

Hello,

To connect using ServiceName, you should use the following syntax:

Server:Port:SN=ServiceName

For the time being ODAC does not support the RAC technology (automatic switching between servers) in the Direct mode, but you can connect to each server separately in the Direct mode. We plan to add full support for the RAC technology in the Direct mode in one of the future ODAC versions.

TZ · Post by TZ » Wed 19 Oct 2011 13:08

Thanks, it worked. So if specify SN it will randomly pick one of the sids SID on login?

>but you can connect to each server separately in the Direct mode
You mean by specifying individual SIDs?

10x

Taras

AlexP · Post by **AlexP** » Thu 20 Oct 2011 06:55

Hello,

If the direct mode is used when connecting to RAC servers, connection will be established to the server address or name of which was specified in the connection string. And it won't depend on the fact if connection is established using SID or ServiceName.