Could not locate oci.dll error

Suzana

Member
Hello,

I just installed PL/SQL developer on a Windows box (Windows Server 2003 32 bit) that has an Oracle client 11.2.0.3 32 bit installed on it. When trying to connect to PL/SQL developer I was getting the below error :
"Initializatiin Error"
Could not locate OCI dll

In one of the forums I found an answer to the same problem. The answers says to copy the OCI.dll from $ORACLE_HOME to $ORACLE_HOME/bin and then in the PL/SQL preferences to enter values for the "ORACLE HOME" and "OCI library (enter the location for $ORAVLE_HOME/bin/oci.dll") and also check "Force OC17 mode on OC18". Reconnect to PL/SQL developer after saving the new values
After all this I can connect successfully however when issuing any query or update I'm getting :

SQL> select username from dba_users;

Done

SQL>
Any help will be much appreciated..
 
Last edited:
Can you undo all these changes and enter \oci.dll into the "OCI Library" preference? Leave the "Oracle Home" preference empty and disable the "Force OCI7 mode on OCI8" option.
 
Back
Top