Linux 安装 oracle 客户端

Linux 安装 oracle 客户端

1、下载所需的Instant Client RPM软件包。

2、用yum命令安装：

# yum -y localinstall \
oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm \
oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm \
oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

3、查看安装包文件

# rpm -ql oracle-instantclient11.2-basic oracle-instantclient11.2-sqlplus
/usr/lib/oracle/11.2/client64/bin/adrci
/usr/lib/oracle/11.2/client64/bin/genezi
/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/usr/lib/oracle/11.2/client64/lib/libocci.so.11.1
/usr/lib/oracle/11.2/client64/lib/libociei.so
/usr/lib/oracle/11.2/client64/lib/libocijdbc11.so
/usr/lib/oracle/11.2/client64/lib/ojdbc5.jar
/usr/lib/oracle/11.2/client64/lib/ojdbc6.jar
/usr/lib/oracle/11.2/client64/lib/xstreams.jar
/usr/bin/sqlplus64
/usr/lib/oracle/11.2/client64/bin/sqlplus
/usr/lib/oracle/11.2/client64/lib/glogin.sql
/usr/lib/oracle/11.2/client64/lib/libsqlplus.so
/usr/lib/oracle/11.2/client64/lib/libsqlplusic.so

4、加载所需要的库文件：

# sh -c “echo /usr/lib/oracle/11.2/client64/lib >> /etc/ld.so.conf.d/oracle-instantclient.conf”
# ldconfig

5、创建软连接，把sqlplus命令添加到PATH环境：

# ln -sv /usr/lib/oracle/11.2/client64/bin/sqlplus /usr/bin/sqlplus

# ll /usr/bin/sqlplus*
lrwxrwxrwx. 1 root root 41 Sep 30 16:21 /usr/bin/sqlplus -> /usr/lib/oracle/11.2/client64/bin/sqlplus
lrwxrwxrwx. 1 root root 41 Sep 30 15:52 /usr/bin/sqlplus64 -> /usr/lib/oracle/11.2/client64/bin/sqlplus

5、测试用nolog登录：

# sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 30 16:56:27 2020

Copyright © 1982, 2013, Oracle. All rights reserved.

SQL>