Solution for connecting PLSQL developer to 64-bit Oracle 10 GB

Download instantclient-basic-win32-10.2.0.4.zip

Assume that the installation directory of Oracle 10 Gb is D: \ oracle \ product \ 10.2.0 \ db1

First, extract instantclient-basic-win32-10.2.0.4.zip to the local disk D: \ oracle \ product \ 10.2.0 \ instantclient_10_2

Copy the D: \ oracle \ product \ 10.2.0 \ db1 \ Network \ admin \ tnsnames. ora file under the root directory of the database installation.

Go to the Oracle Client Directory D: \ oracle \ product \ 10.2.0 \ instantclient_10_2

Finally, configure ORACLE_HOME and OCI library of PLSQL developer

Instantclient_10_2 should not be selected in the drop-down box

Paste instantclient_10_2 and D: \ oracle \ product \ 10.2.0 \ instantclient_10_2 \ OCI. dll directly.

Start PLSQL developer ......

Msvcr71.dll cannot be found.

It does not matter. Copy the D: \ oracle \ product \ 10.2.0 \ db1 \ bin \ ctxhx \ msvcr71.dll file.

Go to the Oracle Client Directory D: \ oracle \ product \ 10.2.0 \ instantclient_10_2

Restart PLSQL developer. The problem is fixed.