How to pick the right DLL for the PL/SQL Developer?

[Rahul P]

DLLs
C:\oraclexe\app\oracle\product\10.2.0\server\bin\oci.dll

TNS File
C:\oracle\product\11.1.0\client_1\network\admin\tnsnames.ora

I installed XE for some testing and I cannot connect using PL/SQL Developer anymore. I think it's picking up the wrong DLL? maybe?

 

[Rahul P]

Ok, I changed the PATH to make the XE install to go the end so, it picked up the right DLL this time, but, I still cannot connect. Here is my info.

Homes
OraClient11g_home1 (C:\oracle\product\11.1.0\client_1)
XE (C:\oraclexe\app\oracle\product\10.2.0\server)

DLLs
C:\oracle\product\11.1.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\11.1.0\client_1\network\admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\11.1.0\client_1\bin\oci.dll
OCI: version 11.1

 

[Marco Kalter]

What exactly goes wrong when you try to connect? Can you connect to the same database with C:\oracle\product\11.1.0\client_1\bin\sqlplus.exe?

 

[Rahul P]

Ok, looks like it was a clash between XE version and 11gR2 client. I ended up deleting the 11gClient and everything connects fine, but, I am still stumped at this info.

Homes
XE (C:\oraclexe\app\oracle\product\10.2.0\server)

DLLs
C:\oraclexe\app\oracle\product\10.2.0\server\bin\oci.dll

TNS File
C:\oraclexe\app\oracle\product\10.2.0\server\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oraclexe\app\oracle\product\10.2.0\server\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

My question is where is it picking up the word

Home: OraClient10g_home1

and OCI Version 11.1 (Do you think that XE 10g version only - comes with 11.1 oci version?)

I don't have the 11gR2 client on my machine, and any 10g_home1 client either.

 

[Marco Kalter]

The OCI version 11.1 is probably a bug. Are you using PL/SQL Developer version 8.0.4? It should display the correct version.

 

[Rahul P]

Version 8.0.0.1480

And yes, it says oci version 11.1

 

[Marco Kalter]

Version 8.0.4 should fix this.