Browse: Home » Blog » Oracle » Could not locate OCI dll Error

Could not locate OCI dll Error

admin September 23, 2009 14

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 ORAHOMEbin. 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.

oracle_files_copy_to_bin

, , ,

14 Comments

  1. Eric
    Eric October 7, 2009 at 7:13 am . Reply

    can you post the image or list what files you copied. The image is not showing. Thanks!

  2. Charlie
    Charlie November 4, 2009 at 7:08 am . Reply

    I’ve got the same problem, but I can’t see your screen shot. Could you email it to me?

  3. Marco
    Marco November 25, 2009 at 12:52 am . Reply

    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?

  4. kwatog
    kwatog December 2, 2009 at 7:04 am . Reply

    sorry guys,! I have updated the post to include the screenshot.

  5. Frank Quednau
    Frank Quednau December 14, 2009 at 8:11 am . Reply

    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…

  6. Bhageerath
    Bhageerath January 20, 2010 at 10:42 pm . Reply

    Thanks man.Its working.

  7. Ravi Bhatt
    Ravi Bhatt August 11, 2010 at 5:45 am . Reply

    Hi,

    I encountered the same issue with Oracle 11g when I was trying to login using PL/SQL Developer.

    I came across some steps which are worth sharing. And its clean means no ddl copying is involved.

    Steps:

    1) Login to PL/SQL Developer
    2) Go to Tools
    3) Click Preferences
    4) Click Connection in preferences pop-up
    5) Select “Orahome90″ under Oracle Home dropdown
    6) Apply the changes
    7)Close the PL/SQL shell 8) Login again to PL/SQL Developer

    And the error is no more.

    Hope this post is worth to all the people encountering the same problem.

    Thanks,
    Ravi Bhatt.

    1. Muthu
      Muthu March 25, 2011 at 1:50 am . Reply

      Dear Ravi,

      I saw your response for this post. i am also facing the same problem.But i am using oracle 10g. PLSQLDeveloper version is 5.0.3 . in the prefernece menu of tools menu oraclehome doesn’t display any oracle home details.It’s EMPTY. But i can connect TOAD using my oracle 10g. it works fine. PLSQL dev not referring oracle TNS names.

      Could u pls provide solution for this ?

      Regards
      Muthu

    2. Beulah wilson
      Beulah wilson May 9, 2012 at 8:50 am . Reply

      Thank you Ravi :) ….Your post was indeed very worth and useful to solve the prob :)

  8. kwatog
    kwatog August 11, 2010 at 9:09 pm . Reply

    Thanks Ravi Bhatt! The steps you provided works!

  9. Thameera
    Thameera August 30, 2010 at 1:30 am . Reply

    Thanx a lot it works :)

  10. Alex
    Alex November 10, 2010 at 5:10 am . Reply

    Thank you

  11. Divya
    Divya December 9, 2010 at 5:20 am . Reply

    Thanks a lot.!!!!!!!
    Its working…..

  12. PACE
    PACE November 22, 2011 at 4:10 am . Reply

    Thanks, had this same problem after a fresh Windows install with 11g – working again

Post Comment