Tuesday, August 21, 2012

ERROR vpxoci: ORA-01017: invalid username/password; logon denied

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


No comments:

Post a Comment