Re: Please Help: Maximum number of processes exceed

In $ORACLE_HOME/dbs/init$ORACLE_SID.ora put processes=... Don't forget to change parameters transactions and sessions accordingly. Mladen Gogala.
In article <36417C43.DD3B12B0_at_webhost.co.za>,   rene_at_webhost.co.za wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 00:00:00 CET