DM通过ODBC访问ORACLE

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';