Pages

Search This Blog

Showing posts with label OEM. Show all posts
Showing posts with label OEM. Show all posts

Thursday, August 27, 2020

OEM account dbsnmp locked.

 Use Case:  

We have changed passwords as part of regular DBA activity.  OEM account dbsnmp got locked after change.

 

Fix:

  1. Change passwords for users sys and system
  2. Run orapwd
  3. In OEM, update config for sys: Setup>Security>Named Credentials
  4. Change password for user dbsnmp
  5. Quickly update OEM config for dbsnmp: Setup>Security>Monitoring Credentials

 

If the dbsnmp account still keeps locking, bounce the db and try steps 4 and 5 again.

 Good Luck.

 

 


Tuesday, January 14, 2020

Oracle Enterprise Manager Cloud Control 13c SYSMAN Password Reset

Steps to reset the password for SYSMAN in Oracle Enterprise Manager Cloud Control 13c:

The following information must be specified when the command is executed.

1. sys password(sys_pwd)
2. New password for sysman(new_pwd)

Steps to reset,

1. Stop all OMS process
cd $OMS_HOME/bin
emctl stop oms

2. Change the SYSMAN password
cd $OMS_HOME/bin
emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys password> -new_pwd <new sysman password>

Example Output:
$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd ******* -new_pwd *********
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 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.


3. Stop Admin Server on the primary OMS and restart OMS.
cd <oms home>/bin
emctl stop oms -all
emctl start oms


4. Check that OMS is up and running.

cd <oms home>/bin
emctl status oms -details