OGG-00664

Symptoms

The replicat process abending with ORA-00020: maximum number of processes (150) exceeded.

2026-05-17 17:51:55  ERROR   OGG-00664  OCI Error beginning session (status = 20-ORA-00020: maximum number of processes (150) exceeded).
2026-05-17 17:51:55  ERROR   OGG-01668  PROCESS ABENDING.

Solution

Kill all useless processes.

~]$ ps -ef | grep 'LOCAL=NO' | grep orcl | kill -9 `awk '{print $2}'`

Increase the number of processes and restart the database.

SQL> show parameter processes
SQL> alter system set processes=1500 scope=spfile;
SQL> shutdown immediate
SQL> startup