Page 1 of 1
Direct mode and RAC server
Posted: Tue 18 Oct 2011 14:16
by TZ
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
Posted: Wed 19 Oct 2011 06:01
by AlexP
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.
Posted: Wed 19 Oct 2011 13:08
by TZ
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
Posted: Thu 20 Oct 2011 06:55
by AlexP
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.