TNS-12520

  Hi,

we are having 2 node RAC 10.2.0.4 db on solaris.

Getting  TNS-12520: TNS:listener could not find available handler for requested type of server

in listener log .it is intermittent,not regular in both the instances.

Tried restarting listener on both the nodes.

Also,

SQL> select * from gv$resource_limit where resource_name in ('processes','sessions');

   INST_ID RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
---------- ------------------------------ ------------------- --------------- ---------- ----------
         1 processes                                      302             440       5000       5000
         1 sessions                                       575             725       5505       5505
         2 processes                                      309             468       5000       5000
         2 sessions                                       559             718       5505       5505

 

Please suggest.

thanks

nk