PL/SQL + Oracle Client configuration logging

Oracle has never used anything. Oracle PL/SQL also completes the configuration with the help of others.

This time the computer re-installed, self-fix summed up the next how to configure.

1. Download the Oracle client.

The installed version is win64_11gr2_client.zip,587 MB. Link address on the official website is difficult to find. You will also need your account number and password to download it.

After installation, the default is to install the D:\app.

What we need in the back is D:\app\client\Administrator\product\12.1.0\client_1.

2. Download green version PL/SQL

Green is because it is too lazy to install. Online Search can find a lot. My version is 11.0.0.1762. Unzip after download.

Open pl/sq, Cancel login, enter the interface.

In the tools-preferences interface

In the red box in the diagram, fill in D:\app\client\Administrator\product\12.1.0\client_1 and D:\app\client\Administrator\product\12.1.0\ Client_1.oci.dll

3. Configuring the Tnsname.ora File

Under the D:\app\client\Administrator\product\12.1.0\client_1\Network\Admin folder, there is a sample folder with Tnsname.ora files in it. Inside is an example.

Copy this file to

Under the D:\app\client\Administrator\product\12.1.0\client_1\Network\Admin folder

folder, and then configure the Oracle connection string that we want to use inside.

If the prompt MSVCR71.dll file does not exist, then go to the network to download a msvcr71.dll, placed in the Window/system32 folder is possible.

PL/SQL + Oracle Client configuration logging