Select Tools > Preferences > Options > Under plsql Developer: "Oracle Home" and "OCI Library"
oracle10g in D:/oracle/oracle home for d:/oracle/product/10.1.0
OCI Library for D:/oracle/product/10.1.0/db_1/bin/oci.dll
Restart Plsql Developer after configuration, login successful
After the configuration login still error:
Could not load ".../bin/oci.dll"
Ocidll forced to ...
LoadLibrary (... oci.dll) returned 0
The workaround is to install the 32-bit Oracle client on a 64-bit machine. This will make the connection successful.
Basis:
From the installation point of view, the 32bit platform (operating system and hardware system) only support 32bitORACLE installation;
The 64bit platform supports both 32bitORACLE installations and 64-bit Oracle installations.
According to the post in the official forum of PL/SQL Developer:
Quote
--------------------------------------------------------------------------------
I am not too fond of installing both and a bit of Oracle clients on same machine-does it work at all?
--------------------------------------------------------------------------------
Yes, this works fine. --This is the administrator's reply
PL/SQL Developer is written in Delphi.
The first thing that needs to become available is a a-bit version of the Delphi IDE.
Another post also mentions:
Hi when install in Windows Server 2003 R2 X64.
When I try to connect a account, I has the following message:
Initialization error
Could not load "E:/oracle/product/10.2.0/bin/oci.dll"
--The following is an administrator's reply
Is this a a-bit Oracle Client DLL?
If So, please note the need to install a of the Oracle Client to use a of the application like PL/SQL Developer.
Call, finally solved, on the customer's web machine is unable to use PL/SQL to connect to the Oracle database on Linux
Sql/plus sql*net not properly installed solution when connecting to Oracle
