How to quickly unlock expired Oracle database users

This post is a self note on unlocking an expired oracle database user.

OS: window

1. Open command prompt, and execute the following command

sqlplus sys/[PASSWORD] @ [SID] as sysdba

2. View expired users with the following command

Select username, account_status from dba_users where account_status like 'EXPIRED';

3. Activate user with the following command

Alter user [USERNAME] identified by [PASSWORD];

Done!!