由于项目开发的需求,需要通过oracle访问mysql,必须配置“网关”,通过ODBC实现
总结了一下从oracle访问mysql的步骤:
1.先简单介绍下环境
操作系统:windows xp
oracle:10.0.2.0.1
mysql:5.0
2.下载mysql的odbc驱动,我用的是myodbc 3.5.1并安装
3.配置odbc数据源,在控制面板中配置就可以了,使用系统DSN,取名为mysqltest
4.在E:/oracle/product/10.2.0/db_1/hs/admin下(E:/oracle/product/10.2.0/db_1为ORACLE_HOME的安装目录)建立initmysqltest.ora文件
输入:
HS_FDS_CONNECT_INFO = mysqltest
HS_FDS_TRACE_LEVEL = OFF
5.在E:/oracle/product/10.2.0/db_1/network/admin下修改
listener.ora
输入:
(SID_DESC =
(SID_NAME = mysql)
(ORACLE_HOME = E:/oracle/product/10.2.0/db_1)
(PROGRAM = hsodbc)
)
修改后的listener.ora如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLS