Re: Please Help: Maximum number of processes exceed

Also it is important to note, that when you increase the PROCCESSES parameter, you will need to edit the etc/system file to change the SEMMNS and SEMMSL parameters as well. Failing to do so may result in the inability to start up the database.

Satar

In article <3641910D.EAE69C37_at_sybrandb.demon.nl>,   Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> An oracle setting, the processes parameter in init<sid>.ora. This file is
> located in
> $ORACLE_HOME/dbs. As the number of processes doesn't change very often it
> may also be located in the file config<sid>.ora in the same directory. Edit
> it or add it, shutdown the database and restart and it should be resolved.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Rene 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 Thu Nov 05 1998 - 00:00:00 CET