Upgrade fails due to limited number of database processes

Upgrade fails with the following exception:

Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found.....

This exception occurs if the number of processes allowed at the database level are not sufficient.

Fix: Increase the number of processes allowed at the database level, as follows:

  1. Log on and connect to the SQL Plus as system administrator: connect / as sysdba
  2. Increase the number of processes (default 100) to the desired value, <numProcesses>:
    alter system set processes=<numProcesses> scope=spfile
    For more information about this parameter, see the Oracle documentation.
  3. Shutdown the database: shutdown immediate
  4. Startup the database: startup
  5. Check the changes have taken effect: show parameter processes
  6. Start with the upgrade.
    If the issue is not resolved yet, increase the value of the processes parameter further.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*