Plsql + green version of oracle remote database connection configuration and prompt the lack of msvcr71.dll Solution

Plsql + green version of oracle remote database connection configuration and prompt the lack of msvcr71.dll Solution
I have been using sqldeveloper to connect to the oracle database. This is free of charge and is also officially released. Apart from the slight increase in volume, it is a little slow to start .. by chance, I decided to try plsql and sort out the installation materials. I needed a local oracle database, and then configured it in plsql to connect to the database remotely. it is too difficult to install the local oracle database. If the system cannot be directly mounted (this is a bit of an Arms), it is decided to replace it with a local green database from oracle. download InstantClient and decompress it to D: \ instantclient_11_2 (I will decompress it to this path) to create a tnsnames. ora file with the following content: # tnsnames. ora Network Configuration File: tnsnames. ora # Generated by Oracle configuration tools. demo = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = demo ))) replace the green text with the ip address, port number, and Instance name of the remote database to be connected. replace the red part with the local Instance name (the name is arbitrary, just to distinguish the local instance) and then change this tnsnames. the ora file is thrown into the instantclient directory, and those. the dll file is in a directory. open plsql and prompt you to cancel the logon. Log in directly. Click tools-preference and enter the username and password for database connection, the ip port and Instance name of the database, as shown in: it should have been enough, but it is not always so smooth... then the system prompts that the msvcr71.dll file is missing. If you choose to use one-click repair, the one-click Repair Tool will fix the problem based on whether your operating system is 32-bit or 64-bit, but the 32-bit system, this file exists in C:/windows/system32, while in 64-bit systems, this file exists in C:/windows/sysWOW64, while in plsql, it will only go down to system32. If your system is 64-bit, the one-click repair tools will not solve the problem, and they will only download the msvcr71.dll file and throw it to C: /windows/sysWOW64. plsql still cannot find the file. therefore, the simplest method is to manually download a 32-bit msvcr71.dll file and copy it to the plsql directory.