Issue:
FNDCPASS was not able
to decrypt password for user 'AUTOINSTALL' during applsys
password change.
FNDCPASS was not able
to decrypt password for user 'INDEX' during applsys
password change.
APP-FND-02704: Unable
to alter user APPS to change password
Solution:
alter role dba not identified;
alter role aq_administrator_role not identified;
alter role scheduler_admin not identified;
Retest the issue.
When i tried to change apps apsword with FNDCPASS.
ReplyDeleteFNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS
it generated log file:
log file have
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
module:
+---------------------------------------------------------------------------+
Current system time is 28-JUN-2017 21:57:46
+---------------------------------------------------------------------------+
Working...
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 28-JUN-2017 21:57:46
BUt when connected to sqlplus apps with new password not connted
saying
ERROR:
ORA-01017: invalid username/password; logon denied
able to connect old-apps password.
Recently we changed the GUEST passowrd to ORACLE1.
We try to change GUESt password to ORACLE but validate login shows N thats way we changed the GUEST password to ORACLE1.
After changed we got Y.
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N
Please see
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE1') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE1')
--------------------------------------------------------------------------------
Y
Please help on this.
FNDCPASS apps/ 0 Y system/ SYSTEM APPLSYS
ReplyDeleteHi Rajesh,
ReplyDeleteSory for the delay, hope the issue is resolved, however what is the procedure followed to change the guest password.