用的是oracle9i连接db2数据库
select表时提示ora-28545连接代理时net8诊断到错误,ncro无法执行rslv连接
ora-02063:紧接着2lines(源于ywxt) (数据源为ywxt,数据库也为ywxt)
以下是我的配置信息hs下的initywxt.ora 文件
HS_FDS_CONNECT_INFO = ywxt
HS_FDS_TRACE_LEVEL = off
network/admin下的 listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = YWXT)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = ywxt)
)
)##tnsnames.ora 中的配置信息
ywxt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ywxt)
)
(HS = OK)
)
然后创建数据库链
create database link "ywxt" connect to "ywxt" identified by "1234" using 'ywxt';然后查询时就出现了上边的提示.中间重启过n次监听和数据库
哪位大哥帮忙给看一下啊
select表时提示ora-28545连接代理时net8诊断到错误,ncro无法执行rslv连接
ora-02063:紧接着2lines(源于ywxt) (数据源为ywxt,数据库也为ywxt)
以下是我的配置信息hs下的initywxt.ora 文件
HS_FDS_CONNECT_INFO = ywxt
HS_FDS_TRACE_LEVEL = off
network/admin下的 listener
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = YWXT)
(ORACLE_HOME = F:\oracle\ora92)
(PROGRAM = ywxt)
)
)##tnsnames.ora 中的配置信息
ywxt =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ywxt)
)
(HS = OK)
)
然后创建数据库链
create database link "ywxt" connect to "ywxt" identified by "1234" using 'ywxt';然后查询时就出现了上边的提示.中间重启过n次监听和数据库
哪位大哥帮忙给看一下啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货