ORA-28002 Oracle 11g Existing password expiration solution _oracle

Failure Phenomenon
Oracle 11g Database Common user logon prompt ora-28002:the password'll expire within 7 days
[11:01:00oracle@dvd db_1] $sqlplus wang/oracle
Sql*plus:release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ora-28002:the password would expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production
With the OLAP and Data Mining options
Wang@sun>

cause of failure
Oracle 11G Ordinary users have a 180-day default password cycle, which will appear when the expiration of the prompt;

Solutions
View current user profile, corresponding password cycle
SELECT * from Dba_profiles where profile= ' DEFAULT ' and resource_name= ' password_life_time ';
Alter profile default limit Password_life_time unlimited;
SELECT username,profile from dba_users where username like Upper (' &user ');
Sys@sun> SELECT username,profile from dba_users where username like Upper (' &user ');
Enter value for User:wang
Old 1:select username,profile from dba_users where username like Upper (' &user ')
New 1:select username,profile from dba_users where username like Upper (' Wang ')
USERNAME profile
------------------------------ ------------------------------
WANG DEFAULT
--Query to the user's profile for DEFAULT
Sys@sun> Set Lines 222
Sys@sun> Col profile for A20
Sys@sun> Col resource_name for A20
Sys@sun> Col Resource_type for A20
Sys@sun> Col LIMIT for A20
Sys@sun> SELECT * from Dba_profiles where profile= ' DEFAULT ' and resource_name= ' password_life_time ';
Profile Resource_name Resource_type LIMIT
-------------------- -------------------- -------------------- --------------------
DEFAULT Password_life_time PASSWORD 180
--Query to the profile for the password life cycle is configured to 180 days
Modify the current user profile corresponding to the corresponding password cycle
sys@sun> alter profile default limit Password_life_time 365;
Profile altered.
--Modify the profile's password lifecycle configuration to 365 days
sys@sun> alter profile default limit Password_life_time unlimited;
Profile altered.
--Change the password lifecycle for this profile to be unlimited