Oracle Process Limit exceeds

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

ORA-12520: TNS:listener could not find available handler for requested type of

server: arithmetic syntax error


When you get this error, check what is the limit for database process and how many connections are already established:  If processes reached to the limit, database will not allow sysdba to login also.

SQL> show parameter processes
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     150
SQL> select count(*) from v$process;

SQL> alter system set processes=300 scope=spfile;

System altered.

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)