分类：oracle

Oracle提示错误消息ORA-28001: the password has expired,

Reason:

In Oracle Database, A remote DBA face this because password have reached 180 Default limit for Password life time.

The life of a password is defined as 180 days by default. DBA has to change this limit to unlimited to solve this and to avid this in future.

Before getting this error DBA will also see ORA-28002: the password will expire within n days I would suggest to change password before it expires. 

 

Oracle 11G的新特性所致， Oracle 11G创建用户时缺省密码过期限制是180天， 如果超过180天用户密码未做修改则该用户无法登录。

1.用sys dba登陆

2.查询密码的有效期设置，

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

LIMIT字段是密码有效天数。在密码将要过期或已经过期时可通过

3.修改密码，密码修改后该用户可正常连接数据库。

继续阅读“Oracle 错误消息ORA-28001: the password has expired 密码过期”