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

Symptoms

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

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

Enter user-name: 

Cause

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.

Solution

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: support@ispirer.com