IEA Software, Inc.

IEA Software Knowledge Base - ID:58389

IEA Knowledge base

Emerald (KB ID: 58389)

Sep 14 2009

When using Emerald the message
"[Oracle][ODBC][Ora]ORA-12520: TNS:listener could not find available handler for requested type of server" is displayed. What causes this and how can the problem be corrected?

Sep 14 2009

This is not an Emerald related issue. We strongly recommend consulting your Oracle DBA for resolution of this problem.

The error is usually caused by exceeding the configured concurrent Oracle database connection limit.

To display the current process limit use the query:
"show parameter process"

To increase the global concurrent process limit to 400 use the query:
"alter system set processes=400 scope=spfile"

After this change is made the database server must be restarted to take effect.