1 测试环境
2 安装unixobdc
yum install -y unixODBC unixODBC-devel
rpm -qa | grep ODBC
3 查看unixODBC
odbcinst -j
4 下载安装rpm软件包
包下载地址:http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
下载完成后安装
rpm –ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm –ivh oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
rpm –ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
5 配置odbc.ini
6 连接测试
isql ORACLE SYSTEM ORACLE -v
7 创建链接
create link orcl_odbc connect 'ODBC' with "SYSTEM" identified by "ORACLE" using 'ORACLE';