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.修改密码，密码修改后该用户可正常连接数据库。
ALTER USER 用户名 IDENTIFIED BY 密码 ;
长久对应可通过
execute following command to disable this feature:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
语句将口令有效期默认值180天修改成“无限制”。
