有一台Linux(Fedora 15,64位)的Oracle(11g2R)服务器,已经安装了mysql-connector-odbc和unixODBC。使用isql指令测试证实能够通过ODBC访问另一台MySQL的主机上的数据。然后在Oracle创建Database Link尝试访问这个MySQL数据库却总是出现ORA-28511和ORA-02063错误。Database Link的创建语句是:
CREATE DATABASE LINK dblink_my01
CONNECT TO "receiver" IDENTIFIED BY "password"
USING '(
DESCRIPTION = (
ADDRESS = (
PROTOCOL = TCP
)(
HOST = LOCALHOST
)(
PORT = 1521
)
)(
CONNECT_DATA = (
SID = odbcposc04
)
)(
HS = OK
))
';listener.ora文件是:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app/oracle
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=odbcposc04)
(PROGRAM=dg4odbc)
)
)
initodbcposc04.ora文件是:
HS_FDS_CONNECT_INFO = mysqlp04
HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5.so
set ODBCINI=/etc/odbc.ini
odbc.ini文件是:
[mysqlp04]
Driver= MySQL
Server= 192.168.17.4
请各位帮忙看看,找出错误的原因。谢谢!!
CREATE DATABASE LINK dblink_my01
CONNECT TO "receiver" IDENTIFIED BY "password"
USING '(
DESCRIPTION = (
ADDRESS = (
PROTOCOL = TCP
)(
HOST = LOCALHOST
)(
PORT = 1521
)
)(
CONNECT_DATA = (
SID = odbcposc04
)
)(
HS = OK
))
';listener.ora文件是:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /home/oracle/app/oracle
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=odbcposc04)
(PROGRAM=dg4odbc)
)
)
initodbcposc04.ora文件是:
HS_FDS_CONNECT_INFO = mysqlp04
HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5.so
set ODBCINI=/etc/odbc.ini
odbc.ini文件是:
[mysqlp04]
Driver= MySQL
Server= 192.168.17.4
请各位帮忙看看,找出错误的原因。谢谢!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货