Could not locate OCI dll Error
9.23.2009 | Oracle
If you are using 10g client with PL/SQL developer, you may encounter the message “Initialization error: Could not locate OCI dll” when launching PL/SQL Developer. It does not happen with the 8i client so I already suspected that it must be with the 10g client that I recently installed. Luckily, I found this thread in Oracle OTN forum and the solution seems to be easy.
All I have to do is copy a whole bunch of files from the ORAHOME folder to ORAHOME\bin. It seems like PL/SQL Developer is hardwired to find the files under the bin folder. It did the trick and my sql editor is now working. I hope it fixes yours too.
Here’s the screenshot of the files I copied. Take note that I copied them instead of just moving so as not to break anything.
10.07.2009
can you post the image or list what files you copied. The image is not showing. Thanks!
11.04.2009
I’ve got the same problem, but I can’t see your screen shot. Could you email it to me?
11.25.2009
Same problem here.
I have no files in my ORAHOME folder, only subfolders. So I don’t know what to copy. Can you please publish the screenshot or mail it to me?
12.02.2009
sorry guys,! I have updated the post to include the screenshot.
12.14.2009
That’s indeed the answer. Which is kinda horrible. I have some simple Oracle client for 11g installed which already has a bin directory…alas, it contains stuff related to mts etc. What a mess…
1.20.2010
Thanks man.Its working.