공간사랑

ORA-28000: the account is locked
Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
 
Action: Wait for PASSWORD_LOCK_TIME or contact DBA

# sqlplus /nolog

SQL> connect /as sysdba
Connected.

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
USER1                          LOCKED(TIMED)
HR                             EXPIRED & LOCKED
SH                             EXPIRED & LOCKED
SCOTT                          EXPIRED & LOCKED
SYS                            OPEN
SYSTEM                         OPEN
:
:
:

SQL> alter user 유저이름 account unlock;

User altered.

SQL>

패스워드 LOCK횟수 확인하기

#> sqlplus "/as sysdab" --system계정으로 로그인
...
SQL> SELECT U.USERNAME,P.PROFILE, P.RESOURCE_NAME, P.LIMIT
         FROM DBA_USERS U, DBA_PROFILES P WHERE P.PROFILE=U.PROFILE
         AND RESOURCE_NAME='FAILED_LOGIN_ATTEMPTS';
 ...

추가 RESOURCE_NAME 관련