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;

  COUNT(*)
----------
       149
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)