One of the reasons why Plsqldev cannot load the Oci.dll in Oracle instantclient properly

This is the way things go:

1. The newly installed WINDOWS10 system is equipped with Plsqldev and Oracle Instantclient, as well as Instantclient sqlplus.

2. Set the ORACLE_HOME environment variable and put the Tnsnames.ora in the correct directory.

3. The problem is that the connection information in the TNSNames is not recognized in Plsqldev. View the information of the loaded library and found that Oci.dll was detected but not loaded.

4. Try to execute sqlplus on the command line, the error prompt is missing msvcr120.dll. So guessing could be the same reason Plsqldev can't load oci.dll.

5. Then install Msvcr120.dll, download from this link: https://www.microsoft.com/en-gb/download/details.aspx?id=40784

6. After the installation is complete, the Plsqldev is in normal use. Guess the same is true for the same problem with Plsqldev in the Windows7 Ultimate N version that was installed.

One of the reasons why Plsqldev cannot load the Oci.dll in Oracle instantclient properly