ORA-12540: TNS Internal Limit Restriction Error

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 :
    /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