总体思路

oracle——>dg4odbc——>odbc——>mysql

1、查看DG4ODBC版本

[oracle@node1 ~]$ file $ORACLE_HOME/bin/dg4odbc

/tmp/soft/app/oracle/product/112040/dbhome_1/bin/dg4odbc: ELF 64-bit LSB executable, x86-64,

version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.18, not stripped

2.下载并安装64位的ODBC Driver Manager UnixODBC

下载地址:

请参看官方文档 Detailed Overview of Connecting Oracle to MySQL Using DG4ODBC Database Link

 (文档 ID 1320645.1)

下载最新版本

安装

介质上传/tmp

root赋权：

[root@ljw tmp]# chmod 777 *

[root@ljw tmp]# ls -rtl

total 12756

-rwxrwxrwx 1 root root  1830660 Jul  1 00:21 unixODBC-2.3.4.tar.gz

oracle解压：

解压unixODBC

tar -zxvf unixODBC-2.3.4.tar.gz

root安装：

[root@ljw /]# mkdir -p /usr/local/unixODBC

[root@ljw /]# cd /tmp/unixODBC-2.3.4

[root@ljw unixODBC-2.3.4]# ./configure --prefix=/usr/local/unixODBC

[root@ljw unixODBC-2.3.4]# make & make install

测试：

[root@node1 etc]# odbcinst -j

3.下载并安装ODBC Driver

http://dev.mysql.com/downloads/connector/odbc/#downloads 

安装

rpm -ivh mysql-connector-odbc-8.0.33-1.el6.x86_64.rpm

4.配置：

vi /etc/odbc.ini

[mysql]

Description = mysql

Driver = MySQL ODBC 8.0 Unicode Driver

Server = ** //MySQL服务器IP

Database = yqt_if //MySQL数据库名 （对大小写敏感）

Port = 3306 //端口

USER = root //数据库用户名

Password = root //用户名密码

Socket =

Option = 3

Stmt =

CHARSET = UTF8 //数据库字符集

driver的内容见同路径下的odbcinst.ini 

验证：

isql mysql -v

5. 在.bash_profile配置相关环节变量 

[oracle@ljw etc]$ vi ~/.bash_profile

# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
 
# User specific environment and startup programs
 
PATH=$PATH:$HOME/bin
 
export PATH
 
umask 022
export ORACLE_BASE=/oracle/app
export ORACLE_HOME=/oracle/app/product/11.2.0/db_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH

6.配置监听

添加静态监听

vi listener.ora

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.83.50)(PORT = 1521))
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC=
      (SID_NAME=myodbc5)
      (ORACLE_HOME=/tmp/soft/app/oracle/product/112040/dbhome_1)
      (PROGRAM=dg4odbc)
    )
  )

7.配置tns

vi tnsnames.ora

myodbc5 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.83.50 )(PORT = 1521))
    (CONNECT_DATA =
      (SID=myodbc5)
    )
      (HS=OK)
  )

8.配置odbc

cd $ORACLE_HOME/hs/admin

vi initmyodbc5.ora

HS_FDS_CONNECT_INFO=mysql   
HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so
HS_FDS_SUPPORT_STATISTICS= FALSE
HS_LANGUAGE=AMERICAN_AMERICA.UTF8
HS_NLS_NCHAR=UCS2  
set  ODBCINI=/etc/odbc.ini

9.监听重启

lsnrctl reload

10.创建dblink

create public database link new_e connect to "kaka" identified by "oracle" using 'myodbc5';

select * from gaga@new_e;