OCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10646/oci01int.htm#i423362! c+ C, M9 j8 b1 Y9 B8 h* K+ K+ c
8 g, v6 ~9 R- @, P6 Q& B
OCCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10764/install.htm#CACFFGHF8 b: h9 W* {: a& s0 d
. \- Q( q: A, L5 }1 } R: D5 K9 H
JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC3 r. m) S. K$ g; x) V4 c8 Z) I
( N& A |; h+ \; u) r6 S9 y. p/ E Basic Lite
4 x e4 s8 b# [6 q# V8 P' i
. L" q! x* ^/ I) A+ K Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support （10.2 only）
4 ~: a/ u2 |7 g$ \; K' h , Y, a" }+ a! _! {+ y; v
OCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10646/oci01int.htm#i423362! z3 I3 G9 H) i8 i4 B$ f- O8 V7 ~
) I( r8 S* {# a9 U OCCI http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10764/install.htm#CACFFGHF& V) I1 Q# y' U' s4 k* }2 {$ |
; I2 {8 D: `6 g( h& G7 o9 E1 G/ J JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC' V' a+ t: v O# i7 A
0 w+ I4 k! Y/ z+ v0 B4 y6 g2 s- m JDBC Supplement*: K- O* e: H% j* B2 P# ]
6 m( V4 k' i8 v: m Additional（附加的） support for XA, Internationalization, and RowSet operations under JDBC
9 `4 {6 j" H$ I& ` S- {( z
$ j$ y( c$ g( g JDBC http://download.oracle.com/docs/cd/E11882_01/java.112/e16548/instclnt.htm#CIHFDFJC
1 t1 d! ?: }: A- i , h9 l3 q0 \4 S* x& V: f% L- Z9 Y
SQL*Plus** U2 r; `* }, B1 _( u
, b" ^+ a: _) Y5 \ Additional libraries and executable（可执行的） for running SQL*Plus with Instant Client
3 k G) L( V8 m7 s: [* \' D
' X7 f; r% y# y SQL*Plus 10.2 http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#sthref39264 R' D, {- z8 A: H
w- I# S- `; s, H, O7 p: c, L, n
SQL*Plus 11.2 http://download.oracle.com/docs/cd/E11882_01/server.112/e16604/apd.htm#CHDCHJJJ
- I9 S5 I" G2 _, a6 K$ y" |; ^ ( E i- \* l( D
ODBC Supplement*
+ V8 h6 [$ O- _: r& \
; C( G3 j, R) B& T4 M Additional（附加的） libraries for enabling ODBC applications with Instant Client （Not all platforms）
5 z1 P) f. Q: l& x; `% X
7 ^3 q* b6 k r ODBC
! Q$ a% X x5 f8 P/ J$ e, r 3 v y5 x- r! G. O' x' H* l) s A
http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.html, y9 Z& O; h9 Y5 ]! P/ g ~8 ]% A# b
5 K; _3 M2 G) A3 N6 _9 b SDK*
# x7 p+ L3 u4 m 2 n8 v. v& s! I
Additional header files and an example makefile for developing Oracle applications with Instant Client
6 k, T% R4 b! e8 W/ f: n n( Y; E* g
+ Y$ T# q$ ]5 c& \0 P: s8 l1 Y( S s ODAC*5 z( b+ p/ b' `, a. B
1 P% i3 V5 ^, V1 }
Includes ODP.NET, Oracle Services for MTS, Oracle Providers for ASP.NET, Oracle Provider for OLE DB, and OO4O with Oracle Instant Client
2 K+ o5 s) b1 f5 h
- S3 T% M, _- ]5 U+ K! t3 ?' N& ` 标*的为可选软件包。6 ~- `9 p" n* f+ r' t
4 K/ Z. E4 K) q1 ?- i3 O+ I& |* A# T
1、以11.2.0.2.0版本为例，下载Basic软件包（要支持中文只能下载Basic软件包）
! Z ]6 b% P) m T S . I1 N, A+ M( d# Q) T" L7 |, o* B
2、解压缩必须包到C:\Oracle\instantclient_11_2
+ r# v Q: y4 M+ ?) I' p5 _ , c' r: T" e" t1 L
3、设置环境变量：) M$ q& x8 x' P7 z* q: A
7 E6 ?1 n$ D$ D
NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK# A1 V- z3 I+ D" H5 b& w
- O9 L# {9 y" t4 @
TNS_ADMIN=C:\Oracle\instantclient_11_2
: g2 i* ~7 r$ U! Z% {! e; l
0 W7 b F3 a( W Path=C:\Oracle\instantclient_11_2;%Path%
5 Q/ C: t8 {7 w; S' D6 C0 ?5 T* {! E
. j# X- X$ o: k 为避免访问数据库时出现中文乱码，NLS_lANG的设置很重要；TNS_ADMIN如不设置，tnsnames.ora默认寻址为Instant Client目录下的network\ADMIN目录；%Path%为原有Path变量。 |
发表于 2012-8-4 14:06:19
