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

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

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.

InstantClient

Download instantclient and decompress it to D: \ instantclient_11_2 (I will decompress it to this path)

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 of the remote database to be connected, and the port number and Instance name. Replace the red text with the local Instance name (the name is arbitrary, just to distinguish between local instances)

The tnsnames. ora file is then thrown into the instantclient directory, and The. dll files are in the same directory.

Open plsql, and prompt to cancel the logon. Log in directly, and click "tools"-"preference)

Enter the database connection username and password, database ip port, and Instance name at login, 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.