Re: Max. Number of processes

Go to the Oracle documentation for installing the product on your operating system specifically. If some variety of UNIX, check the settings for your semaphores. Too few is one cause of what you are experiencing.

Van

"Darren Dunham" <ddunham_at_redwood.taos.com> wrote in message news:6_TE9.697$i07.43419878_at_newssvr21.news.prodigy.com...
> In comp.unix.solaris Rick Denoire <100.17706_at_germanynet.de> wrote:
> > Hello
>
> > I run two Databases in one server (Oracle 8.1.7/Solaris 2.7 on a
> > E3500). At times, users cannot connect to any of these two DB because
> > the "max. number of processes has been reached". So I once changed the
> > corresponding parameter in the init.ora file of both DB. It happened
> > then that only one of the two DB could be started, namely the first
> > one, whichever was started first. After restoring the original value
> > of the parameter (smaller value again), both DB could be started.
>
> > So it seems that the DB are competing for the limited resources of the
> > number of processs allowed by the *operating system*. So it is this OS
> > parameter that should be increased in the first place. I just don't
> > know how to do that, but assume that one would change some line in the
> > /etc/system file and restart the machine.
>
> Usually you get that error not because you're administratively limited,
> but because you're resource limited. Are you sure you're not out of
> memory? Are you getting any messages in /var/adm/messages?
>
> --
> Darren Dunham ddunham_at_taos.com
> Unix System Administrator Taos - The SysAdmin Company
> Got some Dr Pepper? San Francisco, CA bay area
> < This line left intentionally blank to confuse you. >
Received on Tue Nov 26 2002 - 18:31:30 CST