오라클 모든 계정 lock 걸렸을때 접속방법
#ORA-28000: The account is locked. 에러 해결
[oracle@9cfb72da0d22 ~]$ sqlplus "/as sysdba" //시스템 DBA 계정으로 들어감.
SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 9 08:59:21 2023
Version 19.9.1.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.1.0.0
SQL> set pagesize 20;
SQL> set linesize 200;
SQL> SELECT username, account_status, lock_date FROM dba_users; //내 계정 lock 걸린거 확인
USERNAME ACCOUNT_STATUS LOCK_DATE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- ---------
SYS OPEN
SYSTEM OPEN
XS$NULL EXPIRED & LOCKED 17-APR-19
OJVMSYS LOCKED 03-JAN-23
LBACSYS LOCKED 03-JAN-23
OUTLN LOCKED 03-JAN-23
SYS$UMF LOCKED 03-JAN-23
DBSNMP LOCKED 03-JAN-23
APPQOSSYS LOCKED 03-JAN-23
DBSFWUSER LOCKED 03-JAN-23
GGSYS LOCKED 03-JAN-23
ANONYMOUS EXPIRED & LOCKED 17-APR-19
CTXSYS EXPIRED & LOCKED 17-APR-19
DVSYS LOCKED 03-JAN-23
DVF LOCKED 03-JAN-23
GSMADMIN_INTERNAL LOCKED 03-JAN-23
MDSYS LOCKED 03-JAN-23
USERNAME ACCOUNT_STATUS LOCK_DATE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- ---------
OLAPSYS LOCKED 03-JAN-23
XDB LOCKED 03-JAN-23
WMSYS LOCKED 03-JAN-23
GSMCATUSER LOCKED 03-JAN-23
MDDATA LOCKED 03-JAN-23
SYSBACKUP LOCKED 03-JAN-23
REMOTE_SCHEDULER_AGENT LOCKED 03-JAN-23
SYSRAC LOCKED 03-JAN-23
GSMROOTUSER LOCKED 03-JAN-23 LOCKED 03-JAN-23
AUDSYS LOCKED 03-JAN-23
DIP LOCKED 17-APR-19
ORDPLUGINS LOCKED 03-JAN-23
SYSKM LOCKED 03-JAN-23
ORDDATA LOCKED 03-JAN-23
ORACLE_OCM LOCKED 03-JAN-23
SYSDG LOCKED 03-JAN-23
USERNAME ACCOUNT_STATUS LOCK_DATE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------- ---------
ORDSYS LOCKED 03-JAN-23
GSMUSER LOCKED 03-JAN-23 OPEN
PDIDSVD LOCKED(TIMED) 09-MAY-23
39 rows selected.
SQL> ALTER USER PDIDSVD ACCOUNT UNLOCK; //lock 풀기 PDIDSVD 는 계정명
User altered.
SQL> COMMIT;
Commit complete.
레거시문서를 줄이자. 계속 업데이트해서 최신화한다.