How to unlock oracle user on 18c database ?

Question : How to unlock oracle user on 18c database ?

Answer :

Step-1:Use below query to get user account details

SQL>  select USERNAME,ACCOUNT_STATUS from dba_users where username='ABCD_DEV';

USERNAME             ACCOUNT_STATUS
-------------------- --------------------------------
ABCD_DEV       LOCKED(TIMED)

Step-2 Use this query user account unlock

SQL> alter user ABCD_DEV account unlock;

User altered.

Step-3 Check user account status using below query

SQL> select USERNAME,ACCOUNT_STATUS from dba_users where username='ABCD_DEV';

USERNAME             ACCOUNT_STATUS
-------------------- --------------------------------
ABCD_DEV       OPEN