When trying to log into ALM Siteadmin or User Application, login fails due to the following error. Messages: Failed to Login in HP ALM ERROR: ORA-00020: maximum number of processes (500) exceeded.

  • Questions
  • When trying to log into ALM Siteadmin or User Application, login fails due to the following error. Messages: Failed to Login in HP ALM ERROR: ORA-00020: maximum number of processes (500) exceeded.
Question ID: 105741
0
0

Hello,

We are getting the above error issue when trying to log into our instance of HP ALM. We are using Oracle DB server and receiving the following error message:

ERROR:
ORA-00020: maximum number of processes (500) exceeded

Any assistance ti correct this issue is greatly appreciated.

Thanks,
HomerJ

Marked as spam
Posted by (Questions: 340, Answers: 26)
Asked on December 4, 2014 4:24 pm
7 views
Answers (1)
1
Private answer

HI HomerJ,

It has been recommended that you check the processes that are running and kill any errant processes that may be running but are not maintaining a connection and the max processes allowed parameter on the Oracle DB configuration side. You may need to kill some of the processes that are connected but not currently running in order to facilitate log in for trouble shooting the connection issue. I am not sure what other applications are using this server, but it may need to be restarted to release and kill the dead process connections if you are unable to kill them through commands. Your DBA should be able to kill some of the ''dead'' process connections to enable log in to trouble shoot the issue.

Hope this helps,
Dan

Marked as spam
Posted by (Questions: 0, Answers: 735)
Answered on December 4, 2014 4:25 pm
Thanks for the assistance. We tried your suggestions and all worked. System is able to login again. Thanks
( at December 4, 2014 4:26 pm)