用户账户锁定问题

1.问题现象:

2.查看出错用户状态
服务器[localhost:5236]:处于普通打开状态
登录使用时间 : 4.677(ms)
disql V8

sql> select a.USERNAME,a.ACCOUNT_STATUS ,a.DEFAULT_TABLESPACE ,a.CREATED from dba_users a ;

USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE CREATED

SYSAUDITOR OPEN SYSTEM 2023-03-09 14:14:52.679235
SCUSER OPEN SCUSERTSP 2023-03-14 13:37:28.008432
SYSSSO OPEN SYSTEM 2023-03-09 14:14:52.679235
SCOTT LOCKED SCOTT 2023-03-13 10:44:51.095076
YL OPEN ylts 2023-03-13 10:38:24.849811
SYSDBA OPEN MAIN 2023-03-09 14:14:52.679235
APP OPEN MAIN 2023-03-09 08:32:10.861846
AAA OPEN MAIN 2023-03-09 18:19:59.466774
A OPEN MAIN 2023-03-21 03:28:27.062375
B OPEN MAIN 2023-03-21 03:28:27.689489
SYS OPEN SYSTEM 2023-03-09 14:14:52.679235

3.解锁相应用户
alter user scott ACCOUNT UNLOCK ;

4.验证用户登录是否正常

5.分析用户资源限制