oracle ora-12528：TNS:Listener：所有合适的实例都在阻止新连接
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9987193/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ora-12528: TNS:Listener: All Appropriate instances are blocking new connections
提问by Geet
I am getting this error when I try to connect to my database:
当我尝试连接到我的数据库时出现此错误：
ora-12528: TNS:Listener: All Appropriate instances are blocking new connections
ora-12528：TNS:Listener：所有合适的实例都在阻止新连接
I tried the following, with no success:
我尝试了以下方法，但没有成功：
- Stop and Start the Listener.
- Shutdown and Startup database.
- Restart the oracle services.
- 停止和启动侦听器。
- 关闭和启动数据库。
- 重启oracle服务。
How might I resolve this?
我该如何解决这个问题？
回答by Yahia
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.
您可能有网络和/或存档日志的问题 - 当存储存档日志的区域/磁盘已满时，通常会发生上述情况，然后 Oracle 只是拒绝新连接。
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.
另一种可能性是您已将允许的连接数最大化 - 这通常应该是警告信号，表明您可能有一个泄漏连接的应用程序。
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.!).
如果您 100% 确定您没有泄漏连接，那么您可以将 Oracle 配置为接受更多连接（注意许可、RAM 等！）。
