AIX: Oracle DBA says that his database is not able to go beyond certain limit. For example, oracle userid is not able to start more than 500 process’s. Whats the issue?

Date: September 19, 2016Author: Panchamoorthy M

This is because of the “maxuproc” value is 500. Check the value using “lsattr -El sys0 -a maxuproc”
If required change the value using
# chdev -l sys0 -a maxuproc=1000
Normally for Oracle Production machines, you have to consult with DBA’s while installing the server and set an agreed value.

%d bloggers like this:

Technical Blog for System Administrator

You can see a real scenario of work experience

AIX: Oracle DBA says that his database is not able to go beyond certain limit. For example, oracle userid is not able to start more than 500 process’s. Whats the issue?

Share this:

Like this:

Related