(1) conn sys/oracle as sysdba
(2)select username,account_status from dba_users where username='xxx';,查看到用户锁了
(3)解锁xxx用户,SQL> alter user xxx account unlock;
(4)查看用户限制登陆次数select * from dba_profiles where RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';
(5)alter profile default limit failed_login_attempts unlimited;修改用户无论输入多少次都不会被锁定
————————————————
版权声明:本文为CSDN博主「咫尺的梦想ing」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/u013050593/java/article/details/78809736