We know about "nproc" limits in Linux which are set in /etc/limits.conf and checked with "ulimit -u". Nproc is defined at OS level to limit the number of processes per user. Oracle 11.2.0.4 documentation recommends the following:
oracle soft nproc 2047
oracle hard nproc 16384
But that is often too low, especially when we have the Enterprise Manager agent or other java programs running. When the environment are over these values, the connection with the server gets stuck and the message is displayed "Resource temporarily unavailable". Most of times the solution is to access the server with the root user and then kill OMA process or other java processes running. Doing this some resources will be released and then we will be able to connect to the server again.
Does anybody know how to handle the monitoring and be alerted when we're close the fixed limit? I mean, to monitor and be alerted using Metric Extensions or something like that in Oracle Enterprise Manager 12c or 13c?
Thanks a lot.
Bruno Palma