FAILED_LOGIN_ATTEMPTS

FAILED_LOGIN_ATTEMPTS

SQL> conn / as sysdba;
Connected.
SQL> alter user JTITSM account unlock;
User altered.
SQL> conn JTITSM/JTITSM
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba;
Connected.
SQL> alter user JTITSM account unlock;

User altered.

SQL> conn JTITSM/JTITSM
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL>
SQL> conn / as sysdba;
Connected.
SQL> select username,account_status from dba_users where username='JTITSM';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
JTITSM                         LOCKED(TIMED)

SQL> select profile
  2  from dba_users
where username = 'JTITSM';  3 

PROFILE
------------------------------
DEFAULT

SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
COMPOSITE_LIMIT                  KERNEL
UNLIMITED

SESSIONS_PER_USER                KERNEL
UNLIMITED

CPU_PER_SESSION                  KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
CPU_PER_CALL                     KERNEL
UNLIMITED

LOGICAL_READS_PER_SESSION        KERNEL
UNLIMITED

LOGICAL_READS_PER_CALL           KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
IDLE_TIME                        KERNEL
UNLIMITED

CONNECT_TIME                     KERNEL
UNLIMITED

PRIVATE_SGA                      KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
FAILED_LOGIN_ATTEMPTS            PASSWORD
10
SQL> SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 100000；
  2 
SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 100000;

Profile altered.

SQL> SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT';

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
COMPOSITE_LIMIT                  KERNEL
UNLIMITED

SESSIONS_PER_USER                KERNEL
UNLIMITED

CPU_PER_SESSION                  KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
CPU_PER_CALL                     KERNEL
UNLIMITED

LOGICAL_READS_PER_SESSION        KERNEL
UNLIMITED

LOGICAL_READS_PER_CALL           KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
IDLE_TIME                        KERNEL
UNLIMITED

CONNECT_TIME                     KERNEL
UNLIMITED

PRIVATE_SGA                      KERNEL
UNLIMITED

RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
----------------------------------------
FAILED_LOGIN_ATTEMPTS            PASSWORD
100000
SQL>  select resource_name, limit from dba_profiles where resource_name = 'FAILED_LOGIN_ATTEMPTS';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS            100000
FAILED_LOGIN_ATTEMPTS            DEFAULT

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

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
PROFILE
------------------------------
JTITSM                         OPEN
DEFAULT