mysql centos mysql5.5
配置 先配置在oracle 所在机配置odbc
data source name: mysql ;db:test 测试ok;可以连接到mysql
在oracle home 目录hs/admin 新建 initmysql.ora
内容:
HS_FDS_CONNECT_INFO = mysql
HS_FDS_TRACE_LEVEL = OFF
创建dblink 语句: create database link to_mysql connect to sm identified by sm using 'mysql'
报错:
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:
[Generic Connectivity Using ODBC][Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序 (SQL State: IM002; SQL Code: 0)
ORA-02063: 紧接着 2 lines (起自 TO_MYSQL)
28500. 00000 -"connection from ORACLE to a non-Oracle system returned this message:"
*Cause:The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
行 3 列 20 出错