max_proc_per_user (=64) exceeded for uid

[DrRuss]

Hi,

For some reason I have just started getting messages such as:

task_create() failed for pid 134779: max_proc_per_user (=64) exceeded for uid 17.

On my DS20E server using Tru64 UNIX 5.1.

However the the user in question (batch) only has the following processes:

batch@uklonun02> ps -ef -ubatch
UID PID PPID C STIME TTY TIME CMD
batch 131891 1 0.0 02:15:34 ?? 0:00.44 /usr/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
batch 132047 1 0.0 02:16:14 ?? 0:01.67 /usr/nts/bin/swbtchca 60614E5F5A3C3C3C4B535560565D3C3C
batch 132048 1 0.0 02:16:14 ?? 0:01.24 /usr/nts/bin/swbtchca 60614E5F5A3C3C3C4B535560565D3C3C
batch 134756 132047 0.0 09:15:24 ?? 0:00.01 sleep 60
batch 134767 132048 0.0 09:15:24 ?? 0:00.01 sleep 60
batch 131957 134761 0.0 09:15:09 pts/1 0:00.04 -ksh (ksh)
Russ

 

[kjetiljensen]

One probably cause for this is that this user is forking off a lot of processes in a short period of time and then goes back to rest. I cannot really tell how your user is working, but you as an administrator should be able to say if this is a probably case or not. If the user (no user that is) never should spawn more than 64 processes you must check why this user does so. The other case is that if this user could be spawning/forking that much processes you must increase the number of proc:max_proc_per_user to eg. 256. Also check that proc:maxusers is 32 or higher.

 

[dblair]

If the batch user is running the Oracle listener process, then all connections to the DB will fork processes.

Increase as stated.

 

[DrRuss]

Hi,

This server is a develpopment server with only three developers connecting to the databases. Here is a list of the processes currently running:

ID PID PPID C STIME TTY TIME CMD
root 0 0 0.9 Mar 26 ?? 01:04:44 [kernel idle]
root 1 0 0.0 Mar 26 ?? 0:02.62 /sbin/init -a
root 3 1 0.0 Mar 26 ?? 0:00.09 /sbin/kloadsrv
root 5 1 0.0 Mar 26 ?? 0:00.03 /sbin/hotswapd
root 59 1 0.0 Mar 26 ?? 0:00.02 /sbin/update
root 173 1 0.0 Mar 26 ?? 0:02.63 /usr/sbin/evmd
root 204 173 0.0 Mar 26 ?? 0:00.36 /usr/sbin/evmlogger -o /var/run/evmlogger.info -l /var/evm/adm/logfiles/evmlogger.log
root 205 173 0.0 Mar 26 ?? 0:00.08 /usr/sbin/evmchmgr -l /var/evm/adm/logfiles/evmchmgr.log
root 311 1 0.0 Mar 26 ?? 0:00.14 /usr/sbin/syslogd -e
root 315 1 0.0 Mar 26 ?? 0:00.21 /usr/sbin/binlogd
root 329 1 0.0 Mar 26 ?? 0:00.02 /usr/sbin/routed -q
root 387 1 0.0 Mar 26 ?? 0:00.00 /usr/sbin/portmap
root 390 1 0.0 Mar 26 ?? 0:00.00 /usr/sbin/nfsiod 7
root 492 1 0.0 Mar 26 ?? 0:11.12 /usr/sbin/snmpd
root 502 1 0.0 Mar 26 ?? 0:00.12 /usr/sbin/svrMgt_mib
root 503 1 0.0 Mar 26 ?? 0:02.70 /usr/sbin/svrSystem_mib
root 506 1 0.0 Mar 26 ?? 0:00.17 /usr/sbin/os_mibs
root 507 1 0.0 Mar 26 ?? 0:00.02 /usr/sbin/pmgrd
root 518 1 0.0 Mar 26 ?? 0:00.85 /usr/sbin/cpq_mibs
root 539 1 0.0 Mar 26 ?? 0:00.14 /usr/sbin/cpqthresh_mib
root 557 1 0.0 Mar 26 ?? 0:11.10 /usr/sbin/insightd
root 558 1 0.0 Mar 26 ?? 1:45.28 /usr/sbin/envmond -ui cli
root 560 558 0.0 - ?? 0:00.00 <defunct>
root 566 1 0.0 Mar 26 ?? 0:00.75 /usr/sbin/config_hmmod
root 580 1 0.0 Mar 26 ?? 0:00.55 /usr/sbin/advfsd
root 583 1 0.0 Mar 26 ?? 0:00.82 /usr/sbin/sysman_hmmod
root 593 1 0.0 Mar 26 ?? 0:00.00 /usr/sbin/inetd
root 594 593 0.0 Mar 26 ?? 0:00.04 -child (inetd)
root 605 1 0.0 Mar 26 ?? 0:00.12 /usr/sbin/cron
root 641 1 0.0 Mar 26 ?? 0:00.01 /usr/lbin/lpd
root 657 1 0.0 Mar 26 ?? 0:00.04 /usr/dt/bin/dtlogin -daemon
root 698 1 0.0 Mar 26 ?? 0:01.30 /usr/opt/java118/bin/../bin/alpha/native_threads/java -mx2m authentication/server/AuthenticationServer
root 737 657 0.0 Mar 26 ?? 0:01.83 /usr/bin/X11/X :0 -auth /var/dt/authdir/authfiles/A:0-aaakra
root 738 657 0.0 Mar 26 ?? 0:00.01 dtlogin <:0> -daemon
root 773 1 0.0 Mar 26 ?? 0:00.13 /usr/bin/X11/dxconsole -geometry 816x150-102-0 -daemon -nobuttons -verbose -notify -exitOnFail -nostdin -bg gray
root 774 738 0.0 Mar 26 ?? 0:00.14 dtgreet -display :0
root 823 1 0.0 Mar 26 ?? 0:01.27 sendmail: accept -bd -q15m -om 2
oracle 900 1 0.0 Mar 26 ?? 0:00.68 ora_pmon_ARBT
oracle 902 1 0.0 Mar 26 ?? 0:00.44 ora_dbw0_ARBT
oracle 904 1 0.0 Mar 26 ?? 0:00.37 ora_lgwr_ARBT
oracle 906 1 0.0 Mar 26 ?? 0:41.26 ora_ckpt_ARBT
oracle 908 1 0.0 Mar 26 ?? 0:03.23 ora_smon_ARBT
oracle 910 1 0.0 Mar 26 ?? 0:00.06 ora_reco_ARBT
oracle 923 1 0.0 Mar 26 ?? 0:00.55 ora_pmon_SUN426
oracle 925 1 0.0 Mar 26 ?? 0:00.33 ora_dbw0_SUN426
oracle 927 1 0.0 Mar 26 ?? 0:00.26 ora_lgwr_SUN426
oracle 929 1 0.0 Mar 26 ?? 0:33.71 ora_ckpt_SUN426
oracle 931 1 0.0 Mar 26 ?? 0:02.18 ora_smon_SUN426
oracle 933 1 0.0 Mar 26 ?? 0:00.06 ora_reco_SUN426
root 943 1 0.0 Mar 26 ?? 0:02.63 /usr/sbin/smsd -d
oracle 131526 1 0.0 02:15:36 ?? 0:00.06 ora_reco_NTSA
oracle 131833 1 0.0 02:15:36 ?? 0:00.10 ora_dbw0_NTSA
oracle 131897 1 0.0 02:15:35 ?? 0:00.15 ora_pmon_NTSA
oracle 131900 1 0.0 02:15:36 ?? 0:01.75 ora_ckpt_NTSA
oracle 131901 1 0.0 02:15:36 ?? 0:00.07 ora_dbw1_NTSA
oracle 131903 1 0.0 02:15:36 ?? 0:00.09 ora_dbw2_NTSA
oracle 131905 1 0.0 02:15:36 ?? 0:00.07 ora_dbw3_NTSA
oracle 131910 1 0.0 02:15:36 ?? 0:00.11 ora_lgwr_NTSA
oracle 131916 1 0.0 02:15:36 ?? 0:00.89 ora_smon_NTSA
oracle 131935 1 0.0 02:15:47 ?? 0:00.08 ora_dbw0_NTSC
oracle 131938 1 0.0 02:15:47 ?? 0:00.17 ora_pmon_NTSC
oracle 131939 1 0.0 02:15:47 ?? 0:00.07 ora_dbw3_NTSC
oracle 131942 1 0.0 02:15:47 ?? 0:00.07 ora_dbw1_NTSC
oracle 131946 1 0.0 02:15:47 ?? 0:00.07 ora_dbw2_NTSC
oracle 131950 1 0.0 02:15:47 ?? 0:00.99 ora_smon_NTSC
oracle 131954 1 0.0 02:15:47 ?? 0:00.10 ora_lgwr_NTSC
oracle 131958 1 0.0 02:15:47 ?? 0:03.86 ora_ckpt_NTSC
oracle 131963 1 0.0 02:15:47 ?? 0:00.06 ora_reco_NTSC
oracle 131967 1 0.0 02:15:57 ?? 0:00.55 ora_smon_NTST
oracle 131970 1 0.0 02:15:57 ?? 0:00.09 ora_dbw0_NTST
oracle 131977 1 0.0 02:15:57 ?? 0:00.22 ora_pmon_NTST
oracle 131984 1 0.0 02:15:57 ?? 0:00.10 ora_lgwr_NTST
oracle 131990 1 0.0 02:15:57 ?? 0:00.05 ora_arc0_NTST
oracle 131991 1 0.0 02:15:57 ?? 0:03.91 ora_ckpt_NTST
oracle 131998 1 0.0 02:15:57 ?? 0:00.06 ora_reco_NTST
oracle 132018 1 0.0 02:16:07 ?? 0:03.97 ora_ckpt_ARBO
oracle 132025 1 0.0 02:16:07 ?? 0:00.22 ora_pmon_ARBO
oracle 132027 1 0.0 02:16:07 ?? 0:00.09 ora_dbw0_ARBO
oracle 132028 1 0.0 02:16:07 ?? 0:00.10 ora_lgwr_ARBO
oracle 132030 1 0.0 02:16:08 ?? 0:00.06 ora_reco_ARBO
oracle 132034 1 0.0 02:16:08 ?? 0:00.42 ora_smon_ARBO
oracle 132038 1 0.0 02:16:08 ?? 0:00.05 ora_arc0_ARBO
batch 132047 1 0.0 02:16:14 ?? 0:02.94 /usr/nts/bin/swbtchca 60614E5F5A3C3C3C4B535560565D3C3C
batch 132048 1 0.0 02:16:14 ?? 0:02.38 /usr/nts/bin/swbtchca 60614E5F5A3C3C3C4B535560565D3C3C
oracle 132058 132047 0.0 02:16:17 ?? 0:00.29 oracleNTST (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 132061 132048 0.0 02:16:17 ?? 0:00.58 oracleNTSC (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 134620 1 0.0 08:49:23 ?? 0:01.70 oracleARBO (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
root 134761 594 0.0 09:15:08 ?? 0:00.08 telnetd
oracle 135335 1 0.0 10:30:14 ?? 0:09.11 oracleNTSA (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
root 135538 594 0.0 11:00:14 ?? 0:00.01 rlogind
oracle 135781 1 0.0 11:14:50 ?? 0:00.64 oracleNTSA (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 138163 1 0.0 14:26:44 ?? 0:00.11 oracleARBT (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 138454 1 0.0 15:01:24 ?? 0:02.62 oracleNTSA (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
batch 138494 132047 0.0 15:05:34 ?? 0:00.01 sleep 60
batch 138502 132048 0.0 15:05:34 ?? 0:00.01 sleep 60
root 950 1 0.0 Mar 26 console 0:00.01 /usr/sbin/getty console console vt100
batch 131957 134761 0.0 09:15:09 pts/1 0:00.07 -ksh (ksh)
batch 135805 1 0.0 11:16:03 pts/1 0:00.31 /usr/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
batch 135827 131957 0.0 11:16:50 pts/1 0:00.02 ksh
root 138504 135827 0.0 15:06:33 pts/1 0:00.04 ps -ef
root 135539 135538 0.0 11:00:14 pts/2 0:00.05 -sh (sh)
root 135567 135539 0.0 11:01:53 pts/2 0:00.06 xterm -sb
root 135556 135567 0.0 11:01:55 pts/3 0:00.01 sh
root 135557 135556 0.3 11:02:13 pts/3 2:16.26 dxproctuner

The number of batch processes including those from lsnrctl is still less than 64.

Russ

 

[dblair]

This is a 'snapshot' of the processes - we cannot tell exactly what is running at the time of the failure. The oracle user is close to 64.
The answer is to increase the Kernel setting.