Scalability Engine crashes Unable to Retrieve Database Properties on Oracle MDB

Document ID : KB000015500
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Collect Engine may fail with 

Unable to Retrieve Database Properties from Manager: <name of Domain Manager>. COAPI Returned:25

After a restart of the engine, it may work for a while but fail again later on.

You will find some ORA-12516 msgs in the logs.

Question:

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

How to increase the stack handler value

Environment:
Win2008R2 with Oracle 11.2.0.4 on same system.DSM Version: 14.1But it may happen on other flavours of Oracle and ITCM also
Answer:

You need to increase the stack handler value for Oracle.

Refer to 

http://www.toadworld.com/products/benchmark-factory/f/45/t/1230

and

https://community.oracle.com/thread/307117