下载oracle客户端
到官网下载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
安装
# 安装依赖
yum install libaio
#安装oracle客户端基础包
rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
#安装sqlplus
rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
#安装devel
rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
配置
mkdir -p /usr/lib/oracle/11.2/client64/network/admin
vi /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
#配置内容(前面不能有空格)
sap_mid =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.81)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)