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