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

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

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 of 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