linux环境下使用sqlplus访问远程oracle数据库

1.前提

由于sqlplus rpm包安装，需要其它rpm包依赖，建议linux服务器需要提前配置好yum源

2.下载rpm安装包

下载地址(需要oracle account)：Instant Client for Linux x86-64 (64-bit)

E.g：

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm

3.安装rpm安装包

命令：

yum install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

[root@patrolagent ~]# yum install oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_