EM 12c: How to Change the Password of the MGMT_VIEW User in the Enterprise Manager 12c Cloud Control Repository Database (Doc ID 1635840.1)

Last updated on FEBRUARY 03, 2017

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 to 12.1.0.3.0 [Release 12.1]
Information in this document applies to any platform.

Goal

During repository creation, a user named MGMT_VIEW is also created. This view is used by Enterprise Manager for the reporting framework. The OMS is the only entity which uses this account, hence the password is not normally exposed to administrators. However, you can still change the password if needed, which requires an OMS restart.

Since this account is used only by the OMS, it is not normally necessary to maintain the password of this account manually unless, for example, the MGMT_VIEW account is locked in the repository database or ORA-1017 results when a report is generated.

 

Solution

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