1、问题描述:ORA-28001: the password has expired
查看日志:apusic日志 数据库alert日志2、处理:
conn username/password 输入新密码alter user username identity by password
3、查看数据库用户的过期日期,现在的状态select username,account_status,lock_date from dba_users; 4、Oracle 11G创建用户时缺省密码过期限制是180天长期有效:ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED