Search This Blog

Thursday, September 8, 2011

How to change SYSMAN user password in 11gr1 on linux (oracle enterprise respository)

Changing SYSMAN user password.

OS Linux
Oracle 11gr1


Step
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.

2 comments:

Anonymous said...

Excellent beat ! I would like to apprentice while you amend your site, how can i subscribe for a blog site?
The account helped me a acceptable deal. I
had been a little bit acquainted of this your broadcast offered bright
clear concept

My site :: Sharecash Surveys

Anonymous said...

After I initially commented I appear to have
clicked the -Notify me when new comments are added- checkbox and from now on each time a
comment is added I receive 4 emails with the same comment.
There has to be a way you can remove me from that service?
Thanks a lot!

Here is my page :: Cityville 2 Working Bot