1. Database Installation Guide
  2. Getting Started with Oracle Database
  3. Reviewing User Accounts and Passwords
  4. Unlocking and Resetting User Passwords
  5. Using SQL*Plus to Unlock and Change Passwords

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
  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;

See Also:

Parent topic: Unlocking and Resetting User Passwords