Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: max number of processes exceeded

Re: max number of processes exceeded

From: Nuno Souto <nsouto_at_acay.com.au>
Date: Thu, 24 Dec 1998 00:52:49 +1100
Message-ID: <3680f688.0@job.acay.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US