My Oracle Support Banner

EM 13c: High Contention On MGMT_USER_CONTEXT When Creating/Modifying Private Role Using Emcli Command (Doc ID 2649064.1)

Last updated on MAY 30, 2020

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud control, Row lock contention on MGMT_USER_CONTEXT table when creating or modifying private role with access to sysman user.

When attempting to use the emcli command to create a role there is a contention happen on the following MGMT_USER_CONTEXT

$ emcli create_role '-name=<Private_role_name>'
'-type=EM_ROLE'

'-privilege=GET_CREDENTIAL;NC_SYS_AS_SYSDBA'
-private_role '-users=<Users_list>:WITH_ADMIN'

If running this command two times, it will stop the oms.



Changes

 

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.