Mostly there are 2 ways by we can Lock/Unlock the Oracle user Account.
1. By using GUI InterFace
=> Then Provide the user Id & Password
2. By using CUI InterFace(Command Line)
Below 2 statements will help you to lock or unlock Oracle database user accounts. SQL> ALTER USER username ACCOUNT LOCK; SQL> ALTER USER username ACCOUNT UNLOCK;