Wednesday, June 12, 2013

12c Cloud Control: How to Modify the Password for SYSMAN at the OMS level

Below are the steps to modify 'SYSMAN' password at the OMS/WLS and Repository Database level in cloud control setup.

Please Not, you can not change the password at the database level using 'Alter user' command as the password is also stored in  WLS credential store. If done directly in the repository database then there will be a mis-match of password at the database level and OMS level leading to malfunctioning of OMS

oms_server:/u/oracle $ cd $ORACLE_HOME
oms_server:/u01/app/oracle/middleware/oms $ cd bin
oms_server:/u01/app/oracle/middleware/oms/bin $ emctl status oms


Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Up

oms_server:/u01/app/oracle/middleware/oms/bin $ emctl stop oms

Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

oms_server:/u01/app/oracle/middleware/oms/bin $ emctl config oms -change_repos_pwd

Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Enter Repository User's Current Password : (enter current password)
Enter Repository User's New Password : (enter new password)

Changing passwords in backend ...
Passwords changed in backend successfully.
Updating repository password in Credential Store...
Successfully updated Repository password in Credential Store.
Restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.
Successfully changed repository password.

oms_server:/u01/app/oracle/middleware/oms/bin $ emctl stop oms -all


Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Already Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

oms_server:/u01/app/oracle/middleware/oms/bin $ emctl start oms

Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...

Starting WebTier...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up

No comments:

Post a Comment