Oracle error message ORA-28001: thepasswordhasexpired, the investigation is caused by new features of Oracle11G, Oracle11G when creating a user default password too
Oracle error message ORA-28001: the password has expired, investigated due to new features of Oracle 11G, Oracle 11G when creating a user default password too
Oracle error message ORA-28001: the password has expired,
According to the investigation, 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.