Correct sysman and dbsnmp passwords in Oracle

Source: Internet
Author: User
In Oracle, the process of modifying the sysman and dbsnmp passwords is correct. Stop dbconsole $ emctlstopdbconsole to view the status and confirm that dbconsole has stopped $ emctlstatus

In Oracle, the process of modifying the sysman and dbsnmp passwords is correct. stop dbconsole $ emctl stop dbconsole to view the status and confirm that dbconsole has stopped $ emctl status.

1. Stop dbconsole
$ Emctl stop dbconsole
Check the status and confirm that dbconsole is stopped.
$ Emctl status dbconsole

2. Modify the passwords of sysman and dbsnmp users
$ Sqlplus/as sysdba
SQL> alter user sysman identified by xxx;
SQL> alter user dbsnmp identified by yyy;
Unlock a user
SQL> alter user sysman account unlock;
SQL> alter user dbsnmp account unlock;
Confirm that the password has been modified
SQL> conn sysman/xxx;
Connected.
SQL> conn dbsnmp/yyy;
Connected.

3. modify the configuration file
(Associated with sysman)
Go to the $ Oracle_HOME/(host) _ (sid)/sysman/config directory.
A. Save emoms. properties as emoms. properties. old.
B. Modify the emoms. properties file.
Find oracle. sysman. eml. mntr. emdRepPwd = and replace the encrypted string with the password xxx you just changed;
Find oracle. sysman. eml. mntr. emdRepPwdEncrypted = TRUE and change TRUE to FALSE.

(Related to dbsnmp)
Go to the $ ORACLE_HOME/(host) _ (sid)/sysman/emd directory.
$ Cp targets. xml targets. xml. bak
$ Vi targets. xml
Modify the following code:


Use the new dbsnmp password to replace the Value of the password listed above, and change the Value of ENCRYPTED to FALSE.

4. Restart dbconsole and access EM to restore normal
$ Emctl start dbconsole

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.