Node-oracledb: Multiple request failure and getting [Error: ORA-12516: TNS:listener could not find available handler with matching protocol stack

[calvinrajat]

While sending multiple request in apache jmeter to test for 100 api requests, I am getting some failed responses and the error corresponding to these failed request is :

[Error: ORA-12516: TNS:listener could not find available handler with matching protocol stack 

After failing for some requests, the subsequent request are working fine.

My db configuration is :

  "poolMax":100,
  "poolMin":2,
  "poolIncrement":5,
  "poolTimeout":4,
  "poolAlias":"pool1"

Can you please tell me the reason for the same as the maximum pool size is also not reached ?

[cjbj]

Errors

  ORA-12516: TNS:listener could not find available handler with matching protocol stack

or

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

typically occur if the DB server's processes setting isn't large enough. Bump this up. If you're unsure how, there are command-line steps on p 318 of the free PHP & Oracle book http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html

[calvinrajat]

Thanx @cjbj