Important This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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*