oracle dblink mysql 报错ORA-28500
配置信息如下:求大神支援 支援 支援 重要的事情说三遍
odbc.ini
[myodbc5]
Driver = /home/oracle/app/myodbc-4.18/lib/libmyodbc5.so
Description = MySQL ODBC 5.1 Driver DSN
SERVER = localhost
PORT = 3306
USER = test
Password = test
DATABASE = test
OPTION = 3
SOCKET =
charset = utf8
tnsnames.ora
myodbc5=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SID = myodbc5))
(HS=OK)
)
listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(PROGRAM = dg4odbc)
(SID_NAME= myodbc5)
(ORACLE_HOME= /home/oracle/app/oracle/product/11.2.0/dbhome_1)
(ENVS=LD_LIBRARY_PATH=home/oracle/app/unixodbc-2.2.14)
)
)
inimyodbc5.ora HS_FDS_CONNECT_INFO=myodbc5
HS_FDS_TRACE_LEVEL= ON
HS_FDS_SHAREABLE_NAME=/home/oracle/app/unixodbc-2.2.14/lib/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_LANGUAGE=AMERICAN.AMERICA.ZHS16GBK
ODBC env variables
set ODBCINI=/home/oracle/app/odbc.ini
创建DBLINK 链接时报错
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from MYODBC5
连返回值都没有
推荐阅读
-
Oracle创建dblink报错:ORA-01017、ORA-02063解决
-
MySQL FEDERATED引擎使用示例, 类似Oracle DBLINK.
-
项目从mysql迁移到oracle报错
-
Oracle10g通过DBLink访问MySQL示例
-
Oracle10g通过DBLink访问MySQL示例
-
Mybatis+Oracle搭配insert空值报错之myBatis+mysql驱动+oracle驱动的源码分析
-
MySQL FEDERATED引擎使用示例, 类似Oracle DBLINK.
-
MySQL FEDERATED引擎使用示例, 类似Oracle DBLINK_MySQL
-
oracle dblink mysql 报错ORA-28500
-
oracle dblink mysql 报错ORA-28500