IDM fails with "ORA-12516, TNS:listener could not find available handler with matching protocol stack"

book

Article ID: 37743

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction

Symptoms: 

Intermittently, while Identity Manager is up and running, the server starts to fail with the following error in the application server log:

Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack

 

Environment:  

Any IM version that is using Oracle as a runtime database.

 

Cause: 

The Oracle database server (hosting the Controller database) has run out of available processes (and is therefore stopping new connections to be made to the server) Oracle database server's value for "PROCESSES" has been configured too low

 

Resolution

Consult with your Oracle DBA to consult official Oracle documentation to confirm the best method to increase the value for PROCESSES for your Oracle environment.

 

Additional Information:

Please refer to this link for further details on troubleshooting the Oracle configuration:

http://www-01.ibm.com/support/docview.wss?uid=swg21603472 

Environment

Release: CAIDMB99000-12.6-Identity Manager-B to B
Component: