Oracle prompt error message ORA-28001: the password has expired

Oracle error message ORA-28001: the password has expired,

According to the survey, the new features of Oracle 11G are caused. The default password expiration limit for Oracle 11G users is 180 days. If the user password is not modified for more than 180 days, the user cannot log on.

Available

SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME'

Statement to query the password's validity period settings,

The LIMIT field indicates the password validity period. You can use

Alter user Username identified by password;

Statement to modify the password. After the password is changed, the user can connect to the database normally.

Long-term correspondence can be passed

Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED

Statement to change the password validity period from 180 days to "unlimited ". For database security considerations, it is not recommended to set the PASSWORD_LIFE_TIME value to UNLIMITED,

We recommend that you modify the database user password periodically.