jump to navigation

How to Change SYSMAN User Password July 1, 2009

Posted by sendtoshailesh in Uncategorized.
trackback

Carefully when change SYSMAN password
through below procedure we can change SYSMAN user password

1.connect to database server with SYSMAN user

SQL> conn sysman/sysman1@oem
Connected.
SQL> password
Changing password for SYSMAN
Old password:
New password:
Retype new password:
Password changed\

2. stop DBCONSOLE services

C:\>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.5.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://Localhost:5501/em/console/aboutApplication
The OracleDBConsoleoem service is stopping…………
The OracleDBConsoleoem service was stopped successfully.

3. edit emoms.properties , targets.xml files
Located : emoms.properties ===$ORACLE_HOME/localhost.domainname_sid/sysman/config/
Located : targets.xml ========$ORACLE_HOME/localhost.domainname_sid/sysman/emd/

emoms.properties

oracle.sysman.eml.mntr.emdRepPwd=”c7021fd3720a0f18″ replace with PASSWORD
oracle.sysman.eml.mntr.emdRepPwdEncrypted=”TRUE” replace with FALSE

oracle.sysman.eml.mntr.emdRepPwd=ORACLE
oracle.sysman.eml.mntr.emdRepPwdEncrypted=FALSE

targets.xml

[Property NAME=”UserName” VALUE=”80ec9025e45b2d20″ ENCRYPTED=”TRUE”/]

[Property NAME=”password” VALUE=”94124d177df7c5d9″ ENCRYPTED=”TRUE”/]

Replace username value with “SYSMAN” and password value with “SYSMAN PASSWORD”

[Property NAME=”UserName” VALUE=”SYSMAN” ENCRYPTED=”TRUE”/]

[Property NAME=”password” VALUE=”ORACLE” ENCRYPTED=”TRUE”/]

4. startup dbconsole services

C:\>set oracle_sid=oem

C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.5.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://taj.domainname.local:5501/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control …The OracleDBConsoleoe
m service is starting…………….
The OracleDBConsoleoem service was started successfully.

5.Unlock SYSMAN account

SQL> alter user sysman account unlock;

User altered.

Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: