Too many processes

[gheventer]

Hi, I'm currently working on a HP-UX 10.20 system which is a Oracle Database Server.&nbsp;&nbsp;Well I have a problem with my HP-UX.<br><br>#The fork function failed.&nbsp;&nbsp;Too many processes already exist.<br><br>Any ideas about this message?<br><br>Do anybody have ideas on this kind of problem?<br><br>My database stopped....<br><br><br>

 

[AndyBo]

It looks like Oracle is trying to kick off another process to handle a user request.&nbsp;&nbsp;The fork failed, so Oracle shut down the whole database because it found a problem.&nbsp;&nbsp;The reason the fork failed is because the server had hit it's maximum number of user processes that it was configured for.<br><br>You need to amend some kernel tunables.&nbsp;&nbsp;If you've never done this before, or have the slightest question about something, contact your HP/UX support vendor.&nbsp;&nbsp;If you compile the kernel incorrectly then you can stop the whole system from booting...<br><br>The tunables you need to amend are (and please check these before changing them), MAXUSERS, NPROC, and MAXUPROC.&nbsp;&nbsp;If I recall correctly, increasing MAXUSERS should result in the total amount of available system processes being increased, as this is based on the number of users.<br><br>There is a very friendly Kernel Tuning module in SAM that will let you change the values.<br><br>Hope this helps.