Hi,
Here I am discussing problem regarding improper set of nproc or maxuproc values yield ORA-12540: TNS Internal Limit Restriction Error in database. New connections will terminates with the above mentioned error.
Here we need to set Operating system parameters(maximum number of user process)
In linux :
chdev -l sys0 -a maxuproc=NewValueChange
NewValueChange should be 16384 or even more but keeping in mind on processor and memory.
Please feel free to ask if any doubt on this.
Here I am discussing problem regarding improper set of nproc or maxuproc values yield ORA-12540: TNS Internal Limit Restriction Error in database. New connections will terminates with the above mentioned error.
Here we need to set Operating system parameters(maximum number of user process)
In linux :
/etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384
In Aix:
chdev -l sys0 -a maxuproc=NewValueChange
NewValueChange should be 16384 or even more but keeping in mind on processor and memory.
Please feel free to ask if any doubt on this.
No comments:
Post a Comment