Use this SQL*Plus procedure to unlock and reset user account passwords.

1. Start SQL*Plus:

   C:\> sqlplus /nolog
   

2. Connect as SYSDBA:

   SQL> CONNECT SYS AS SYSDBA
   Enter password: SYS_password 
   

3. Enter a command similar to the following, where account is the user account to unlock and password is the new password:

   SQL> ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK;