Using SQL*Plus to Unlock Accounts and Reset Passwords
Using SQL*Plus to Unlock Accounts and Reset Passwords
Use this SQL*Plus procedure to unlock and reset user account passwords.
Start SQL*Plus and log in as the SYS user, connecting as SYSDBA:
$ $ORACLE_HOME/bin/sqlplus
SQL> CONNECT SYS as SYSDBA
Enter password: sys_password
Enter the command ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK; to unlock an account.
Note:
If you unlock an account but do not reset the password, then the password remains expired. The first time someone connects as that user, they must change the user's password.