PL/SQL Remote Connection Oracle Summary

These days, the reinstallation of the system, the so-called development tools are to be reinstalled. A little bit of distress, but also learned a lot of practical knowledge, in this readers.

Because of the low-voltage version of the computer, running large software CPU and memory is more tight. I used to have oracle10g and oracle11g on my laptop, comparing cards. After this reload system, I decided not to install the local Oracle database. Remotely connect to the intranet server's database. The Development database preferred tool, in my opinion, is also PL/SQL developer, although there are Oracle Devlelopment and Toad, and so on.

The first step is to install PL/SQL developer, this step no special case, you can always click Next, you can install success!

The second step to download a connection to Oracle client instantclient, I use instantclient-basic-win32-10.2.0.4, the specific version can go to Oracle's official website to download, but to register users. Unzip the downloaded zip file and create a new D:\instantclient-basic-win32-10.2.0.4\instantclient_10_2\network\admin under the folder (where D:\ Instantclient-basic-win32-10.2.0.4\instantclient_10_2 is my decompression location), create a new Tnsnames.ora file, the contents can be copied in the server's response file.

The third step is to open the PL/SQL tool cancel login, directly to PL/SQL Login Interface setting parameters, in tools-"preferrences-" Connection Oracle home under your own d:\ Instantclient-basic-win32-10.2.0.4\instantclient_10_2, fill in the D:\instantclient-basic-win32-10.2.0.4\ under OCI libarary The Instantclient_10_2\oci.dll is wide.

The interest dash thought the finished, but everything is not so smooth sailing. Restarting PL/SQL occurs when MSVCR71.dll is, because my operating system is 64-bit, and instantclient is 32 bit missing the corresponding dynamic link library. So I searched the internet to find the MSVCR71.dll file, copy it to instantclient OK.

When you have completed the goal of the moment, your heart is so passionate, realize what is: situations, Vista!

PL/SQL Remote Connection Oracle Summary