网上是了多种方法都不行:重启监听服务、修改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.关闭监听写日志