After Cloning Running FNDCPASS and AFPASSWD When Attempting to Change APPS/APPLSYS and Sysadmin Users Passwords Generates PASSWORD VERIFICATION FOR APPS Error
(Doc ID 2433710.1)
Last updated on DECEMBER 22, 2023
Applies to:
Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Basic SysAdmin functions, maintenance
After cloning environment, run FNDCPASS to reset APPS/APPLSYS and Sysadmin Users Passwords are Failing.
Patch 19127427 is applied in environment.
FNDCPASS apps/apps_passwd 0 Y system/system_passwd SYSTEM APPLSYS new_passwd
The following error appears:
ERROR IN PASSWORD VERIFICATION FOR APPS
Instead of FNDCPASS, use AFPASSWD.
AFPASSWD generates the error below:
AFPASSWD -f SYSADMIN
Enter the ORACLE password of Application Object Library 'APPSUSER':
Enter the ORACLE password of Application Object Library 'APPSUSER':
Connected successfully to APPS.
Log file: <log file name>.log
Enter new password for user [SYSADMIN]:
Verify new password for user [SYSADMIN]:
+----------------------------------------------------------------------------+
Application Object Library - AFPASSWD
+----------------------------------------------------------------------------+
Copyright (c) 2006, Oracle. All rights reserved.
+----------------------------------------------------------------------------+
Current system time is 08-AUG-18 23:21:00
+----------------------------------------------------------------------------+
Working...
This password is not managed by Oracle Applications so it can not be changed here.
Unable to change the password for fnd_user SYSADMIN.
AFPASSWD completed with errors.
+----------------------------------------------------------------------------+
Current system time is 08-AUG-18 23:21:25
+----------------------------------------------------------------------------+
_____________________________________________
Unable to change Sysadmin user password.
Receive error below:
FNDCPASS apps/pwd 0 Y system/pwd USER sysadmin pwd
Current system time is 25-JUN-2012 01:42:24
+---------------------------------------------------------------------------+
APP-FND-01564: ORACLE error 6502 in changepassword
Cause: changepassword failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_WEB_SEC", line 1372
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was: begin :r := fnd_web_sec.change_password(:u,:p); end; and was executed from the file &ERRFILE.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |