How To Change the Password of the Database User Sysman (DB Control Repository Schema)

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

How to change the password of the Database User SYSMAN when the database is hosting a DB Control Repository.

Database Release prior 10.2.0.4

1. Stop the DB Control 
    emctl stop dbconsole


2. Connect to the database as a user with DBA privilege with SQL*Plus and execute:
    alter user sysman identified by <password> ;

3.  Edit the file emoms.properties

1. Search for the line beginning with:
   oracle.sysman.eml.mntr.emdRepPwd=
   Replace the encrypted value by the new password value
   
2. Search for the line:
   oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
   Replace TRUE by FALSE 

4. Restart the DB Control

    emctl start dbconsole

Database Release beginning 10.2.0.4

1. Stop the DB Control 

    emctl stop dbconsole

2. Connect to the database as a user with DBA privilege with SQL*Plus and execute:

    alter user sysman identified by <password> ;

3. From the database directory $ORACLE_HOME/bin, execute:

    $ emctl setpasswd dbconsole

4. Restart the DB Control

    emctl start dbconsole

    

Get Oracle Certifications for all Exams
Free Online Exams.com