管理员登录:
connect sys/password@db_link as sysdba
查询登录密码错误的限制次数:
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
设置用户密码可以无限次尝试登录,该用户不会被锁定:
alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;
解锁用户:
ALTER USER *** ACCOUNT UNLOCK;