ORA-00020: maximum number of processes (150) exceeded

ORA-00020: maximum number of processes (150) exceeded

If you are working with a local copy of oracle and its installed with default settings, You will surely encounter this error. Maximum number of processes (150) exceeded. We have an enterprise application which requires lots of connections at startup. As soon as the applications starts, it consumes all the available connections from Oracle and system generates the above error. The above error clearly suggests that the number of connections must be increased. To increase the number of connections on Oracle you simple need to follow the under listed instructions:

How to increase number of connections in Oracle

You can use the Oracle SQL developer to connect to your current Oracle Installation.

Connect to Oracle database with your credentials.

Open a new query

Copy and paste the under given code in the query box

[themify_quote]alter system set processes=1000 scope=spfile; [/themify_quote]

Press the run button to execute the query.

Once you are done successfully. restart the oracle service from services panel. The connections will reset from 150 to 1000. You can choose an appropriate number of connections according to your needs. This solved my problem and increased the number of connections for Oracle installed in my testing environment. Please make sure you have complete database backup before trying this query. This query is provided as is and windows tech updates is not liable of any loss or damage.

If you are getting this error in production environment contact your Oracle DBA so that he/she can fix it. If you found this post useful, please share it with your friends. Visit windows tech updates again for more articles about troubleshooting your network environment. We mostly share information about Microsoft applications and infrastructure, like Share Point, Microsoft Dynamics CRM, Microsoft Azure, Microsoft SQL Server, Windows 10, Microsoft Online Share point and Dynamics CRM. Please feel free to share your comments about windows tech updates.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.