Trying to reset to the existing password throws following error.

ERROR at line 1:
ORA-28007: the password cannot be reused


Check the user profile set for the user. Check for the existence of a password verify function in the profile.

Set the password_verify_function to NULL

Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If so set to a higher value or to UNLIMITED and reset the password as shown below.

SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited;

SQL> alter user USERNAME identified by <PREV_PWD>

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn:

Anuradha’s LinkedIn:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.