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.
Release : 9.2.0
Component : UIM - UMP
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.