Oracle RAC and OCI.DLL

Lass.Mint · Post by **Lass.Mint** » Fri 23 Mar 2012 09:36

Hi Devart Team,
I have two questions about ODAC. We use version 7.00.0.2.

1. Will ODAC ever support Oracle RAC in direct mode? One of our customers has asked for this as they plan to use RAC soon. They have managed to connect to RAC using client mode, but would like to use direct mode.

2. How does ODAC find the OCI.DLL? Only by PATH or also using the registry? Background: We have a PC where there is an Oracle 8 client installed and an 11.2 instant client extracted to some other directory. The instant clients path is included in the PATH environment variable (first position), but it seems ODAC still tries to use the Oralce 8 client. The instant client is only used, if I copy the .exe file of our application into the same directory as the instant client. Can you please tell me in which order ODAC searches which places for the oci.dll?

Thanks for your support.

Kind Regards,
Eric

AlexP · Post by **AlexP** » Fri 23 Mar 2012 11:30

Hello,

1) You can connect to Oracle RAC servers in Direct mode, however, the automatic server switch mechanism is not supported yet. We plan to implement this feature in future.
2) The "installable" Oracle client is considered to be more high-priority, so firstly, the search is performed in the registry, and if the information about Oracle clients is not found in the registry, search is performed in the environment variable. Therefore, if you need to use instant client as basic, in case of presenсe of installed clients, you also should include thу information about this client in the registry and specify it as basic.

Lass.Mint · Post by **Lass.Mint** » Mon 26 Mar 2012 06:59

Thank you very much for the quick answer, Alex.

AlexP · Post by **AlexP** » Mon 26 Mar 2012 07:14

hello,

If you have any other questions, feel free to contact us.