오라클 사용자 LOCK 풀기 암호만료 해결하기(ORA-28000)

 락 유저 조회(EXPIRED & LOCKED)

--EXPIRED & LOCKED 유저 조회
SELECT USERNAME,
       USER_ID,
       PASSWORD,
       ACCOUNT_STATUS,
       LOCK_DATE,
       EXPIRY_DATE,
       DEFAULT_TABLESPACE,
       TEMPORARY_TABLESPACE,
       CREATED,
       PROFILE,
       INITIAL_RSRC_CONSUMER_GROUP,
       EXTERNAL_NAME,
       PASSWORD_VERSIONS,
       EDITIONS_ENABLED,
       AUTHENTICATION_TYPE
FROM   DBA_USERS
WHERE  USERNAME='FLOWS_FILES'

 조회 결과

USERNAME   |USER_ID|PASSWORD|ACCOUNT_STATUS  |LOCK_DATE          |EXPIRY_DATE        |DEFAULT_TABLESPACE|TEMPORARY_TABLESPACE|CREATED            |PROFILE|INITIAL_RSRC_CONSUMER_GROUP|EXTERNAL_NAME|PASSWORD_VERSIONS|EDITIONS_ENABLED|AUTHENTICATION_TYPE|
-----------|-------|--------|----------------|-------------------|-------------------|------------------|--------------------|-------------------|-------|---------------------------|-------------|-----------------|----------------|-------------------|
FLOWS_FILES|     75|        |EXPIRED & LOCKED|2010-04-02 14:19:33|2010-04-02 14:19:33|SYSAUX            |TEMP                |2010-04-02 13:57:16|DEFAULT|DEFAULT_CONSUMER_GROUP     |             |10G 11G          |N               |PASSWORD           |

 

 

 락 유저 UNLOCK

--LOCKED 유저 UNLOCK
ALTER USER FLOWS_FILES ACCOUNT UNLOCK;

--LOCKED 유저 상태결과 확인
SELECT USERNAME,
       USER_ID,
       PASSWORD,
       ACCOUNT_STATUS,
       LOCK_DATE,
       EXPIRY_DATE,
       DEFAULT_TABLESPACE,
       TEMPORARY_TABLESPACE,
       CREATED,
       PROFILE,
       INITIAL_RSRC_CONSUMER_GROUP,
       EXTERNAL_NAME,
       PASSWORD_VERSIONS,
       EDITIONS_ENABLED,
       AUTHENTICATION_TYPE
FROM   DBA_USERS
WHERE  USERNAME='FLOWS_FILES'

 조회 결과

USERNAME   |USER_ID|PASSWORD|ACCOUNT_STATUS|LOCK_DATE|EXPIRY_DATE        |DEFAULT_TABLESPACE|TEMPORARY_TABLESPACE|CREATED            |PROFILE|INITIAL_RSRC_CONSUMER_GROUP|EXTERNAL_NAME|PASSWORD_VERSIONS|EDITIONS_ENABLED|AUTHENTICATION_TYPE|
-----------|-------|--------|--------------|---------|-------------------|------------------|--------------------|-------------------|-------|---------------------------|-------------|-----------------|----------------|-------------------|
FLOWS_FILES|     75|        |EXPIRED       |         |2010-04-02 14:19:33|SYSAUX            |TEMP                |2010-04-02 13:57:16|DEFAULT|DEFAULT_CONSUMER_GROUP     |             |10G 11G          |N               |PASSWORD           |

 

 

 PASSWORD EXPIRED 해제

--PASSWORD EXPIRED 해제 
ALTER USER FLOWS_FILES IDENTIFIED BY 바꿀암호;

--LOCKED 유저 상태결과 확인
SELECT USERNAME,
       USER_ID,
       PASSWORD,
       ACCOUNT_STATUS,
       LOCK_DATE,
       EXPIRY_DATE,
       DEFAULT_TABLESPACE,
       TEMPORARY_TABLESPACE,
       CREATED,
       PROFILE,
       INITIAL_RSRC_CONSUMER_GROUP,
       EXTERNAL_NAME,
       PASSWORD_VERSIONS,
       EDITIONS_ENABLED,
       AUTHENTICATION_TYPE
FROM   DBA_USERS
WHERE  USERNAME='FLOWS_FILES'

 조회 결과

USERNAME   |USER_ID|PASSWORD|ACCOUNT_STATUS|LOCK_DATE|EXPIRY_DATE        |DEFAULT_TABLESPACE|TEMPORARY_TABLESPACE|CREATED            |PROFILE|INITIAL_RSRC_CONSUMER_GROUP|EXTERNAL_NAME|PASSWORD_VERSIONS|EDITIONS_ENABLED|AUTHENTICATION_TYPE|
-----------|-------|--------|--------------|---------|-------------------|------------------|--------------------|-------------------|-------|---------------------------|-------------|-----------------|----------------|-------------------|
FLOWS_FILES|     75|        |OPEN          |         |2020-07-11 15:11:39|SYSAUX            |TEMP                |2010-04-02 13:57:16|DEFAULT|DEFAULT_CONSUMER_GROUP     |             |10G 11G          |N               |PASSWORD           |