Hi DBA's,
Today, I faced below ORA error, when trying to reset password.
All PDB users are assigned to a profile from CDB, which is pointing to password verify function from CDB.
When tried to reset any PDB user on 2-node RAC database, getting below error.
alter user SCOTT identified by "b9@Sv9$C&#[[CA8J"
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-01422: exact fetch returns more than requested number of rows
Same profile and verify function is working fine on RAC-ONE 19c database.
Is there any profile and verify function restrictions on RAC databases, particularly from CDB to PDB's? Because same verify function is working when used from PDB.