Install and configure Oracle Instant Client (Instant Client)

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.

Resources used in this article: Oracle instant client 32-bit (Green Edition) perfectly supports win7 64-bit System

: Http://download.csdn.net/detail/xuyongbeijing2008/9044301

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:

ORACLE_HOME = C: \ Oracle \ instantclient_10_2TNS_ADMIN = C: \ Oracle \ instantclient_10_2NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Modify the Path variable and add C: \ Oracle \ instantclient_10_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:

 

ORCL =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 172.117.164.152)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = VPSADDB)
)
)

 

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:

Delete ORACLE_HOME, TNS_ADMIN, and NLS_LANG, modify the path variable, and delete the C: \ Oracle \ instantclient_10_2 directory C: \ Oracle \ instantclient_10_2.

 

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.