Sunday, July 13, 2014

How to Reset the Password for SYSMAN user at OMS level and at Repository Database


It has been a long time we have used SYSMAN password and the password repository is not updated with the current Password.

So the only option left out is to reset the password for SYSMAN user at OMS level and also at Repository Database.

**************************************** Step By Step Procedure ******************************************************

Current SYSMAN Password is UNKNOWN

#########################################
# 1) Shutdown OMS
#########################################

set OMS environment and shut it down

emctl stop oms

[oracle@host01 ~]$ emctl stop oms
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
[oracle@host01 ~]$

=====================================================================================================================

#########################################
# 2) Reset SYSMAN Password
#########################################

We should have Repository Database SYS password to reset the SYSMAN user password

emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd sys123 -new_pwd sysman123

[oracle@host01 ~]$ emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd sys123 -new_pwd sysman123
Oracle Enterprise Manager Cloud Control 12c Release 4
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
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.
[oracle@host01 ~]$

Note :
-------

a) -sys_pwd = Repository Database SYS user password
b) -new_pwd = New Password for SYSMAN User

=====================================================================================================================

#########################################
# 3) Stop OMS
#########################################

emctl stop oms

[oracle@host01 ~]$ emctl stop oms
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 Already Stopped
Oracle Management Server is Down
[oracle@host01 ~]$

=====================================================================================================================

#########################################
# 4) Start OMS
#########################################

emctl start oms

[oracle@host01 ~]$ 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
[oracle@host01 ~]$

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================

No comments: