23Sep/096
Could not locate OCI dll Error
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.
October 7th, 2009 - 07:13
can you post the image or list what files you copied. The image is not showing. Thanks!
November 4th, 2009 - 07:08
I’ve got the same problem, but I can’t see your screen shot. Could you email it to me?
November 25th, 2009 - 00:52
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?
December 2nd, 2009 - 07:04
sorry guys,! I have updated the post to include the screenshot.
December 14th, 2009 - 08:11
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…
January 20th, 2010 - 22:42
Thanks man.Its working.