오라클 계정 lock 해제

1. sysdba로 접속

[oracle@spgems ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 27 16:54:45 2011

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

SQL> conn /as sysdba
Connected.

2. Lock 걸린 User 조회
SQL> select username, account_status, lock_date from dba_users;

3. Lock 걸린 User lock 해제
SQL> alter user hr account unlock identified by hr;