Change SYSMAN account password Oracle RAC / Single Instance database

Following steps can  be used to change SYSMAN account password for Oracle RAC / single instance database. This can be done online.

Login to the server where target database runs as oracle software owner os user.

ibs-ash-sr133 oraaires [MYDBSTG2]:emctl status dbconsole Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name. ibs-ash-sr133 oraaires [MYDBSTG2]:sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Aug 12 11:17:08 2011 Copyright (c) 1982, 2010, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> show parameter db_uni NAME                                 TYPE        VALUE ------------------------------------------------------ db_unique_name                       string      MYDBSTG SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ibs-ash-sr133 oraaires [MYDBSTG2]:export ORACLE_UNQNAME=MYDBSTG ibs-ash-sr133 oraaires [MYDBSTG2]:emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /projects/aires/product/11.2.0/aires_stg/ibs-ash-sr133_MYDBSTG/sysman/log ibs-ash-sr133 oraaires [MYDBSTG2]:emctl stop dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Stopping Oracle Enterprise Manager 11g Database Control ...  ...  Stopped. ibs-ash-sr133 oraaires [MYDBSTG2]:emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Oracle Enterprise Manager 11g is not running. ibs-ash-sr133 oraaires [MYDBSTG2]:sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Fri Aug 12 11:19:42 2011 Copyright (c) 1982, 2010, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> alter user sysman identified by we#t04q; User altered. SQL> conn sysman/we#t04q Connected. SQL> show user USER is "SYSMAN" SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options ibs-ash-sr133 oraaires [MYDBSTG2]:emctl setpasswd dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Please enter new repository password: Repository password successfully updated. ibs-ash-sr133 oraaires [MYDBSTG2]:emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Starting Oracle Enterprise Manager 11g Database Control ....... started. ------------------------------------------------------------------ Logs are generated in directory /projects/aires/product/11.2.0/aires_stg/ibs-ash-sr133_MYDBSTG/sysman/log ibs-ash-sr133 oraaires [MYDBSTG2]:emctl status dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved. https://ibs-ash-sr133.ibsdc.com:5500/em/console/aboutApplication Oracle Enterprise Manager 11g is running. ------------------------------------------------------------------ Logs are generated in directory /projects/aires/product/11.2.0/aires_stg/ibs-ash-sr133_MYDBSTG/sysman/log ibs-ash-sr133 oraaires [MYDBSTG2]:

Reference : How To Change the Password of the Database User Sysman (DB Control Repository Schema) [ID 259379.1]