Re: Please Help: Maximum number of processes exceed
Date: 1998/11/05
Message-ID: <GhCSoEAlSYQ2IAKb_at_nisoft.demon.co.uk>#1/1
In article <36417C43.DD3B12B0_at_webhost.co.za>, Rene <rene_at_webhost.co.za>
writes
>Hi there,
>
>I hope someone can help with this one.
>
>If you can, please reply to: rene_at_webhost.co.za
>
>SCENARIO:
>---------
> - Sun Solaris 2.5.1 running Oracle 8.0.4 on a UltraSparc 5
> - Web-based Oracle application developed using PL/SQL procedures
>
>PROBLEM:
>--------
> - After a certain amount of users have connected (50, I think), I get
>the following error, when trying to get into SQL*PLUS:
>ERROR:ORA-00020: maximum number of processes (50) exceeded
>
>I know this is probabley VERY easy to fix, but I simply don't know where
>of what setting to change to make this problem go away. I am not sure if
>it's a UNIX setting of processes, or an Oracle setting that needs to be
>changed.
>
>I am able to duplicate the problem by opening up around 40-50 telnet
>session and then opening each with SQL*PLUS. At some point I obviously
>then get this error.
>
>For what it's worth, the following is a setting in the /etc/system-file:
>ulimit unlimited
>
>Any help would be greatly appreciated.
>
>Best regards,
>rene_at_webhost.co.za
Hi Rene
There is an initsid.ora parameter that holds the number of users allowed by the current installation of Oracle. There is also another parameter that sets a warning limit, so that, for example you could have a 'hard' limit of 100 users, but set the warning limit to 90 so that when the concurrency peaks above 90 you will get a warning.
All well and good, but I can't remeber what the parameters are called! Back to the group for the exact answers.
By the way, the increasing of these limits is between you and your Oracle dealer!
HTH
-- Tim Shute Software Engineering Manager NiSoft (UK) Limited Unit 8, 31 Ballynahinch Road, Carryduff, BELFAST BT8 8EH Tel: +44 (0) 1232 814121, Fax: +44 (0) 1232 813962 email: tshute_at_nisoft.co.uk Internet: www.nisoft.co.ukReceived on Thu Nov 05 1998 - 00:00:00 CET