How to install the Oracle Instant Client

Source: Internet
Author: User
Tags odbc sqlplus

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:release 11.2.0.1.0 Production on Fri 8 10:17:53 2014Copyright (c) 1982, Oracle.  All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.1.0-productionwith The partitioning, OLAP, Data Minin G and Real Application testing optionssql>

Test ok!

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

How to install the Oracle Instant Client

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.