[Oracle] ORA-28000: the account is locked 해결방법

Database 2010.03.23 00:00 Posted by 파란크리스마스
- 출처

http://hyunayarn.tistory.com/9

- 오류 내용

- Lock 유저 확인 질의문

SELECT USERNAME,
        ACCOUNT_STATUS,
        TO_CHAR(LOCK_DATE,'YYYY.MM.DD HH24:MI') LOCK_DATE          
  FROM DBA_USERS
 WHERE USERNAME = 'SCOTT'

- 질의결과

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE      
------------------------------ -------------------------------- ----------------
SCOTT                          EXPIRED & LOCKED                 2010.03.22 23:45
1 row selected.

- Lock 해제

ALTER USER scott ACCOUNT UNLOCK;

- 확인1

SELECT USERNAME, ACCOUNT_STATUS
  FROM DBA_USERS
 WHERE USERNAME = 'SCOTT';

USERNAME                       ACCOUNT_STATUS                 
------------------------------ --------------------------------
SCOTT                          EXPIRED                        
1 row selected.

- 암호 설정

ALTER USER scott IDENTIFIED BY tiger;

- 확인2

SELECT USERNAME, ACCOUNT_STATUS
  FROM DBA_USERS
 WHERE USERNAME = 'SCOTT';

USERNAME                       ACCOUNT_STATUS                 
------------------------------ --------------------------------
SCOTT                          OPEN                           
1 row selected.
신고


 

티스토리 툴바