小弟在一个实验环境上做测试,导致process资源使用过多而无法连接上数据库
ERROR:
ORA-00020: maximum number of processes (%s) exceeded
上metalink查看解决办法如下:
1. Increase the 'PROCESSES' parameter in initSID.ora. For ORACLE_SID = aa8i, modify initaa8i.ora, typically in %ORACLE_BASE%\admin\aa8i\pfile.
注: The 'PROCESSES' parameter determines the maximum number of operating system processes that can be connected to Oracle concurrently. The value of this parameter must include 5 for the background processes and 1 for each user process. For example, to have 50 concurrent users, set this parameter to at least 55.
2. Restart the database by restarting the OracleServiceaa8i service.