How to install the Oracle Instant Client

Oracle Instant Client is a lightweight database client released by Oracle, let's look at the official definition:

Instant client allows you to run your applications without installing the standard Oracle client or have an oracle_home. OCI, OCCI, Pro*c, ODBC, and JDBC applications work without modification, while using significantly less disk space than B Efore. Even Sql*plus can is used with Instant Client. No recompile, no hassle.

It can be seen that Oracle Instant client is a better choice if you are simply connecting to the database server side with SQL developer, or using Sql*plus to operate the database, compared to standard clients, which greatly simplifies the client installation process and takes up very little space , but includes the necessary OCI, OCCI interface, and ODBC, JDBC driver.

Let's take a look at the official installation package:

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

Because our background database version is 11.2.0.1 32-bit, and we need to install the client under Windows, so download

Instantclient-basic-win32-11.2.0.1.0.zip (51,458,190 bytes)

Instantclient-sqlplus-win32-11.2.0.1.0.zip (758,913 bytes)

If you don't need sqlplus, choose Basic.

below to see how to install.

first, the Instantclient-basic and instantclient-sqlplus two installation packages in the same directory, decompression .

Here, we put under E:\Oracle, extract to the current folder, and finally automatically generate a new folder Instantclient_11_2, two packages of files will be placed in this folder, that is E:\Oracle\instan Tclient_11_2.

Second, modify the system variables

1> adding E:\Oracle\instantclient_11_2 to the system variable path

2> New System Variables

Nls_lang=american_america. we8mswin1252-->> Server-side character set

Tns_admin=e:\oracle\instantclient_11_2-->> Specify where Tnsnames.ora is located

Note: If the installation of the online method system variable is still not effective, you need to restart the computer for the modified system variables to take effect.

Third, the new Tnsnames.ora configuration file under E:\Oracle\instantclient_11_2, the contents are as follows:

Orcl=(DESCRIPTION=(Address_list=(ADDRESS=(PROTOCOL=TCP) (HOST= 192.168.1.11) (PORT= 1521)) ) (Connect_data=(SERVER=dedicated) (Service_Name=orcl.being.com )))

Four, with Sql*plus landing test.

c:\windows\system32>sqlplus scott/[email protected]

SQL*Plus:release11.2.0.1.0Production onFri8 Ten: -: -  theCopyright (c)1982, ., Oracle. Allrights reserved. Connected to: OracleDatabase11g Enterprise Edition Release11.2.0.1.0 -Production withThe partitioning, OLAP, Data Mining and RealApplication Testing Optionssql>

Test ok!

At this point, the Oracle Instant client and Sql*plus installation are complete.