This discussion is archived
11 Replies Latest reply: Aug 28, 2013 1:37 PM by Hussein Sawwan-Oracle RSS

FNDCPASS was not able to decrypt password for user

cced8331-eb20-43ed-b167-333a4c2a3161 Newbie
Currently Being Moderated

Hello,

We are trying to finish 2 nodes Oracle Applications clone from Prod to Dev instance. While trying to change APPS password using FNDCPASS, there must have been some issue. Unfortunately, autoconfig was run after running the failed FNDCPASS for Apps password change. Now, our applications would not start and complains about wrong password.

 

I see that the APPS password in Database is still the old password. When I try to change it by following command it fails.

FNDCPASS apps/<Old password> 0 Y system/**** SYSTEM APPLSYS <New Password>

 

The error message in the FNDCPASS log is below :-

........

FNDCPASS was not able to decrypt password for user 'FPA' during applsys

password change.

FNDCPASS was not able to decrypt password for user 'ZPB' during applsys

password change.

FNDCPASS was not able to decrypt password for user 'APPS' during applsys

password change.

FNDCPASS was not able to decrypt password for user 'APPLSYS' during applsys

password change.

 

My GUEST password is fine.

SQL> select apps.fnd_web_sec.validate_login('GUEST','ORACLE') from dual;

APPS.FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
Y

 

I do not have a backup of fnd_user and fnd_oracle_userid table. But, I can copy these two table from our Prod again. But, will it help as autoconfig was run already ?

 

The autoconfig finishes successfully using Old APPS password. I can change password of Oracle DB account like GL etc using FNDCPASS. Even it does not give error message when running below :-

 

FNDCPASS apps/<OldPassword>123 0 Y system/***** ORACLE APPLSYSPUB PUB

 

 

The error is coming when I try to change APPS password.

 

Please Help. We are on 11.5.10.2 with 10.2.0.4 database.

 

Thanks,

Arindam Paul

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points