ORACLE11G R2 database hint ora-28002:the password will expire within 5 days, is that the password expires, the Oracle password is set to never expire, but it is not recommended to do so, It is best to set the date password validity period longer.
Tools/Materials
Method/Step
Sqldeveloper Connection Database Hints
Ora-28002:the password'll expire within 5 days
Log in to Sqlplus
Sqlplus/as SYSDBA
To see how long your password is valid
SELECT * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';
Set the password to never expire
Sql> ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;
Modify User Password
sql> alter user joffice identified by Joffice;
After you modify the user password and log in again, you will find that the hint is gone. But small series again remind, this is just a solution, generate database best or regular change password, security first AH.
ora-28002 the password would expire solution