TNSPINGtimeout/响应慢
E:\s01\app\oracle\product\11.2.0\dbhome_1\BIN>tnsping CENORCL
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 25-MAY-2015 10:26:59
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
e:\s01\app\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = W01SQL0601.p
harmatechs.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = cenorcl)))
OK (266310 msec)
查了些资料后发现是listener.log超过4G就会出现这个问题,解决很简单。
lsnnrctl stop
删除listener.log
lsnrctl start
恢复正常。
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。