ORA-01017: invalid username/password; logon denied
However, the problem cannot be solved in the EM 10g (Grid Control and DB Control) because other configuration files need to be modified.
Original article: http://blog.itpub.net/post/493/15071
The method is as follows:
1. Grid Control
Assume that the password I set for the sysman user during installation is
Mybmw530i, now I want to change it to mybmw745i,
What should I do?
Step 1: change the password in sqlplus
SQL> conn sys/xxx As sysdba;
SQL> alter user sysman identified by mybmw745i;
If there is a ORA-28000 error (account is unlocked ),
Unlock the account (with the account unlock clause added)
Step 2: Modify the emoms. properties File
The Directory of this file is $ ORACLE_HOME/sysman/config.
Find the following two rows:
Oracle. sysman. eml. mntr. emdreppwd =...
Oracle. sysman. eml. mntr. emdreppwdencrypted = true
When OMS is started, the password of the sysman user is encrypted and stored in
File. Therefore, we need to decrypt it and reset the password.
Oracle. sysman. eml. mntr. emdreppwd = mybmw745i
Oracle. sysman. eml. mntr. emdreppwdencrypted = false
Step 3: Modify the targets. xml file
This file will be found in the following two directories:
$ Oms_home/sysman/config
$ Agent_home/sysman/config
Obviously, we should modify the next file because the agent will detect the target host
All targets and store the information in this file.
Open this file and find the following parts:
<Target type = "oracle_emrep"
Name = "Management Services and repository" version = "1.0">
...
<Property name = "username" value = "XXX" encrypted = "true"/>
<Property name = "password" value = "XXX" encrypted = "true"/>
</Target>
Modify:
<Property name = "username" value = "sysman" encrypted = "false"/>
<Property name = "password" value = "mybmw745i" encrypted = "false"/>
Step 4: restart OMS and agent.
2 dB Control
The basic modification method is the same as above. It is only the path of targets. xml
Changed to $ ORACLE_HOME/hostname_sid/sysman/EMD.
Description 3
1. If the password of Dbsnmp is modified, you also need to modify the two configuration files mentioned above;
2. directly run the emca command line script to complete the modification.