本文主要向大家介紹了Oracle數(shù)據(jù)庫(kù)之Oracle Instant Client的安裝和使用，通過(guò)具體的內(nèi)容向大家展現(xiàn)，希望對(duì)大家學(xué)習(xí)Oracle數(shù)據(jù)庫(kù)有所幫助。

根據(jù)自己需求到Oracle網(wǎng)站(http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)下載相應(yīng)的Instant?Client版本軟件包，各軟件包的描述如下：

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?English?error?messages?and?Unicode,?ASCII,?and?Western?European?character?set?support?(10.2?only)

OCI

OCCI

JDBC

JDBC?Supplement*

Additional(附加的)?support?for?XA,?Internationalization,?and?RowSet?operations?under?JDBC

JDBC

SQL*Plus*

Additional?libraries?and?executable(可執(zhí)行的)?for?running?SQL*Plus?with?Instant?Client

SQL*Plus?10.2

SQL*Plus?11.2

ODBC?Supplement*

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.NET,?Oracle?Provider?for?OLE?DB,?and?OO4O?with?Oracle?Instant?Client

標(biāo)*的為可選軟件包。

1、以11.2.0.2.0版本為例，下載Basic軟件包(要支持中文只能下載Basic軟件包)

2、解壓縮必須包到C:\Oracle\instantclient_11_2

3、設(shè)置環(huán)境變量：

NLS_lANG=SIMPLIFIED?CHINESE_CHINA.ZHS16GBK

TNS_ADMIN=C:\Oracle\instantclient_11_2

Path=C:\Oracle\instantclient_11_2;%Path%

為避免訪(fǎng)問(wèn)數(shù)據(jù)庫(kù)時(shí)出現(xiàn)中文亂碼，NLS_lANG的設(shè)置很重要；TNS_ADMIN如不設(shè)置，tnsnames.ora默認(rèn)尋址為Instant?Client目錄下的network\ADMIN目錄；%Path%為原有Path變量。

4、參照下面內(nèi)容編寫(xiě)tnsnames.ora，并保存到安裝目錄：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)

#????)

#??)

如果有要連接多個(gè)Oracle實(shí)例，請(qǐng)繼續(xù)往該文件中加入其它實(shí)例的配置。

5、測(cè)試：

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,?2010,?Oracle.??All?rights?reserved.

SQL>?conn?username/password?@?

至此，安裝已經(jīng)完成。PLSQL?Developer等工具，以及應(yīng)用軟件都可以正常使用了。

附錄：Linux下環(huán)境變量設(shè)置

如解壓到了/usr/local/oracle目錄,配置好TNS_ADMIN、LD_LIBRARY_PATH等，復(fù)制到.bashrc文件部分內(nèi)容如下：

export?ORACLE_HOME=/usr/local/oracleexport?TNS_ADMIN=$ORACLE_HOME/NETWORK/ADMINexport?LD_LIBRARY_PATH=$ORACLE_HOMEexport?SQLPATH=$ORACLE_HOMEexport?NLS_LANG=AMERICAN_AMERICA.ZHS16GBKPATH=$PATH:$ORACLE_HOMEexport?PATH

本文由職坐標(biāo)整理并發(fā)布，希望對(duì)同學(xué)們學(xué)習(xí)Oracle有所幫助，更多內(nèi)容請(qǐng)關(guān)注職坐標(biāo)數(shù)據(jù)庫(kù)Oracle數(shù)據(jù)庫(kù)頻道！

總結(jié)

以上是生活随笔為你收集整理的oracle instant client package,Oracle数据库之Oracle Instant Client的安装和使用的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。