• Article Type: General
• Product: Aleph
• Product Version: 20, 21

Description:
PC server and web server log files give message "ORA-00020: maximum number of processes (%s) exceeded".
For example:

-a18(1) >>cd $LOGDIR
-a18(1) >>grep -i 'ORA-00020' www_server_4991.log* | sort -u
www_server_4991.log.2502.0950:ORA-00020: maximum number of processes (%s) exceeded
www_server_4991.log.2502.1033:ORA-00020: maximum number of processes (%s) exceeded
-a18(1) >>grep -i 'ORA-00020' pc_server_6991.log* | sort -u
pc_server_6991.log.2502.0950:ORA-00020: maximum number of processes (%s) exceeded
pc_server_6991.log.2502.1033:ORA-00020: maximum number of processes (%s) exceeded
-a18(1) >>

Resolution:
This can be in most cases solved by changing Oracle settings.
Need to Set Oracle processes to 400, open_cursors to 1000 and sessions to 400.
Here is how it may be done:
Login as sqlplus aleph_dba/aleph_dba as sysdba


Issue the following commands:
SQL> alter system set open_cursors=1000 scope=both;
SQL> alter system set sessions=400 scope=spfile;
SQL> alter system set processes=400 scope=spfile;


Then do aleph_shutdown, restart Oracle (via util O), and aleph_startup.