Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: max number of processes exceeded
Check out if the OS has enough semaphores defined. SEMMNS from memory in the
UNIX config screens of HP/UX. Have had this problem before. Used to be the
SHMMAX but latest versions are not limited on this. SEMMNS is still a problem.
Basically, you need one semaphore per user process. The default of HP/UX is
usually 120, which get consumed by all sorts of stuff, not only ORACLE. Jack
the number up to 256, re-create the OS, re-boot and you should be able to use
more than 60 processes in ORACLE.
HTH
--
Cheers
Nuno Souto
nsouto_at_acay.com.au
Calvin Cheong wrote in message <367ef9cd.3621081_at_news.pacific.net.sg>...
>HPUX 10.20
>Oracle 7.3.2.3
>>Parameter "processes" is set to 60 currently. But still encountering
>>oracle errors saying maximum number of processes exceeded. Thus
>>cannot connect to database.
Received on Wed Dec 23 1998 - 07:52:49 CST