oracle92 sqlserver2000 dblink报错,求救!(tnsping成功)
参考网上的配置步骤安装、配置的。tnsping也测试正常。
创建语句也能执行,提示链接已创建。但测试查询时总是提示错误(ORA-28545: 连接代理时 Net8 诊断到错误
NCRO:无法执行 RSLV 连接 ORA-02063: 紧接着2 lines(源于HRMISDB))。
详细情况如下(oracle和sqlserver在不同服务器上):
oracle server ip:192.168.108.86
sqlserver server ip:192.168.123.20
inithrmisdb.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=192.168.123.20;DATABASE=hrmisdb"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
listener.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hjserver)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dbcrm)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = dbcrm)
)
(SID_DESC =
(GLOBAL_DBNAME=tg4msql)
(PROGRAM=tg4msql)
(SID_NAME=hrmisdb)
(ORACLE_HOME = D:\oracle\ora92)
)
)
tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
DBCRM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hjserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbcrm)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hjserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
hrmisdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.123.20)(PORT =1521))
)
(CONNECT_DATA =
(SID=hrmisdb)
)
(HS=OK)
)
C:\>tnsping hrmisdb
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 22-5月 -2
009 10:56:20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
已使用的参数文件:
D:\oracle\ora92\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.123.20)(PORT =1521))) (CONNECT_DATA = (SID=hrmisdb)) (HS=OK))
OK(10毫秒)
SQL> drop public database link mylink
2 /
数据库链接已丢弃。
SQL> create public database link hrmisdb connect to "sa" identified by "sa" usin
g 'hrmisdb'
2 /
数据库链接已创建。
SQL> select * from emp_basicinfo@hrmisdb
2 .
SQL> select * from emp_basicinfo@hrmisdb
2 /
select * from emp_basicinfo@hrmisdb
*
ERROR 位于第 1 行:
ORA-28545: 连接代理时 Net8 诊断到错误
NCRO:无法执行 RSLV 连接
ORA-02063: 紧接着2 lines(源于HRMISDB)