快捷導(dǎo)航

ORA-28002 Oracle 11g存在密碼過(guò)期問(wèn)題解決方案

更新時(shí)間：2012年11月27日 14:56:04 作者：

oracle數(shù)據(jù)庫(kù)使用中會(huì)遇到ORA-28002 Oracle 11g存在密碼過(guò)期問(wèn)題,本文將提供詳細(xì)的解決方案，需要的朋友可以參考下

故障現(xiàn)象
Oracle Database 11g 數(shù)據(jù)庫(kù)普通用戶(hù)登錄時(shí)提示 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 普通用戶(hù)有個(gè)180天的缺省密碼周期，當(dāng)快過(guò)期的時(shí)候即會(huì)出現(xiàn)此提示；

解決辦法
查看當(dāng)前用戶(hù)對(duì)應(yīng)profile、對(duì)應(yīng)密碼周期
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
--查詢(xún)到該用戶(hù)對(duì)應(yīng)的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
--查詢(xún)到該profile對(duì)應(yīng)的密碼生命周期配置為180天
修改當(dāng)前用戶(hù)對(duì)應(yīng)profile對(duì)應(yīng)對(duì)應(yīng)密碼周期
sys@SUN> alter profile default limit password_life_time 365;
Profile altered.
--修改該profile對(duì)應(yīng)的密碼生命周期配置為365天
sys@SUN> alter profile default limit password_life_time unlimited;
Profile altered.
--修改該profile對(duì)應(yīng)的密碼生命周期配置為無(wú)限制

您可能感興趣的文章: