Re: Max. Number of processes

100.17706_at_germanynet.de writes:
>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.
>

Are you using unlimit before you re-start the databases as root?

BTW, Solaris 7 has the ability to support around 32,000 process ids in the process table. It's EXTREMELY unlikely that your databases would be spawning that many child processes. It's far more likely they're running into their own limit that's either configured in or hard-coded in, or they're running into something like the file descriptor ulimit.

Since the error is being reported by an Oracle database, what do the folks at Oracle say about it?

  -Greg

-- 
Do NOT reply via e-mail.
Reply in the newsgroup.