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

(0)
上一篇 2022年3月22日
下一篇 2022年3月22日

相关推荐