Configuring the Oracle Instance Client

1. Download the Oracle instance client. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Since the machine is 64-bit, the 64-bit version is downloaded. But later found that Plsql is 32-bit, and downloaded the 32-bit version. Two versions can exist in parallel, the green version of the well ...

2, after downloading, unzip to the C drive or other directory. Where _x86 is a 32-bit version.

3. Configure the environment variables.

Path: Increase the instance Client decompression directory.

Tns_admin:instance Client unzipped directory.

Nls_lang:american_america. Zhs16gbk

4, in the instance client directory, add the Tnsnames.ora file. The contents are as follows (modified according to actual needs):

# Tnsnames.ora Network Configuration File:c:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration Tools.
Lemonc = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.222) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = Lemonc)))
Extproc_connection_data = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1)) (Connect_data = (SID = plsextproc) (PRESENTATION = RO)))

5, after the configuration is complete, the program can use the instance client to connect to the Oracle server.

6,plsql configuration:

7, then, there is no then ... Enjoy

Configuring the Oracle Instance client