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”. 🙂
