故障现象
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对应的密码生命周期配置为 无限制