After changing DBSNMP and SYSMAN password from Enterprise Manager console (11.2.0.3), because they were about to expire, in trace file emagent.trc there was following error:
ERROR vpxoci: ORA-01017: invalid username/password; logon denied
WARN vpxoci: Login 0xac0012a0 failed, error=ORA-01017: invalid username/password; logon denied
These are the steps done to fix it:
1. cd $ORACLE_HOME/node_SID/sysman/emd
2. cp targets.xml targets.xml.orig
3. vi targets.xml
change
<Property NAME="password" VALUE="31668048b077a956" ENCRYPTED="TRUE"/>
into
<Property NAME="password" VALUE="oracle" ENCRYPTED="FALSE"/>
4. emctl start dbconsole
5. more targets.xml -- to see that the new password was encrypted
<Property NAME="password" VALUE="768d4318a832681b" ENCRYPTED="TRUE"/>
Bacause that was a RAC database, i done the same procedure on the other node.
The password for SYSMAN had to be changed also.
1. emctl stop dbconsole
2. emctl setpasswd dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://node1:1158/em/console/aboutApplication
Please enter new repository password:
Repository password successfully updated.
3. emctl start dbconsole
ERROR vpxoci: ORA-01017: invalid username/password; logon denied
WARN vpxoci: Login 0xac0012a0 failed, error=ORA-01017: invalid username/password; logon denied
These are the steps done to fix it:
1. cd $ORACLE_HOME/node_SID/sysman/emd
2. cp targets.xml targets.xml.orig
3. vi targets.xml
change
<Property NAME="password" VALUE="31668048b077a956" ENCRYPTED="TRUE"/>
into
<Property NAME="password" VALUE="oracle" ENCRYPTED="FALSE"/>
4. emctl start dbconsole
5. more targets.xml -- to see that the new password was encrypted
<Property NAME="password" VALUE="768d4318a832681b" ENCRYPTED="TRUE"/>
Bacause that was a RAC database, i done the same procedure on the other node.
The password for SYSMAN had to be changed also.
1. emctl stop dbconsole
2. emctl setpasswd dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
https://node1:1158/em/console/aboutApplication
Please enter new repository password:
Repository password successfully updated.
3. emctl start dbconsole
No comments:
Post a Comment