Oracle Instant Client (instant Client) installation and configuration ____oracle

Turn from: http://blog.csdn.net/magicboylinw/article/details/7025885

First, download

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

This is the download page for Oracle Instant client, and there are a number of 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, not because the system is 64-bit on the download of 64-bit, this should be noted.

Second, configure

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

In the system variable in the environment variable, add:

Oracle_home = C:\instantclient_11_2 Tns_admin = C:\instantclient_11_2 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 database server.

Four, uninstall method

In the system variables in environment variables:

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

Five, third party tools use

After any of the above clients are configured, you can install the Toad or Pl/sql Developer tool and use it without any additional setup.