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 APRIL 12, 2024

Applies to:

Symptoms

On : 9.3.6.0 version, Application Server

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

ERROR
-----------------------
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

Changes

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

Cause

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