ORACLE11g错误密码登录10次将被锁定

ORACLE11g错误密码登录10次将被锁定&＃xff0c;测试如下&＃xff1a;

SQL> set time on;
15:32:18 SQL> conn gxgat/password
Connected.
15:32:29 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon deniedWarning: You are no longer connected to ORACLE.
15:32:42 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:32:48 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:32:57 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:06 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:11 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:17 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:27 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:38 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:50 SQL> conn gxgat/p
ERROR:
ORA-01017: invalid username/password; logon denied15:33:59 SQL> conn gxgat/p
ERROR:
ORA-28000: the account is locked

解锁&＃xff1a;

先退出&＃xff0c;以sysdba进行登录&＃xff0c;执行unlock命令即可。

[oracle&＃64;test11g ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 20 15:39:53 2018Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter user gxgat account unlock;User altered.SQL> conn gxgat/password
Connected.

查看默认错误连接次数锁定&＃xff1a;

SQL> set linesize 300
SQL> select * from dba_profiles where resource_name like &＃39;FAILED_LOGIN_ATTEMPTS%&＃39;;PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
MONITORING_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITEDSQL>

修改默认的错误登录次数&＃xff0c;为不限制

SQL> alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED;


查看被锁的用户

15:51:48 SQL> select LOCK_DATE,username from dba_users where username&＃61;&＃39;GXGAT&＃39;;LOCK_DATE USERNAME
--------- ------------------------------
20-DEC-18 GXGAT


LOCK_DATE为空说明没有锁定&＃xff0c;非空为锁定。

或者

SELECT S.USERNAME,DECODE(L.TYPE, &＃39;TM&＃39;, &＃39;TABLE LOCK&＃39;, &＃39;TX&＃39;, &＃39;ROW LOCK&＃39;, NULL) LOCK_LEVEL,O.OWNER,O.OBJECT_NAME,O.OBJECT_TYPE,S.SID,S.SERIAL#,S.TERMINAL,S.MACHINE,S.PROGRAM,S.OSUSERFROM V$SESSION S, V$LOCK L, DBA_OBJECTS O
WHERE S.SID &＃61; L.SIDAND O.OBJECT_ID &＃61; L.ID1AND S.USERNAME IS NOT NULL;