ORA-00020: maximum number of processes (%s) exceeded
来源:互联网 发布:苏州网络品牌营销 编辑:程序博客网 时间:2024/06/02 01:31
we encounter the below problem yesterday morning:
(1) All running batch application hang running half-way
(2) Attempt to login via sqlplus giving below error:
ERROR:
ORA-00020: maximum number of processes (%s) exceeded
REMARK:
current parameter value for PROCESSES = 300
(3) Attempt to connect as sys to shutdown the database giving the below:
Connected to an idle instance.
(at this point, we check that all background
processes like pmon, smon, etc still exists)
(4) the instance later being terminated by LGWR, & we manage to startup (without
need to shut it down)
**********************************************************
referring to item (3), is anyone out there able to provide me a PRECISE explanation for what does it mean here "connected to an idle instance" in such a scenario?
Answer by Mark:
"Connected to an idle instance" usually means that you connected "AS SYSDBA" and the instance you connected to is not started.
However, if your instance is out of processes, then a non-SYSDBA connection will error out with ORA-0020, and a SYSDBA connection will error out with "Connected to idle instance." It's a little misleading, but that's what happens.
Usually, when this happens, I want to get connected to the instance, so that I can try to figure out which user is causing the problem. One way to do that is to use the 'ps' command to identify some of the oldest server processes, and kill the 3-5 oldest processes, and then quickly try connecting to the database. Once you're in, you can look at things like V$SESSION to try and determine which user(s) is (are) consuming so many connections, and then go from there.
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- ORA-00020: maximum number of processes (%s) exceeded
- ORA-00020: maximum number of processes (%s) exceeded问题解决过程
- ORA-00020: maximum number of processes (%s) exceeded 的解决方法
- oracle启动 ORA-00020: maximum number of processes (%s) exceeded错误
- ORA-00020: maximum number of processes (500) exceeded
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020: maximum number of processes (2000) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020:maximum number of processes (150) exceeded 错误解决方法
- 解决ORA-00020:maximum number of processes (150) exceeded 错误
- ORA-00020: maximum number of processes (1000) exceeded 故障一列
- ASM 异常 ORA-00020: maximum number of processes (100) exceeded
- ORA-00020: maximum number of processes (150) exceeded
- ORA-00020:maximum number of processes (500) exceeded 错误解决方法
- 制作浏览器地址栏&收藏夹里的小图标
- ubuntu 配制nfs
- SqlServer 临时表
- recursion in prolog
- C++引用与const引用
- ORA-00020: maximum number of processes (%s) exceeded
- 随笔一下
- iSilo for S60 4.32 破解
- innerText,innerHTML的用法
- QuidWay S3026的端口聚合
- Ubuntu 服务器指南
- 关于 BeanListHandler的用法
- [PB]今日问题
- 使用indy 9发送邮件支持SSL选项,gmail测试通过