Sunday , December 22 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

ORA-00020: Maximum Number Of Processes Exceeded

Buğra PARLAYAN January 15, 2023 ORACLE

When i tried to connect to database, I got the ORA-00020: maximum number of processes (%s) exceeded error.

Even from sysdba I was not able to connect.

Solution:

Step 1 : Connect to database with prelim option and shutdown abort.
 
$ sqlplus -prelim
SQL> shutdown abort.
 
exit
 
Step 2 : Change the processes parameter to a higher value in the init.ora file.
 
3. SQL> STARTUP

Step 1 : Connect to database with prelim option and shutdown abort.

$ sqlplus -prelim

SQL> shutdown abort.

exit

Step 2 : Change the processes parameter to a higher value in the init.ora file.

3. SQL> STARTUP

About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

ORA-00020: Maximum Number Of Processes Exceeded

Solution:

About Buğra PARLAYAN

Leave a Reply Cancel reply