Installation and use of Oracle Instant client

Transferred from: https://www.cnblogs.com/chinalantian/archive/2011/09/09/2172145.html

According to your needs to the Oracle website (http://www.oracle.com/technetwork/database/features/instant-client/ index-097480.html) to download the corresponding Instant Client version package, each package is described as follows:

Instant Client Package	Description	Notes
Basic	All files required to run OCI, OCCI, and JDBC-OCI applications	OCI Occi Jdbc
Basic Lite	Smaller version of the Basic, with only 中文版 error messages and Unicode, ASCII, and Western European character set supp ORT (10.2 only)	OCI Occi Jdbc
JDBC supplement*	Additional (additional) support for XA, internationalization, and RowSet operations under JDBC	Jdbc
sql*plus*	Additional Libraries and executable (executable) for running Sql*plus with Instant Client	Sql*plus 10.2 Sql*plus 11.2
ODBC supplement*	Additional (additional) libraries for enabling ODBC applications with Instant Client (not all platforms)	Odbc
sdk*	Additional header files and an example makefile for developing Oracle applications with Instant Client
odac*	Includes Odp.net, Oracle Services for MTS, Oracle Providers for ASP, Oracle Provider for OLE DB, and oo4o with Oracle Instant Client

Optional packages for the marked *.

1, take the 11.2.0.2.0 version as an example, download the basic software package (to support Chinese can only download the basic package)

2. Decompression must be wrapped to C:\Oracle\instantclient_11_2

3. Set Environment variables:

Nls_lang=simplified Chinese_china. Zhs16gbk

Tns_admin=c:\oracle\instantclient_11_2

path=c:\oracle\instantclient_11_2;%path%

In order to avoid the Chinese garbled when accessing the database, the setting of Nls_lang is very important; if Tns_admin is not set, tnsnames.ora default address is network\admin directory under instant client directory;%path% is the original Path variable.

4, the following content to write Tnsnames.ora, and save to the installation directory: C:\Oracle\instantclient_11_2

# TNSNames. ORA Network Configuration File:c:\oracle\ora90\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

#sample

#DATABASENAME =

# (DESCRIPTION =

# (Address_list =

# (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))

#    )

# (Connect_data =

# (service_name = ServiceName)

#    )

#  )

If you have more than one Oracle instance to connect to, continue to add the configuration of other instances to the file.

5. Test:

C:\oracle\instantclient_11_2>sqlplus/nolog

Sql*plus:release 11.2.0.2.0 Production on Fri Sep 9 09:42:06 2011

Copyright (c) 1982, Oracle. All rights reserved.

Sql> Conn Username/password @ < connection string >

At this point, the installation is complete. Tools such as Plsql developer, as well as application software, can be used normally.

Appendix: Environment variable Settings under Linux

such as extracted to the/usr/local/oracle directory, configuration Good tns_admin, Ld_library_path, etc., copied to the. bashrc file part of the following:

Export Oracle_home=/usr/local/oracle

Export tns_admin= $ORACLE _home/network/admin

Export Ld_library_path= $ORACLE _home

Export Sqlpath= $ORACLE _home

Export Nls_lang=american_america. Zhs16gbk

Path= $PATH: $ORACLE _home

Export PATH

Installation and use of Oracle Instant client