tnsping 超时

lxg213 2009-12-10 06:40:23
客户端机正常，能ping通服务器，并能连接其它电脑数据库，怀疑是服务器问题。服务器上运行netstat －an显示1521端口开放，局域网内扫描其端口发现就开放了tcp 1-100中的几个端口和8080，系统防火墙关闭，east杀软套装卸载，lsnrctl stop后，lsnrctl start正常，再运行lsnrctl start则显示：
TNS-12560: TNS：协议适配器出现错误
TNS-00530: 协议适配器错误
32-bit Windows error：1056：unknown error。
客户端机 tnsping 超时，登录超时
服务器上tnsping ip或主机名正常（HOST改未改一样）
另无法通过运行\\ip访问服务器共享资源（以前可以），此问题由于非正常卸载comodo杀软套装，替换为east杀软套装引起，重装tcp/ip协议后问题依然存在，应该如何才能打开端口，求解决方法。

服务器上的配置
listener.ora的配置
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主机名)(PORT = 1521)) §主机名改为ip一样无效。
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = extproc)
)
)


SQLNET.ORA的配置
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

...全文
1070 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
lxg213 2009-12-11
  • 打赏
  • 举报
 回复
经过用NetSpeedTest+-+TCP网络连接测试工具测试，发现服务器无法释放端口，除了服务器80，8080，139等已开放的端口外，监听任何端口，都提示：
fail to bind stream socket:10048
郁闷啊，怎么回事啊......，悲剧了，又不能重装系统，哎！
lxg213 2009-12-11
  • 打赏
  • 举报
 回复
服务名，sid改后一样有问题
上面的为客户端tnsping.trc日志。
以下为服务器端tnsping.trc日志。
NS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 11-12月-2009 08:51:59

Copyright (c) 1997 Oracle Corporation. All rights reserved.


--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is C:\oracle\ora92\network\trace\tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source C:\oracle\ora92\network\admin\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = admin
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME)
TNSPING.TRACE_DIRECTORY = C:\oracle\ora92\network\trace
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nnfun2awanm: entry
nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnflcls: entry
nnflcls: exit
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [root]
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element HOSTNAME
nnfgsrdp: Path set
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: 172.20.66.13
nnftinit: entry
nnftinit: Tnsnames refresh interval is 0
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is C:\oracle\ora92\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftinit: exit
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfttran: entry
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: Switching to HOSTNAME adapter
nnfgrne: Original name: 172.20.66.13
nnfhqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfhqnm: Using hostname address (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=172.20.66.13))(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.66.13)(PORT=1521))) for name 172.20.66.13
nnfcraa: entry
nnfgrne: Name successfully queried
nnfhans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfggav: exit
nnfgfrm: entry
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nsmal: 164 bytes at 0xb87038
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nttbnd2addr: entry
nttgetport: entry
nttgetport: port resolved to 1521
nttgetport: exit
nttbnd2addr: using host IP address: 172.20.66.13
nttbnd2addr: exit
nsmal: 492 bytes at 0xbd0998
nsmal: 2348 bytes at 0xbd0b90
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: tcp.validnode_checking not turned on
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1888.
nttcni: connected on ipaddr 172.20.66.13
nttcni: exit
nttcon: set TCP_NODELAY on 1888
nttcon: exit
nsopen: transport is open
nsnainit: call
nsnainit: NA not wanted - disabling and returning
nsoptions: lcl[0]=0x0, lcl[1]=0x900011, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
nsoptions: lcl[0]=0xffefff, lcl[1]=0x900011, gbl[0]=0xfe3f, gbl[1]=0x0
nsopen: global context check-in (to slot 0) complete
nsopen: lcl[0]=0xffefff, lcl[1]=0x900011, gbl[0]=0xfe3f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4201, mvd=0
nsmal: 48 bytes at 0xb88a30
nsmal: 48 bytes at 0xbd2fb0
nlidg8: entry
nlidg8: exit
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=67, *bl=29, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2011
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: plen=87, type=1
nttwr: entry
nttwr: socket 1888 had bytes written=87
nttwr: exit
nspsend: 87 bytes to transport
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=68, *bl=1024, *what=9, uflgs=0x2000, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2011
nscon: recving a packet
nsmal: 48 bytes at 0xbd2fe8
nsprecv: reading from transport...
nttrd: entry
nttrd: socket 1888 had bytes read=73
nttrd: exit
nsprecv: 73 bytes from transport
nsprecv: tlen=73, plen=73, type=4
nscon: got NSPTRF packet
nscon: got 61 bytes connect data
nsdo: nsctxrnk=0
nscall: refused
nstimarmed: no timer allocated
nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=3, flg=0x4201, mvd=0
nsdo: nsctxrnk=0
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 1888
nttdisc: exit
nsclose: global context check-out (from slot 0) complete
nsmfr: 2348 bytes at 0xbd0b90
nsmfr: 492 bytes at 0xbd0998
碧水幽幽泉 2009-12-10
  • 打赏
  • 举报
 回复
检查下服务名对了没？
zhengde007 2009-12-10
  • 打赏
  • 举报
 回复
监听器文件sid会对吗，好像是不对的
lxg213 2009-12-10
  • 打赏
  • 举报
 回复
tnsping.trc日志

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 10-12月-2009 14:57:18

Copyright (c) 1997 Oracle Corporation. All rights reserved.


--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
New trace stream is D:\oracle\ora92\network\trace\tnsping.trc
New trace level is 6
--- TRACE CONFIGURATION INFORMATION ENDS ---

--- PARAMETER SOURCE INFORMATION FOLLOWS ---
Attempted load of system pfile source d:\oracle\ora92\network\admin\sqlnet.ora
Parameter source loaded successfully

-> PARAMETER TABLE LOAD RESULTS FOLLOW <-
Successful parameter table load
-> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
TNSPING.TRACE_LEVEL = admin
NAMES.DIRECTORY_PATH = (TNSNAMES, HOSTNAME, ONAMES)
TNSPING.TRACE_DIRECTORY = D:\oracle\ora92\network\trace
SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---

--- LOG CONFIGURATION INFORMATION FOLLOWS ---
Log stream will be "standard output"
Log stream validation not requested
--- LOG CONFIGURATION INFORMATION ENDS ---

nnfun2awanm: entry
nnfgiinit: entry
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nnflcls: entry
nnflcls: exit
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is [root]
nnfun2a: entry
nlolgobj: entry
nnfgrne: entry
nnfgrne: Installing read path
nnfgsrsp: entry
nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
nnfgsrdp: entry
nnfgsrdp: Setting path:
nnfgsrdp: checking element TNSNAMES
nnfgsrdp: checking element HOSTNAME
nnfgsrdp: checking element ONAMES
nnfgsrdp: Path set
nnfgrne: Going though read path adapters
nnfgrne: Switching to TNSNAMES adapter
nnfgrne: Original name: 172.20.66.13
nnftinit: entry
nnftinit: Tnsnames refresh interval is 0
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_local_addrfile: entry
nnftmlf_make_local_addrfile: construction of local names file failed
nnftmlf_make_local_addrfile: exit
nlpaxini: entry
nlpaxini: exit
nnftmlf_make_system_addrfile: entry
nnftmlf_make_system_addrfile: system names file is d:\oracle\ora92\network\admin\tnsnames.ora
nnftmlf_make_system_addrfile: exit
nnftinit: exit
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfttran: entry
nnfgrne: Query unsuccessful, skipping to next adapter
nnfgrne: Switching to HOSTNAME adapter
nnfgrne: Original name: 172.20.66.13
nnfhqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nnfhqnm: Using hostname address (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=172.20.66.13))(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.66.13)(PORT=1521))) for name 172.20.66.13
nnfcraa: entry
nnfgrne: Name successfully queried
nnfhans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfgrne: exit
nlolgserv: entry
nnfggav: entry
nnfggav: exit
nnfgfrm: entry
nnfgfrm: exit
nlolgserv: exit
nlolgobj: exit
nlolfmem: entry
nlolfmem: exit
nnfun2awanm: Getting the path of sqlnet.ora
nnfun2awanm: Getting the adapter name
nnfun2awanm: exit
nsmal: 164 bytes at 0xb96ba8
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nttbnd2addr: entry
nttgetport: entry
nttgetport: port resolved to 1521
nttgetport: exit
nttbnd2addr: using host IP address: 172.20.66.13
nttbnd2addr: exit
nsmal: 492 bytes at 0xb985e0
nsmal: 2348 bytes at 0xbe0fb8
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: tcp.validnode_checking not turned on
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1888.
lxg213 2009-12-10
  • 打赏
  • 举报
 回复
east杀软套装卸载后一样超时
crazylaa 2009-12-10
  • 打赏
  • 举报
 回复
新装的east杀软套装是否把oracle的端口、应用啥的全禁咯挖？把east杀软里面的例外打开，加进oracle的应用及端口，绿灯放行。。。
时处理方法
解决oracle tnsping超时严重问题
oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
错误描述：oracle远程连接服务器出现 ORA-12170 TNS:连接超时 错误检查：有很多是oracle自身安装的问题，但是我这里服务器配置正常，监听正常，服务正常，远程可以ping通服务器。 这里主要是防火墙问题，解决办法： ...
Oracle 18c rac+dg+13.3的emcc部署配置
1、CentOS 7.3的安装及其基本配置 2、18c的rac+单实例的dg的部署 3、13.3的EMCC的安装及其使用 4、配置DG环境中的无缝切换（同一个TNS当主库挂掉的时候自动切换到备库）
解决ORA-12170:TNS connect timeout occurred问题
C:\Users\Administrator>tnsping brorcl TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 – Production on 15-6月 -2015 09:45:43 Copyright (c) 1997, 2010, Oracle. All rights reserved. 已使用的...
在客户端配置TNS测试报错ORA-12170:TNS:连接超时
在Red Hat Enterprise Linux Server Releae 5.5 成功安装ORACLE 10g 后，在客户端配置TNS后，测试是否可以连接到数据块服务器，结果报错： ORA-12170：TNS：连接超时1：首先检查网络是否能ping通，如下所示，网络是...
基础和管理

17,377

社区成员

95,128

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章