网上是了多种方法都不行:重启监听服务、修改listener.ora、重启服务器
最终查询监听日志,发现 监听日志有4G
根据网上解释windows下Oracle的listener.log大小达到4G
The listener is hung or is extremely slow to respond.
Tnspings to the listener take a very long time (seconds) to respond or the ping hangs completely.
Lsnrctl utility commands are either hanging or slow to respond.
ADR Diagnostics are enabled in this environment and the flat file TNSListener log file is at or approaching the size of 4 gigabytes.
解决方法:
1.windows计划任务定时删除
2.关闭监听写日志
本文详细介绍了当Oracle监听日志文件达到4G时,导致的监听服务响应缓慢或挂起的问题。提供了两种解决方案:一是通过Windows计划任务定期清理日志;二是关闭监听器的日志记录功能。
3077

被折叠的 条评论
为什么被折叠?



