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