[Oracle]-use 32-bit plsql (PL/SQL Developer) to log on to 64-bit Oracle failure resolution

Configuring the Environment

Oracle Service Side
Oracle_winx64_12c_database.iso

Oracle Client
Instantclient-basiclite-nt-12.1.0.1.0.zip

Integrated development Environment
PL/SQL Developer 10.0.5.1710

Configuration steps

Make sure that Oracle has completed the configuration and can use SQL Plus to log on successfully.

If using PL/SQL to log in to Oracle fails, the error is as follows:

Login Failure Reason Analysis:
64-bit Oracle installation path: e:appadministratorproduct12.1.0dbhome_1
64-bit Oracle OCI path: E:appadministratorproduct12.1.0dbhome_1binoci.dll
After the successful installation of PL/SQL, the two information is used by default, Plsql developer is a 32-bit application and does not support 64-bit OCI, so the login failed.

Download and unzip the Oracle client Instantclient-basiclite-nt-12.1.0.1.0.zip.
32-bit Oracle Client path: e:appadministratorinstantclient_12_1
32-bit Oracle Client OCI path: E:appadministratorinstantclient_12_1oci.dll

Configure the PL/SQL preferences as follows:

Reboot the system and use PL/SQL to log in successfully.

[Oracle]-use 32-bit plsql (PL/SQL Developer) to log on to 64-bit Oracle failure resolution