Oracle ORA-28002: the password will expire within 10 days

Oracle ORA-28002: the password will expire within 10 days solution:

1. query the perfile file of this user.

Select username, profile from dba_users where username = 'Scott ';

2. query values by file name

Select * from dba_profiles where profile = 'default ';

3. Change the password expiration time to password_life_time to unlimited.

Alter profile default limit password_life_time unlimited;

4. Password query complexity verification PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION

Alter profile default limit PASSWORD_VERIFY_FUNCTION NULL; (complexity verification is not used)

5. Change the password to the original password.

Alter user scott identified by tiger;

Modifying the default value above may affect others. We recommend that you create a perfile file and bind it to the user.