EM 12.1.0.4: EMCLI Inactive Sessions are not Closed in Repository Database (Doc ID 2294916.1)

Last updated on AUGUST 08, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

12.1.0.4 EM

Executing the following query in repository database shows many INACTIVE sessions which are not closed and they are created by EMCLI

SQL>select sid,serial#,username,status,action from v$session where action='/cli';

This can lead to Max Processes limit reached errors in the repository database over a period of time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms