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

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Identity Manager fails to perform an activity with the following error in the logs:

Oracle 11g2 : "ORA-12520: TNS:listener could not find available handler for requested type of server"

 

 

 

Environment

Release: Identity Manager with Oracle backend database.

Cause

This is due to lack of Oracle processes and sessions

To view the current configuration of your processes and sessions run the following command:

SQL> select name, value from v$parameter where name in ('processes','sessions');

 

To view the current number of sessions run:

SQL> select count(*) from gv$session;

Resolution

The following is provided for reference purposes and contains changes to the Oracle Database to increase the number of processes and sessions. 
Review these changes with your Oracle DBA. 

In oracle server machine login with system user through sqlplus, for example:

sqlplus system/oracaleuser@orcl

note: orcl is the service name that is configured for your oracle server.

Run the following two commands:

SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=300 scope=spfile;

where '300' is the number of processes / sessions that you want to set.