MGMT_VIEW user & changing password

When working with Information publishing reports, you may have to grant access like “select on v$session” to the MGMT_VIEW under the OMR database. If let’s suppose you have granted and assumed that you done with your job, But are you sure after the grant whether MGMT_VIEW user able to access those Objects? So to crosscheck it is necessary to connect user and test them. Unfortunately during creation of repository the password of MGMT_VIEW will not be exposed.  Don’t  think that changing password will be done with just “alter user identified by”, then again it will be big mess.   In order to change password of MGMT_VIEW user  you must use emctl utility from OMS_HOME.   This is very short article but must know before you touch MGMT_VIEW.  All these below commands will work of Enterprise manager cloud control 12.1.0.1.0 and later.

1) Change password of MGMT_VIEW using emctl

[oracle@oradb01 ~]$ emctl config oms -change_view_user_pwd -sysman_pwd oracle123 -user_pwd oracle123
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
It is also necessary to restart the BI Publisher Managed Server.
Successfully changed MGMT_VIEW User's password.
[oracle@oradb01 ~]$

2) Stop all OMS tiers

[oracle@oradb01 ~]$ emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
Stopping BI Publisher Server...
BI Publisher Server Successfully Stopped
AdminServer Successfully Stopped
BI Publisher Server is Down
[oracle@oradb01 ~]$

4) Start OMS

[oracle@oradb01 ~]$ emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
Starting BI Publisher Server ...
BI Publisher Server Successfully Started
BI Publisher Server is Up
[oracle@oradb01 ~]$

All the above commands should run from only OMS_HOME. Ensure proper path is exported before executing command by “which emctl”. 🙂