My Oracle Support Banner

ORA-12520: TNS:listener Could Not Find Available Handler For Requested Type Of Server (Doc ID 2497102.1)

Last updated on OCTOBER 23, 2021

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.3.1 to 2.3.1 [Release 2.3]
Information in this document applies to any platform.


**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
OUAF/FW - Oracle Utilities Framework
DB - Database
JVM - Java Virtual Machine
UCP - Universal Connection Pool


Facing below error while accessing the application & batch modules.
ORA-12520: TNS:listener could not find available handler for requested type of server

DB team has mentioned that, total allowed process limit is reached due to inactive sessions and Inactive sessions has to be terminated at Application level.

Is there any functionality to clear inactive sessions at application end.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.