Resolve ORA-28002: Password expires 7 days after the method

Description of the phenomenon:
Landing Oracle 11g
Tip error:ora-28002:the Password would expire within 7 days

Alarm information:
error:ora-28002:the password would expire within 7 days

Reason Analysis:

The code is as follows	Copy Code
SELECT * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time '; oracle11g

"password_life_time=180 days " is set in default profile in the defaults. And 10g? Previous versions of Oracle remain silent??? nlimited

Solution:
1, view the user's proifle is that, is generally default:

The code is as follows	Copy Code
Sql>select username,profile from Dba_users where username= ' infdb ';

2. View password expiration settings for the specified profile (such as default):

The code is as follows	Copy Code
Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

3, the password will expire from the default 180 days to modify to "unrestricted":

The code is as follows	Copy Code
Sql>alter profile DEFAULT LIMIT Password_life_time Unlimited;

4, after the modification, has not been prompted to ORA-28002 warning users will not encounter the same hint;
The user who has been prompted must change the password again, for example:

code is as follows	copy code
$ Sqlplus/as SYSDBA     sql> alter user WAPGW identified by  < original password