Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the operating system user maximum number of processes limit maxuproc how to do, the article is rich in content and professional analysis and description for you, after reading this article, I hope you can get something.

Question:

There is a limit to the number of sessions connected to the database by application response.

1. Check the 3000 set by process, and the limit is not reached.

2. An error is reported in the monitoring log:

03-AUG-2017 14:34:52 * (CONNECT_DATA= (SERVICE_NAME=iomtestdb) (CID= (PROGRAM=INAS-V1) (HOST=jm_csminf2) (USER=inas) * (ADDRESS= (PROTOCOL=tcp) (HOST=10.193.139.38) (PORT=65379)) * establish * iomtestdb * 12518

TNS-12518: TNS:listener could not hand off client connection

TNS-12536: TNS:operation would block

TNS-12560: TNS:protocol adapter error

TNS-00506: Operation would block

IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailable

# # based on the error report of the listening log, the suspicion is related to the resource limit of the operating system.

3. The system's limit on the maximum number of processes per user:

Oracle@iomtest:/home/oracle > lsattr-E-l sys0 | grep maxuproc

Maxuproc 128 Maximum number of PROCESSES allowed per user True

Oracle@iomtest:/home/oracle > exit

Iomtest:/home/admin1# chdev-l sys0-a maxuproc=16384

Sys0 changed

Iomtest:/home/admin1# lsattr-E-l sys0 | grep maxuproc

Maxuproc 16384 Maximum number of PROCESSES allowed per user True

Iomtest:/home/admin1#

After modifying the operating system limit maxuproc = 16384, it returns to normal.

This is how to limit the maximum number of processes for operating system users shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.