Install and configure Oracle Instant Client (Instant Client)

1. Download

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

This is the homepage for downloading Oracle Instant Client. There are many versions available for downloading.

However, note that third-party tools such as PL/SQL developer and toad must correspond to 32-bit oracleinstant client. Do not download 64-bit tools because the system is 64-bit, note This.

 

Ii. Configuration

Decompress the downloaded instantclient-basic-nt-11.2.0.2.0.zip package and place it in the C: \ instantclient_11_2 directory.

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

 

3. Create a tnsnames. ora File

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

Example:

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

This parameter is changed to the alias above. Host is the IP address, and SERVICE_NAME is the Instance name of the database server.

 

Iv. Uninstall Methods

In "system variables" in "environment variables:

1. Delete the ORACLE_HOME, tns_admin, and nls_lang variables, modify the PATH variable, and remove the c: \ instantclient_11_2 directory.
2. Delete the c: \ instantclient_11_2 directory

 

V. Use of third-party tools

After configuring any of the above clients, you can install toad or PL/SQL developer. You can use it without any additional settings.