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