Caused by: java.sql.SQLException: ORA-28001: the password has expired_ [Sanitized]

Caused by: java.sql.SQLException: ORA-28001: the password has expired_ [Sanitized]

今天在运行eclipse的时候出现如下错误

Caused by: java.sql.SQLException: ORA-28001: the password has expired_ [Sanitized]

此错误是因为oracle的密码过期时间被设置为了180天,或其他数字

因此我们可以做如下操作

1,登录:sqlplus / as sysdba

2,查看:select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

我们可以看到密码过期时间是180天

3,设置不过期:alter profile default  limit password_life_time unlimited;

4,最后需要重新设置下密码即可,否则不会生效

alter user users identified by pwd;


如果您觉得本文章对您有用,也为了更好的运营博客,您可以点击这里捐助

评论 抢沙发

昵称 (必填) 邮箱 (必填)
表情