Search This Blog

Monday, September 12, 2011

How to change SYSMAN user password in 10gr2 on linux (oracle enterprise repository)

Changing SYSMAN user password
Old password: manager1
New password: oracle
OS: LINUX
ORACLE 10GR2

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:
-bash-3.00$ set ORACLE_SID=orcl
-bash-3.00$ emctl status dbconsole
TZ set to Asia/Dubai
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://spioradev.sterling.local:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /db/app/oracle/Db_1/spioradev.sterling.local_orc                                                                             l/sysman/log

-bash-3.00$ emctl stop dbconsole
TZ set to Asia/Dubai
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://spioradev.sterling.local:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
 ...  Stopped.

-bash-3.00$ sqlplus sysman/manager1

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Sep 12 16:31:30 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> password
Changing password for SYSMAN
Old password:
New password:
Retype new password:
Password changed
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Pr                                                                             oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options

-bash-3.00$ emctl setpasswd dbconsole
TZ set to Asia/Dubai
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://spioradev.sterling.local:1158/em/console/aboutApplication
Please enter new repository password:
Repository password successfully updated.

-bash-3.00$ emctl start dbconsole
TZ set to Asia/Dubai
Oracle Enterprise Manager 10g Database Control Release 10.2.0.5.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://spioradev.sterling.local:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ............. started.
------------------------------------------------------------------
Logs are generated in directory /db/app/oracle/Db_1/spioradev.sterling.local_orc                                                                             l/sysman/log

No comments: