Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial

ORA-12520: TNS:Listener Could Not Find Available Handler for Requested Type of Server


During the import into the Oracle database it asks you for a password with the following preceding statement:

ORA-12520: TNS:listener could not find available handler for requested type of

Enter user-name: 


As the default the parameter called PROCESSES is specified as 40 or something like that in the Oracle Server. This parameter controls the number of processes running simultaneously in one instance on Oracle. Usually it is not enough for large databases with large amount of objects and data.


Please increase PROCESSES to 100, 200 or even higher.

To increase it, please perform the following steps:

In the System:

  1. set ORACLE_SID=<TNS Service Name>

In the SQLPlus:

  1. SQL> alter system set processes=400 scope=spfile;
  2. SQL> shutdown immediate;
  3. SQL> startup;

After that please try rerunning the import.

NOTICE: Please note that the database must be restarted to apply the new value of the processes parameter.

If you have any other questions, please contact us: