Scalability Engine crashes Unable to Retrieve Database Properties on Oracle MDB

book

Article ID: 15500

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/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.



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

Resolution

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