论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2011-05-16 12:31 |只看该作者 |倒序浏览

本帖最后由 MARTRY 于 2011-05-16 12:35 编辑

现在在oracle中创建dblink连接sql server碰到一个tnsping问题
tnsping 本机成功，tnsping sqlserver那台机器返回无监听程序
C:\Documents and Settings\Administrator>tnsping denver

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-5月 -
2011 12:22:19

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:
d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(H
OST = 172.16.100.16)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = denver)))
OK (30 毫秒)

C:\Documents and Settings\Administrator>tnsping jss

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-5月 -
2011 12:22:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

已使用的参数文件:
d:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL=TCP)(HOST
= 172.16.100.181)(PORT=1521)))(CONNECT_DATA=(SID=jss))(HS=OK))
TNS-12541: TNS: 无监听程序
-----------------------------------------------------------------------
我的listener。ora配置如下
LISTENER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.100.16)(PORT=1521)))
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC=
   (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
   (SID_NAME=jss)
   (PROGRAM=hsodbc)
)
  )

tnsnames.ora配置如下

jss=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS = (PROTOCOL=TCP)(HOST= 172.16.100.181)(PORT=1521)))(CONNECT_DATA=(SID=jss))(HS=OK))
DENVER =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.16)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = denver)))

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT, HOSTNAME)

两台服务器均没有使用防火墙
不知道是什么问题，请大家指点指点