Changing SYSMAN user password.
Oracle 11gr1
Steps:
1. stop oem services
2. check db control is stopped
3. connect to the database as a user with DBA privilege and change sysman password
4. connect with new password to check
5. go to $ORACLE_HOME/bin directory and execuate emctl setpasswd command
Details:
stop dbconsole services
[oracle@testorapd bin]$ ./emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://testorapd.dummy.local:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
... Stopped.
check dbconsole services stopped properly
[oracle@testorapd bin]$ ./emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://testorapd.dummy.local:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
connect with DBA privilege user and change sysman password
[oracle@testorapd bin]$ ./sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 8 13:37:07 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user sysman identified by oracle;
User altered.
SQL> --check new password to connect sysman with new password
SQL> conn sysman/oracle
Connected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
execute emctl setpasswd command to set new password in oem repository.
[oracle@testorapd bin]$ ./emctl setpasswd dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://testorapd.dummy.local:1158/em/console/aboutApplication
Please enter new repository password:
Repository password successfully updated.
start dbconsole services
[oracle@testorapd bin]$ ./emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://testorapd.dummy.local:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory /db/product/11.2.0/dbhome_1/testorapd.dummy. local_oramfe/sysman/log
NOTE: Same steps also applicable for WINDOWS platform.
No comments:
Post a Comment