Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Unable to reset PDB user password on a 2-node RAC 19c database.

Chaitanya BoppaMar 25 2022

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.

Comments
Post Details
Added on Mar 25 2022
3 comments
222 views