Random failures with Oracle 11g2 ORA-12520

Products

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

Issue/Introduction

 

Random errors with 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

 

Resolution

Review and discuss with your Oracle DBA - they should be increasing the number of available processes and sessions for connection pools at the Oracle database. 

The following is provided for reference purposes

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

sqlplus system/eurekify@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.

 

 

Additional Information

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;