My Oracle Support Banner

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

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
Cause
Solution
References


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