Oracle大频率密码错误登录导致数据库hang住

用户更改了业务用户密码，导致前端业务登录错误的密码，进而导致用户被锁。

SQL> select username,account_status from dba_users where username='PORTAL2';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
PORTAL2                        LOCKED

更改面策略，解除密码登录错误锁用户的限制

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

’SQL> select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD
UNLIMITED

但是登录用户还是会hang住

SQL> conn portal2/portal2
^CERROR:
ORA-01013: user requested cancel of current operation


Warning: You are no longer connected to ORACLE.

配置28041事件，实时生效，RAC的话2个节点都要执行

SQL> alter system set events='28401 trace name context forever, level 1'; 

System altered.

登录正常

SQL> conn portal2/portal2
Connected.
SQL> show user;
USER is "PORTAL2"