Which Oracle Client Home

[orasqldba]

If I have multiple Oracle homes, how does PL/SQL Developer pick one? Is it the first one in the Path?

 

[Marco Kalter]

By default it is indeed the first one in the PATH environment variable. You can select a specific home through Preferences > Oracle / Connection.

 

[orasqldba]

Marco - thank you. I put the path of the 64-bit client and the OCI library in the Preferences. I restarted PL/SQL Developer and when I try to sign on I get this error and logon fails

Initialization error
Could not initialize "C:\ORACLE\11.2.0\CLIENT64\bin\oci.dll"
Make sure you have the 32 bits Oracle Client installed.

OCIDLL forced to C:\ORACLE\11.2.0\CLIENT64\bin\oci.dll
LoadLibrary(C:\ORACLE\11.2.0\CLIENT64\bin\oci.dll) returned 0

 

[Marco Kalter]

If you are using the 32 bit version of PL/SQL Developer you will also need a 32 bit Oracle Client. They must match.

 

[orasqldba]

Marco - Disregard my previous post, I found in your Version 11 manual that PL/SQL Developer requires a 32-bit Oracle client. Someone here found a link that talked about a 64-bit version that will work with the 64-bit Oracle client but the link to download it was broken. Is it possible for us to get the 64-bit version on our current license? Thanks, Phil

 

[Marco Kalter]

Yes. You can download the 64 bit version of PL/SQL Developer 11.0.6 here. For 64 bit it is recommended to use 12.0 though.