# oracle10g 异构连接 mysql5.1
#### OS:WINDOWS XP ######
#### mysql和oracle在同一台主机上面 ###
#### 使用ODBC连接 ##### 在mysql中的操作如下:
mysql>CREATE DATABASE mysqll;mysql>use mysqllmysql>create table test (id varchar(20));mysql>insert into test values("aaaaa");# odbc 配置如下:
# Data Source Name:mysqll
# TCP/IP Server:localhost Port:3306
# User:root
# Password:xxx
# Database:mysqll# 配置HS如下:
# 文件路径:%Oracle_Home%/hs/admin/
# 新建文件: initmysqll.ora
# 在文件里面添加以下参数:# HS_FDS_CONNECT_INFO = mysqll
# HS_FDS_TRACE_LEVEL = off# 配置listener.ora如下
# 文件路径:%Oracle_Home%/NETWORK/ADMIN/
SID_LIST_DBWAN =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBWAN)
(ORACLE_HOME = D:\oralce10g)
(SID_NAME = DBWAN)
)
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = mysqll)
(ORACLE_HOME = D:\oracle10g)
)
)DBWAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VM-Test-XP-12)(PORT = 1533))
)# 配置tnsnames.ora如下:DBWAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VM-Test-XP-12)(PORT = 1533))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DBWAN)
)
)
mysqll =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VM-Test-XP-12)(PORT = 1533))
)
(CONNECT_DATA =
(SID= mysqll)
)
(HS=OK)
)
# 重启监听和oracle服务# 使用sqlplus xxx/xxx@dbwan 登陆到oracle上面# 实行语句:CREATE DATABASE LINK link_aa CONNECT TO "root" IDENTIFIED BY "xxx" USING 'mysqll';# 创建连接是成功的# 然后我执行查询语句 :select id from test@link_aa;# 报以下错误:##########################################################################
# SQL> select id from test@link_aa;
# select id from test@link_aa
*
# 第 1 行出现错误:
# ORA-28545: 连接代理时 Net8 诊断到错误
# Unable to retrieve text of NETWORK/NCR message 65535
# ORA-02063: 紧接着 2 lines (起自 LINK_AA)
####################################################################################################################################################
# 错误日志:
# %oracle_home%/hs/trace/
# Heterogeneous Agent Release
# 10.2.0.2.0
# HS Agent diagnosed error on initial communication,
# probable cause is an error in network administration
# Network error 2: NCR-00002: NCR: 无效的使用
##########################################################################请问.我的配置文件什么地方出现了问题.导致这个错误的发生.谢谢各位大哥了
PS:请各位大哥不要发再给我配置资料了.我已经看了很多了.现在想要一个结果.
忘各位大哥不吝赐教.谢谢了...跪求
http://topic.csdn.net/u/20100728/15/219af6d6-8784-47b0-b169-5e5d139778c2.html