Configure and use the oracle11g client (InstantClient)

In the previous chapter, we used the common method to configure the client. Is there a green version of the client?

The official Oracle answer is: Instant Client.

First, go to the homepage of this product and select the Windows 32-bit version.

Select the database version 11.2 (V11.2.4.0)

Preparations:

(1) Microsoft Visual C ++ 2005 Redistributable Package (x86)

Default usage

(2) Microsoft Visual C ++ 2008 Redistributable Package (x86)

Copy the files in vc9 to the upper-level directory (instantclient_11_2)

Decompress the downloaded instantclient-basic-nt-11.2.0.4.0.zip file D: \ Program Files \ instantclient_11_2 (you can select your own directory)

(1) Add the TNS_ADMIN environment variable

TNS_ADMIN = D: \ Program Files \ instantclient_11_2

(2) Add TNS_ADMIN to the Path variable

(3) Place the tnsnames. ora file in the TNS_ADMIN directory (D: \ Program Files \ instantclient_11_2.

Tnsnames. ora

# tnsnames.ora Network Configuration File# Generated by Oracle configuration tools.ORACLR_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )    (CONNECT_DATA =      (SID = CLRExtProc)      (PRESENTATION = RO)    )  )ORCL =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.106)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = orcl)    )  )

* 1: HOST = 192.168.1.106

Based on the IP address of the data

* 2: SERVICE_NAME = orcl

Enter according to the database you want to connect

2. PL/SQL Developer settings

(1) OCI Database

Go to Preferences, click the "OCI Library" drop-down box, and select the options provided. (After setting the system variables, the options are automatically added)

For subsequent operations, refer to the previous blog titled oracle11g client configuration and use (Windows)