ORA-28001 the password has expired
Oracle11G的新特性, Oracle11G创建用户时缺省密码过期限制是180天, 如果超过180天用户密码未做修改则该用户无法登录。
用sqlplus登录sysdba
sqlplus connect as sysdba
然后输入原密码
查看密码有效期设置:
SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
修改密码:
alter user username identified by "password";
username 用用户名替换
password 用新密码替换,注意冒号需要保留
去除180天限制:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ORA-28000: the account is locked
sqlplus登陆sysdba后,执行
ALTER USER username ACCOUNT UNLOCK;
username 用账户名替换