Using SQL*Plus to Unlock and Change Passwords

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

To change a password after installation:

1. Start SQL*Plus:

C:\> sqlplus /nolog

Connect as SYSDBA:

SQL> CONNECT SYS AS SYSDBA
Enter password: SYS_password 

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;