Oracle性能调优:InstantClient的安装和使用1
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#CACFFGHF
JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC
Basic Lite
Smaller 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#i423362
OCCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10764/install.htm#CACFFGHF
JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC
JDBC Supplement*
Additional(附加的) support for XA, Internationalization, and RowSet operations under JDBC
JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC
SQL*Plus*
Additional libraries and executable(可执行的) for running SQL*Plus with Instant Client
SQL*Plus 10.2 http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#sthref3926
SQL*Plus 11.2 http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/apd.htm#CHDCHJJJ
ODBC Supplement*
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.html
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.NET, Oracle Provider for OLE DB, and OO4O with Oracle Instant Client
标*的为可选软件包。
1、以11.2.0.2.0版本为例,下载Basic软件包(要支持中文只能下载Basic软件包)
2、解压缩必须包到C:\Oracle\instantclient_11_2
3、设置环境变量:
NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN=C:\Oracle\instantclient_11_2
Path=C:\Oracle\instantclient_11_2;%Path%
为避免访问数据库时出现中文乱码,NLS_lANG的设置很重要;TNS_ADMIN如不设置,tnsnames.ora默认寻址为Instant Client目录下的network\ADMIN目录;%Path%为原有Path变量。
页:
[1]