Oracle ORA-28001:the password has expired
Oracle ORA-28001: the password has expired
1.检查
select * from dba_profiles where profile=’DEFAULT’ and resource_name=’PASSWORD_LIFE_TIME’;
结果显示密码有效期是180天
2.修改密码有效期:
alter profile default limit password_life_time unlimited;
commit;
3.改变密码的命令
ALTER USER 用户名 IDENTIFIED BY 密码 ;
如果账号被锁住,则需要解锁命令
alter user ******* identified by oracle account unlock;
再次调试,问题解决
-- 刘轶鹤