My Oracle Support Banner

Multiple Issues After Server Starts For A While (Doc ID 2461790.1)

Last updated on OCTOBER 17, 2018

Applies to:

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

Symptoms

On : 9.3.6.0 version, Application Server

When attempting to login 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

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
Symptoms
Changes
Cause
Solution


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