我现在想在oracle上建立一个dblink,连接远程一个mysql数据库,按照网上的示例,总也不成功
如下:
select * from issues@mysql执行后报如下错误ORA-28545: 连接代理时 Net8 诊断到错误
NCRO:无法执行 RSLV 连接
ORA-02063: 紧接着2 lines(源于MYSQL)有哪位高手能指点我下,跪谢了,我oracle9 oracle11g 都有环境配置如下:mysql数据库在A机器上(win2003) 数据库实例名:bitnami_redmine
A机器上建立的数据源名字为:2redmine test通过了oracle 也在A机器上 版本 oracle9
listener.ora 配置如下(我单独建立了一个监听):
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(SID_NAME = orcl)
)
)
LISTENER_mysql =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
)
)SID_LIST_LISTENER_mysql =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hsodbc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(SID_NAME = bitnami_redmine)
)
)tnsnames.ora配置如下:MYSQLTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bitnami_redmine)
)
(HS=OK)
)
如下:
select * from issues@mysql执行后报如下错误ORA-28545: 连接代理时 Net8 诊断到错误
NCRO:无法执行 RSLV 连接
ORA-02063: 紧接着2 lines(源于MYSQL)有哪位高手能指点我下,跪谢了,我oracle9 oracle11g 都有环境配置如下:mysql数据库在A机器上(win2003) 数据库实例名:bitnami_redmine
A机器上建立的数据源名字为:2redmine test通过了oracle 也在A机器上 版本 oracle9
listener.ora 配置如下(我单独建立了一个监听):
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(SID_NAME = orcl)
)
)
LISTENER_mysql =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
)
)SID_LIST_LISTENER_mysql =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hsodbc)
(ORACLE_HOME = F:\app\product\9.2.0\orcl)
(SID_NAME = bitnami_redmine)
)
)tnsnames.ora配置如下:MYSQLTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.252.21)(PORT = 1521))
)
(CONNECT_DATA =
(SID = bitnami_redmine)
)
(HS=OK)
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货