'2015/04'에 해당되는 글 1건

  1. 2015.04.16 오라클 lock 푸는 방법
2015. 4. 16. 15:58

오라클 lock 푸는 방법

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. All rights reserved.


C:\Users\imdsoho>sqlplus


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


Copyright (c) 1982, 2014, Oracle.  All rights reserved.


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


Copyright (c) 1982, 2014, Oracle.  All rights reserved.



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>