SQL/ORACLE
the account is locked
nineDeveloper
2014. 2. 13. 10:23
728x90
반응형
1. 운영체제의 oracle 계정으로 접속
sqlplus "/ as sysdba"
2. 계정의 lock 정보를 확인
select username,
account_status,
to_char(lock_date,'yy/mm/dd hh24:mi')
lock_date,profile
from dba_users
where username = 'SYSTEM'; --> Lock된 유저명
3. account_status 가 LOCKED 이면
USERNAME ACCOUNT_STATUS LOCK_DATE PROFILE
---------------------------------------------------------------------
SYSTEM LOCKED 06-05-12 DEFAULT
4. alter user system account unlock;
728x90
반응형