ORA-28002 Oracle 11g存在密码过期问题解决方案

故障现象
oracle database 11g 数据库普通用户登录时提示 ora-28002: the password will 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 will 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>

故障原因
oracle 11g 普通用户有个180天的缺省密码周期，当快过期的时候即会出现此提示；

解决办法
查看当前用户对应profile、对应密码周期
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
--查询到该用户对应的profile文件为 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
--查询到该profile对应的密码生命周期配置为180天
修改当前用户对应profile对应对应密码周期
sys@sun> alter profile default limit password_life_time 365;
profile altered.
--修改该profile对应的密码生命周期配置为365天
sys@sun> alter profile default limit password_life_time unlimited;
profile altered.
--修改该profile对应的密码生命周期配置为 无限制