ora-12528:TNS:Listener:所有适当的实例都在阻止新连接 [英] ora-12528: TNS:Listener: All Appropriate instances are blocking new connections
问题描述
当我尝试连接到数据库时出现此错误:
I am getting this error when I try to connect to my database:
ora-12528:TNS:Listener:所有适当的实例都在阻止新连接
ora-12528: TNS:Listener: All Appropriate instances are blocking new connections
我尝试了以下操作,但没有成功:
I tried the following, with no success:
- 停止并启动监听器.
- 关闭和启动数据库.
- 重新启动oracle服务.
我该如何解决?
推荐答案
您可能对网络和/或存档日志有问题-当存储存档日志的区域/磁盘已满时,通常会发生上述情况,Oracle然后拒绝新的连接.
You might have a problem with either the network and/or the archive logs - the above usually happens when the area/disk where the archive logs are stored is full, Oracle then just refuses new connections.
另一种可能性是您已最大化允许的连接数-这通常应作为警告信号,表明您的应用程序可能会泄漏连接.
Another possibility is that you maxed out the number of allowed connections - this should usually be warning sign that you might have an application which leaks connections.
如果您100%确保没有泄漏连接,则可以将Oracle配置为接受更多连接(注意许可,RAM等!).
If you are 100% sure that you are not leaking connections then you could configure Oracle to accept more connections (BEWARE of licensing, RAM etc.!).
这篇关于ora-12528:TNS:Listener:所有适当的实例都在阻止新连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!