How to unlock Oracle user account?

Here's how to lock or unlock Oracle database user accounts.

SQL> ALTER USER username ACCOUNT LOCK;

SQL> ALTER USER username ACCOUNT UNLOCK;

To unlock a user Run the following sql as administrator user like SYS or SYSTEM

ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;

here password is your passord which you want to use for your account remember this password for further use.

amarildo

amarildo1

amarildo2

Thanks for sharing such command .
in this form , i would like to share a command to create Oracle account & change password
create account : CREATE USER <account-name>IDENTIFIED BY <account-password> password expire DEFAULT TABLESPACE <table-space name> TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON <table-space name> PROFILE PERSONAL;
change account password : alter user <account-name> identified by "<accountpassword>"