"ORA-00020: maximum number of processes (500) exceeded" when attempting to connect to the Oracle Database on IGL
Originally Published: 2018-02-06
Last Modified: 2023-10-06
Article Number
Applies To
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.x
Issue
ORA-00020: maximum number of processes (500) exceeded
Cause
Resolution
select resource_name, current_utilization, max_utilization, limit_value from v$resource_limit where resource_name in ('sessions', 'processes');
Once you know what the current limit is set to, you can increase it using the following replacing X with a value higher than the process limit from the previous query:
alter system set processes=X scope=spfile;
Workaround
You also have the option to kill any zombie process you have identified. In this situation you may not be able to get a free process to establish a connection to Oracle. This would prevent you from identifying which process belongs with which user or query. This makes killing individual processes carry some risk of killing a process you do not wish to.
Notes
Related Articles
Howto: Change the Master Encryption Key Storage Directory in RSA Identity Governance and Lifecycle (IGL) 109Number of Views RSA G&L Community Exchange Overview and FAQs 159Number of Views How to determine the Oracle database version in RSA Identity Governance & Lifecycle 46Number of Views RSA Via Lifecycle & Governance 6.9.1 Access Fulfillment Express (AFX) connectors stuck in deployed state 68Number of Views RSA Identity Governance & Lifecycle ServiceNow connector fails with "handshake_failure" 144Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Authentication Manager Patch Updates RSA Authentication Manager Upgrade Process
Don't see what you're looking for?