Can't log into UMP: Oracle error ORA-12516

book

Article ID: 143682

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

When trying to log into UMP, we're getting this error:

An unknown error has occurred.
Refreshing your browser may resolve the issue.

Details:
com.firehunter.ump.exceptions.DataFactoryException : Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12516, TNS:listener could not find available handler with matching protocol stack
 )
Please check the log for more information.

Environment

Release : 9.2.0

Component : UIM - UMP

Resolution

Increase the number of connections on the DB size by executing the following queries as SYSDBA:

.
ALTER SYSTEM SET PROCESSES = 500 SCOPE=SPFILE;
ALTER SYSTEM SET SESSIONS = 555 SCOPE=SPFILE; 

"SESSIONS" should be set to PROCESSES * 1.1 for best performance.

Make sure your DB already has configured 200, 300 or 400 - this will work but If your DB has already 500 or above, please adjust for what you need.  In some cases we have seen a need to set PROCESSES to 750 and SESSIONS to 830; this could be higher or lower for your specific environment and some experimentation may be needed.  Consult with a qualified DBA for details.