centos安装instantclient（oracle精简客户端）步骤

妖狐艹你老母 2022-06-06 07:13 409阅读 0赞

author：skate  
time：2012/08/08

**centos安装instantclient（oracle精简客户端）步骤**

环境  
os版本：centos5.5  
kernel： 2.6.18-194.el5

下载软件包：  
oracle-instantclient-basic-10.2.0.5-1.x86\_64.rpm  
oracle-instantclient-devel-10.2.0.5-1.x86\_64.rpm  
oracle-instantclient-sqlplus-10.2.0.5-1.x86\_64.rpm

下载地址：  
[http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html][http_www.oracle.com_technetwork_database_features_instant-client_index-097480.html]

指定rpm包的安装路径

1. 查看rpm包的默认安装路径  
\[root@localhost tmp\]\# rpm -qpl oracle-instantclient-sqlplus-10.2.0.5-1.x86\_64.rpm  
/usr/bin/sqlplus64  
/usr/lib/oracle/10.2.0.5/client64/bin/sqlplus  
/usr/lib/oracle/10.2.0.5/client64/lib/glogin.sql

3个包都需要检测，为了以后便于维护，可以把instantclient都装在目录"/oracle"

\[root@localhost tmp\]\# rpm -ivh --relocate /usr=/oracle oracle-instantclient-basic-10.2.0.5-1.x86\_64.rpm  
\[root@localhost tmp\]\# rpm -ivh --relocate /usr=/oracle oracle-instantclient-devel-10.2.0.5-1.x86\_64.rpm  
\[root@localhost tmp\]\# rpm -ivh --relocate /usr=/oracle oracle-instantclient-sqlplus-10.2.0.5-1.x86\_64.rpm

2.sqlnet.ora和tnsnames.ora创建  
这两个文件默认是不存在，所以要手工创建  
\[root@localhost tmp\]\# mkdir -p /oracle/lib/oracle/10.2.0.5/client64/network/admin

然后在admin目录下创建这两个文件

3.配置环境变量

session级别设置  
export LD\_LIBRARY\_PATH=/oracle/lib/oracle/10.2.0.5/client64/lib  
export TNS\_ADMIN=/oracle/lib/oracle/10.2.0.5/client64/network/admin  
export ORACLE\_HOME=/oracle/lib/oracle/10.2.0.5/client64

把如下内容放在环境变量文件中  
\[root@localhost ~\]\# vi /root/.bash\_profile  
.....  
TNS\_ADMIN=/oracle/lib/oracle/10.2.0.5/client64/network/admin  
LD\_LIBRARY\_PATH=/oracle/lib/oracle/10.2.0.5/client64/lib  
PATH=$PATH:$HOME/bin:/oracle/lib/oracle/10.2.0.5/client64/bin

......

4.测试

\[root@localhost ~\]\# sqlplus "/@tns"

SQL\*Plus: Release 10.2.0.5.0 - Production on Thu Aug 9 03:03:26 2012

Connected to:  
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

\------end----

[http_www.oracle.com_technetwork_database_features_instant-client_index-097480.html]: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html