Installing and using Oracle Instant Client

Install and use the Oracle Instant Client on the Oracle website as needed ( http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Download the corresponding Instant Client Version package, the description of each package is as follows: Instant Client PackageDescription www.2cto.com NotesBasicAll files required to run OCI, OCCI, and JDBC-OCI applicationsOCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10646/oci01int.htm#i423362OCCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10764/install.htm#CACFFGHFJDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJCBasic LiteSmaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) OCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10646/oci01int.htm#i423362OCCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10764/install.htm#CACFFGHFJDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJCJDBC Supplement * Additional (Additional) support for XA, Internationalization, and RowSet operations under JDBCJDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJCSQL * Plus * Additional libraries and executable (executable) for running SQL * Plus with Instant ClientSQL * Plus 10.2 www.2cto.com http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#sthref3926SQL * Plus 11.2 http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/apd.htm#CHDCHJJJODBC Supplement * Additional (Additional) libraries for enabling ODBC applications with Instant Client (Not all platforms) ODBC http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.htmlSDK * Additional header files and an example makefile for developing Oracle applications with Instant Client ODAC * supported des ODP. NET, Oracle Services for MTS, Oracle Providers for ASP. NET, Oracle Provider for ole db, and OO4O with Oracle Instant Client mark * is an optional software package. 1. Take version 11.2.0.2.0 as an example. Download the Basic software package (only the Basic software package can be downloaded in Chinese). 2. decompress the package to C: \ Oracle \ instantclient_11_23. Set the environment variable: NLS_lANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBKTNS_ADMIN = C: \ Oracle \ instantclient_11_2Path = C: \ Oracle \ instantclient_11_2; % Path %
To avoid Chinese garbled Characters During database access, the setting of NLS_lANG is very important. If TNS_ADMIN is not set, tnsnames. by default, ora is addressing the network \ ADMIN directory under the Instant Client Directory; % Path % is the original Path variable. 4. Compile tnsnames with reference to the following content. ora, and save it 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 www.2cto.com # DATABASENAME = # (DESCRIPTION = # (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))#) # (CONNECT_DATA = # (SERVICE_NAME = servicename) #) If you want to connect to multiple Oracle instances, continue to add Configurations of other instances. 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,201 0, Oracle. all rights reserved. SQL> conn username/password @ <connection string> now, the installation is complete. PLSQL Developer and other tools and application software can be used normally. Appendix: for setting environment variables in Linux, extract them to the/usr/local/oracle directory, configure TNS_ADMIN, LD_LIBRARY_PATH, and copy them. part of the bashrc file is as follows: www.2cto.com 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 = export PATH = $ PATH: $ ORACLE_HOME export PATH Author: China blue sky