会计考友 发表于 2012-8-4 14:06:19

Oracle性能调优:InstantClient的安装和使用1

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
   
    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]
查看完整版本: Oracle性能调优:InstantClient的安装和使用1