ORA-12520: TNS:listener Could Not Find Available Handler For Requested Type Of Server
(Doc ID 2497102.1)
Last updated on JULY 22, 2024
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.
Goal
**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
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.
Solution
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
| Goal |
| Solution |
| References |