连接ORACLE 提示 ：the account is locked

[ERROR] (druid.pool.DruidDataSource:2336).run:create connection SQLException, url: jdbc:oracle:thin:@***.***.***.***:1521:orcl, errorCode 28000, state 99999
java.sql.SQLException: ORA-28000: the account is locked

 由于oracle密码修改，代码中忘记同步了，密码错误一直重连，导致oracle将账号锁定了。

 

解决办法如下：

[root@iZm5eigq28rm3rfagwqmfqZ ~]# su - oracle    #切换到oracle用户

[oracle@iZm5eigq28rm3rfagwqmfqZ ~]$ sqlplus /nolog  #sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 9 09:36:20 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

SQL> conn /  as sysdba   #  dba 登录

Connected.

SQL> alter user 用户名 account unlock;   #解锁

User altered.

修改后即可重新链接