ORA-00020: maximum number of processes (800) exceeded

[oracle@db04-1 ~]$ sqlplus -prelim / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期四 8月 31 10:00:51 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved.

SQL> oradebug setmypid
已处理的语句
SQL> oradebug unlimit
已处理的语句
SQL> oradebug dump systemstate 10
已处理的语句
SQL> oradebug tracefile_name
/oracle/db/diag/rdbms/dzbl/dzbl1/trace/dzbl1_ora_89945.trc

[oracle@db04-1 ~]$ more /oracle/db/diag/rdbms/dzbl/dzbl1/trace/dzbl1_ora_89945.trc

 此时，应用系统不可用。

中间件：was  连接池：40—60

数据库服务器user process情况：

[oracle@db04-1 ~]$ps -ef |grep "oracleorcl (LOCAL=NO)"|wc -l
745

[oracle@db04-2 ~]$ps -ef |grep "oracleorcl (LOCAL=NO)"|wc -l
714

 [oracle@db04-1 ~]$kill -9 `ps -ef |grep "oracleorcl (LOCAL=NO)"|awk '{print $2}'`

 [oracle@db04-2 ~]$kill -9 `ps -ef |grep "oracleorcl (LOCAL=NO)"|awk '{print $2}'`

应用系统恢复正常。

[oracle@db04-1 ~]$sqlplus / as sysdba

SQL> alter system set process =1000 sid='*';

 

知识扩展：

oracle systemstate dump介绍　　http://www.cnblogs.com/kerrycode/p/5236927.html

oracle dump转储的方法  　　http://blog.chinaunix.net/uid-66396-id-2688891.html