Oracle Instant Client (Instant clients) installation and configuration

First, download

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This is the homepage of the Oracle Instant client download, and there are many versions available for download.

But pay attention to third-party tools such as: PL/SQL developer and Toad version, 32-bit to correspond to 32-bit oracleinstant Client, do not because the system is 64-bit download 64-bit, this should be noted.

Two, configure

Unzip the downloaded Instantclient-basic-nt-11.2.0.2.0.zip compressed package and put it in the C:\instantclient_11_2 directory.

In the environment variables, in the system variables, add:

1. Oracle_home = C:\instantclient_11_2
2. Tns_admin = C:\instantclient_11_2
3. Nls_lang = Simplified Chinese_china. Zhs16gbk

Modify the path variable and add C:\instantclient_11_2 later

Third, create a new Tnsnames.ora file

Create a new Tnsnames.ora file in C:\instantclient_11_2 and add your own database alias configuration.

Examples are as follows:

mydb=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (host= 172.16.1.16) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = ora10g)

)

)

Note that the format should be arranged well

Main change = previous alias, host is IP address, service_name is the instance name of the database server.

Four, unloading method

In "Environment variables", in "System variables":

1. Delete Oracle_home,tns_admin, Nls_lang three variables, modify path variable, remove C:\instantclient_11_2 directory
2. Delete C:\instantclient_11_2 Directory

Five. Use of third-party tools

Any of the above clients can be configured to install the toad or PL/SQL Developer tool, and no additional settings are required to be used.

Oracle Instant Client (Instant clients) installation and configuration