PL/SQL uses clients to connect to Oracle under the WIN7/WIN8 x64 bit

The new Win8 x64-bit system was made. You need to use Plsql to connect to the Oracle database. Previous machines fitted with 64-bit oracle11g,plsql can be directly found Oracle_home connected to the database.

This time you do not want to install the database locally, so only a 32-bit database client is installed. There are a few minor issues encountered when configuring environment variables, which are documented here.

1. Download the Oracle client and extract it to any directory

2. Install the Plsql, then configure the address of the Plsql Oracle_home and OCI Library

Preference settings for Plsql

Oracle_home:f:\oracle\product\instantclient_11_2

OCI Lib:f:\oracle\product\instantclient_11_2\oci.dll

3.WINDOWS environment variable Configuration

Tns_admin:f:\oracle\product\instantclient_11_2\network\admin\

Nls_lang:simplified Chinese_china. Zhs16gbk

Attention:

Previously tns_admin specified to Tnsname.ora file, Plsql has not been recognized

When configuring a Windows environment variable, tns_admin only needs to indicate the directory in which the file Tnsname.ora is located, and it does not need to be assigned to a file.