ORA-00020 maximum number of processes exceeded

Cause: In oracle pl sql error all the process object are in use.

Action: Incrementare il parametro PROCESS initialization o killare una sessione esistente. Per incrementare il parametro modificare il file ini di Oracle e riavviare l'istanza del database.

Sessions may not be properly terminated, or might be using parallel processes. Ask your DBA to increase the PROCESSES parameter. REMARK: current parameter value for PROCESSES = 300

Connected to an idle instance "usually means that you connected "AS SYSDBA" and the instance you connected to is not started. However, if your instance is out of processes, then a non-SYSDBA connection will error out with ORA-00020, and a SYSDBA connection will error out with "Connected to idle instance."