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

Article Id: 143682

Status: Published

Updated On: 18-02-2020 14:25

Products:

DX Infrastructure Management , 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.