Fixing APPS/APPLSYS passwords after manually changing them in DB
Oracle Database 19c
Oracle E-Business Suite 12.2.14
TEST ENVIRONMENT
Hello community,
as a new database admin, I messed up with password management for EBS related users. So I run below commands on database node:
alter user APPS identified by <password>;
alter user APPLSYS identified by <same_password>;
During run of adadmin (trying to install new language to database) I noticed that APPS password is not going through, despite making absolute sure that it's correct.
I learned that I most likely desynchronized/corrupted passowrd hashes in FND_USERS table, and now I'm looking for any way not requiring backup (junior DBA) to make those passwords work again.