Plsql vs. 64-bit Oracle Association method

Here spit groove, Plsql incredibly wood has 64, before incredibly don't know, long time useless Oracle, want to practice, the method is as follows:

1. Install Oracle, the official website has, here does not elaborate, I choose is 64 Oracle installs.

2. Download the Plsql and install. Originally want to paste an official website path, find half a day did not find, Baidu really does not give force, or Google good, weak weak said a sentence, actually download place a lot, own Baidu Bar.

3. After loading, download an Oracle 32-bit client, download path: http://www.oracle.com/technetwork/topics/winsoft-085727.html I downloaded: instantclient-basic-nt-11.2.0.4.0.zip

4. When you finish plsql, in fact login when the database option is empty, there is no choice, this time you just downloaded the Oracle32-bit client decompression, put in the directory: D:\app\oracle\product,

This path is different.

5. After the extract is configured Plsql, run Plsql, select Tools, Preferences, click on the link, configure the Oracle home directory name: D:\app\oracle\product\instantclient_12_1

and OCI Library: D:\app\oracle\product\instantclient_12_1\oci.dll, then apply, OK.

6. In the configuration environment variable system variable, add the Tns_admin value: D:\app\oracle\product\instantclient_12_1

and Nls_lang values: Simplified Chinese_china. Zhs16gbk

Copy the Tnsnames.ora file under the D:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN directory to D:\app\oracle\product\ before configuring Tns_admin Under the Instantclient_12_1,

I tried tns_admin directly to Oracle's Tnsnames.ora file, seemingly not.

7. Refer to a lot of articles, it is said to re-write off the system to see, so I did, and then succeeded, then forgot to try not to write off can be done.

8. In this case, I built a library when I installed the Oracle database, and then I tested it with Oracle's "Configuration and porting tools" NET Manager and was able to test successfully, and if I didn't build the library when I installed it,

This tool can be used to build the library, and then set up monitoring, the steps are probably the case.

Plsql vs. 64-bit Oracle Association method