ORA12519

在run load test的时候,web server后台日志中出现了不少如下的错误信息...

Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
10.80.15.19:1521:orcl

查看了下数据库后台的一些trace 文件和alert文件发现如下信息...

-- alert file...

Wed Oct 12 18:08:28 2011
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.

-- trace file...
*** 2011-10-12 18:06:20.255
ORA-00020: maximum number of processes 500 exceeded

很显然是因为参数processes的值太小了的原因,因为load test触发了太多的session,所以需要调大这个参数.

网上有篇文章也提到这个问题...

http://blog.csdn.net/diguoguo/article/details/6185536

原文地址:https://www.cnblogs.com/fangwenyu/p/2208993.html