Toad World® Forums

Cannot load OCI: C:\Oracle\product\12.2.0\client_1\BIN\OCI.dll

On Toad for Oracle version 13.1.0.78
Uninstalled 11g client on my desktop. Installed 12.2 client on my desktop. SQL+ works without issues with the 12.2 client.

I'm getting Cannot load OCI: C:\Oracle\product\12.2.0\client_1\BIN\OCI.dll error on TOAD. The file does exists in that directory, but somehow TOAD cannot load / see it?

Thank you

Check to see if the deinstallation of the 11g client was complete. Maybe it's still in the path, a few pieces still on your hard drive, etc.

Environment variable shows Path going to C:\Oracle\product\12.2.0\client_1\bin;
Nothing left in the folder anyway. But for precaution, I deleted the 11g client and rebooted before installing 12.2 client.

Does the bitness match? 32 bit Toad requires 32 but Oracle client. 64 bit Toad requires 64 bit Oracle client.

Yes. I have Toad for Oracle (64bit) and I installed 64 bit client

Any other clients installed or is this the only one?
I think I remember seeing this before when I had both 12.1 and 12.2 client installed at the same time.

If you do, you can temporarily rename the folder of your 12.1 client to see if that fixes.

No other client on this machine. Also, Toad is able to ID the client (under "Connect Using:"). I also checked "Make this the TOAD default home"

Well that simplifies things. Toad 13.1 should work with that client.

I wonder if something is off in the registry. I have done the following with success when I've had client problems.

  1. delete the 12.2 client
  2. make sure there is no trace of any oracle client on hard drive, system path, or registry - specifically HKLM\SOFTWARE\ORACLE. you can just delete that node after deinstall. Also check HTML\SOFTWARE\Wow6432Node\ORACLE for good measure)
  3. reboot
  4. If you have 64 bit Toad, you must use 64 bit Oracle client.
    If you have 32 bit Toad, you must use 32 bit Oracle client.
    Reinstall oracle client

So deinstall, check registry, reboot and reinstall the client?
Will try that and update the thread.
Thank you djorlon!

Make sure all of these are clear: registry, system path, and hard drive.

Thank you John Dorlon; cleaning up registry fixed it.
HKLM\SOFTWARE\Wow6432Node\ORACLE still has a bunch of 11g client info.

2 Likes

Excellent, glad to hear it.