Oracle에서 사용자Lock풀기

소개

Oracle에서 Lock걸린 사용자 해제 절차

작업 절차

1. Oracle에서 사용자 정보 확인

   SQL> select username,account_status from dba_users;
   USERNAME                       ACCOUNT_STATUS---
   
   EXFSYS                         EXPIRED & LOCKED
   DMSYS                          EXPIRED & LOCKED
   WMSYS                          EXPIRED & LOCKED
   XDB                            EXPIRED & LOCKED
   ORDPLUGINS                     EXPIRED & LOCKED
   SI_INFORMTN_SCHEMA             EXPIRED & LOCKED
   OLAPSYS                        EXPIRED & LOCKED
   MDDATA                         EXPIRED & LOCKED
   DIP                            EXPIRED & LOCKED
   SCOTT                          EXPIRED & LOCKED
   TSMSYS                         EXPIRED & LOCKED
   TEST                           LOCKED
   

2. lock된 test계정정보 수정

   SQL> alter user test account unlock;
   

3. unlock 정보 확인

   SQL> select username,account_status from dba_users;
   USERNAME                       ACCOUNT_STATUS---
   
   MGMT_VIEW                      OPEN
   SYS                            OPEN
   SYSTEM                         OPEN
   DBSNMP                         OPEN
   SYSMAN                         OPEN
   TEST                           OPEN
   SCOTT                          EXPIRED
   OUTLN                          EXPIRED & LOCKED
   MDSYS                          EXPIRED & LOCKED
   ORDSYS                         EXPIRED & LOCKED
   CTXSYS                         EXPIRED & LOCKED
   

   ```
4. 계정 패스워드 설정

   SQL> ALTER USER test IDENTIFIED BY testuser!!!!;
   

   ```

작성일: 2026년 7월 15일 ,  마지막 업데이트: 2026년 7월 15일