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

1. Start SQL*Plus:

   Copy

   C:\> sqlplus /nolog

    
2. Connect as SYSDBA:

   Copy

   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:

   Copy

   SQL> ALTER USER account IDENTIFIED BY password ACCOUNT UNLOCK;