티스토리 뷰

Database

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

파란크리스마스 2010. 3. 23. 00:00
728x90
- 출처

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.
댓글
300x250
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/03   »
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
글 보관함