My Oracle Support Banner

Multiple Issues After Server Starts error "Too many open files" error "ORA-00020: maximum number of processes (xxx) exceeded" and INACTIVE SESSION (Doc ID 2461790.1)

Last updated on NOVEMBER 11, 2022

Applies to:

Oracle Agile PLM Framework - Version and later
Information in this document applies to any platform.


On : version, Application Server

When attempting to log into Agile Web Client,
the following error occurs.

1. Web Client shows HTTP 500
2. Agile Application Server shows error "Too many open files"
3. Oracle Database Server shows error "ORA-00020: maximum number of processes (xxx) exceeded"
4. Massive numbers of INACTIVE SESSION in Oracle Database Server

SELECT DISTINCT username, status, COUNT(*) FROM v$session WHERE username='AGILE' GROUP BY username, status ORDER BY status, count(*) DESC;

USERNAME                       STATUS        COUNT(*)
------------------------------ ------------  --------
AGILE                          INACTIVE         1435
AGILE                          ACTIVE             21


 User deployed a customized program into Agile, which directly visits Agile database instances with massive request.


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.