//lock_date是被锁住时间,如果为空证明这个用户没有被锁住
select username,lock_date from dba_users where username='GFMIS';
//查看Oracle数据库默认允许重复连接多少次,默认是10次
select * from dba_profiles WHERE resource_name = '
FAILED_LOGIN_ATTEMPTS' AND PROFILE = '
DEFAULT';
//修改
Oracle数据库默认连接数为100个用户
alter
profile default limit
FAILED_LOGIN_ATTEMPTS
100;
//设置无限制
alter profile DEFAULT limit
FAILED_LOGIN_ATTEMPTS UNLIMITED;
//给用户解锁
ALTER USER gfmis ACCOUNT UNLOCK;