오라클 lock 푸는 방법

단순대왕 2015. 4. 16. 15:58

Microsoft Windows [Version 6.1.7601]

C:\Users\imdsoho>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on 목 4월 16 15:47:18 2015

Enter user-name: imdsoho

Enter password:

ERROR:

ORA-28000: the account is locked

Enter user-name: ^C

C:\Users\imdsoho>

C:\Users\imdsoho>sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on 목 4월 16 15:47:51 2015

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> conn sys/***password***@1.232.45.19 as sysdba

Connected.

SQL> show user;

USER is "SYS"

SQL> select username, account_status, profile from dba_users;

USERNAME ACCOUNT_STATUS PROFILE

----------------------------------------------------------------------

XS$NULL EXPIRED & LOCKED DEFAULT

APPQOSSYS EXPIRED & LOCKED DEFAULT

ORACLE_OCM EXPIRED & LOCKED DEFAULT

XDB EXPIRED & LOCKED DEFAULT

HR EXPIRED & LOCKED DEFAULT

DBSNMP EXPIRED & LOCKED DEFAULT

DIP EXPIRED & LOCKED DEFAULT

OUTLN EXPIRED & LOCKED DEFAULT

CTXSYS EXPIRED & LOCKED DEFAULT

MDSYS EXPIRED & LOCKED DEFAULT

APEX_040000 LOCKED DEFAULT

APEX_PUBLIC_USER LOCKED DEFAULT

FLOWS_FILES LOCKED DEFAULT

IMDSOHO LOCKED(TIMED) DEFAULT

SYSTEM OPEN DEFAULT

SYS OPEN DEFAULT

ANONYMOUS OPEN DEFAULT

17 rows selected.

SQL> alter user imdsoho account unlock;

User altered.

SQL>