IBM Support

Large number of inactive Oracle processes created by one user performing a simple task (for example a logon) caused by defect APAR PI60308 in Controller

Troubleshooting


Problem

Oracle DBA has noticed a large number of inactive processes listed on the Oracle database server. Specifically, it appears that approximately 10 times more Oracle processes are created during a process (for example a single user logon) when using Controller 10.2 (compared with the older Controller 10.1 version). - In some environments, this can (eventually) cause an error message.

Symptom

Example #1:

In one real-life test (using Controller 10.2.2039 connected to Oracle 11G release 2):

One user launching Controller client and reaching logon screen...


...created 2 new 'INACTIVE' processes (associated with this database).

After typing in the username/password, and reaching the 'actuality' choice screen...

...there were a total of 20 INACTIVE processes (associated with this database).

After clicking OK (and the Controller client was finally open)...


...there were now 32 INACTIVE processes.

Then after closing Controller client, there were still 32 INACTIVE processes.

Example #2:

In a different real-life test (using Controller 10.2.5130.56 connected to Oracle 11G release 2):

  • One user launching Controller client and reaching logon screen created 2 new 'INACTIVE' processes (associated with this database).
  • After typing in the username/password, and reaching the 'actuality' choice screen, there were a total of 19 INACTIVE processes (associated with this database).
  • After clicking OK (and the Controller client was finally open) there were now 32 INACTIVE processes.
  • Then after closing Controller client, there were still 32 INACTIVE processes.
 

Potential Error message:

Eventually (after a while) the number of free processes may drop to zero. When this happens, the users will get the following error message:


    • ORA-12520: TNS:listener could not find available handler for requested type of server

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21978834

Page Feedback