How to change the SYSMAN Password on OEM 12C/13C
Posted by Mir Sayeed Hassan on April 11th, 2021
How to change the SYSMAN Password on OEM 12C/13C.
Check the current database status
SQL> select instance_name,status,version from v$instance, v$database; INSTANCE_NAME STATUS VERSION ---------------- ------------ ----------------- oemdb OPEN 12.1.0.2.0
To change/reset the sysman password, you need to know the sys password of database.
Note: In case if you don’t know the sys password, you can change the sys password and proceed further.
To change the sys password
SQL> alter user sys identified by *********; User altered.
Locate the OMS bin location
[oracle@oemdb ~]$ cd /u01/oem13.4c/middleware/bin
Check the current status of OMS
[oracle@oemdb bin]$ ./emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Up JVMD Engine is Up
Stop the OMS
[oracle@oemdb bin]$ ./emctl stop oms Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... Oracle Management Server Successfully Stopped Oracle Management Server is Down
Change the SYSMAN password
Syntax: emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd <sys password> -new_pwd <new sysman password>
[oracle@oemdb bin]$ ./emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd ******** -new_pwd ********* Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 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.
Stop the OMS with -all option
[oracle@oemdb bin]$ ./emctl stop oms -all Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Stopping Oracle Management Server... WebTier Successfully Stopped Oracle Management Server Already Stopped Oracle Management Server is Down JVMD Engine is Down
Start the OMS
[oracle@oemdb bin]$ ./emctl start oms Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Starting Oracle Management Server... WebTier Successfully Started Oracle Management Server Successfully Started Oracle Management Server is Up JVMD Engine is Up
Check the status of oms
[oracle@oemdb bin]$ ./emctl status oms Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. WebTier is Up Oracle Management Server is Up JVMD Engine is Up
[oracle@oemdb bin]$ ./emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 4 Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root (SYSMAN) Password : Console Server Host : oemdb HTTP Console Port : 7788 HTTPS Console Port : 7802 HTTP Upload Port : 4889 HTTPS Upload Port : 4903 EM Instance Home : /u01/oem13.4c/gc_inst/em/EMGC_OMS1 OMS Log Directory Location : /u01/oem13.4c/gc_inst/em/EMGC_OMS1/sysman/log OMS is not configured with SLB or virtual hostname Agent Upload is locked. OMS Console is locked. Active CA ID: 1 Console URL: https://oemdb:7802/em Upload URL: https://oemdb:4903/empbs/upload WLS Domain Information Domain Name : GCDomain Admin Server Host : oemdb Admin Server HTTPS Port: 7102 Admin Server is RUNNING Oracle Management Server Information Managed Server Instance Name: EMGC_OMS1 Oracle Management Server Instance Host: oemdb WebTier is Up Oracle Management Server is Up JVMD Engine is Up BI Publisher Server Information BI Publisher Managed Server Name: BIP BI Publisher Server is Down BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command