orqcle 10g 利用 ODBC 连接 SQLSERVER2000 老是报此错误如下:
ORA-28545
ORA-02063 配置如下:initgoods.ora:HS_FDS_CONNECT_INFO = goods
HS_FDS_TRACE_LEVEL = OFFlistener.ora:# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = goods)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-200906051052)(PORT = 1522))
)
)
tnsnames.ora 增加如下: (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA= (SID=goods))
(HS=OK)
)创建DBLINK:
create database link GOODS
connect to sa identified by "sa"
测试:
select * from user@goods然后就报错如下:
ORA-28545:连接代理时 NET8诊断到错误 Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063:紧接着 2 lines(起自 GOODS)请各位高手帮帮忙,小弟先在些谢过了!
ORA-28545
ORA-02063 配置如下:initgoods.ora:HS_FDS_CONNECT_INFO = goods
HS_FDS_TRACE_LEVEL = OFFlistener.ora:# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = goods)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-200906051052)(PORT = 1522))
)
)
tnsnames.ora 增加如下: (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA= (SID=goods))
(HS=OK)
)创建DBLINK:
create database link GOODS
connect to sa identified by "sa"
测试:
select * from user@goods然后就报错如下:
ORA-28545:连接代理时 NET8诊断到错误 Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063:紧接着 2 lines(起自 GOODS)请各位高手帮帮忙,小弟先在些谢过了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货