Use this SQL*Plus procedure to unlock and reset user account passwords.
To change a password after installation:
- Start SQL*Plus:
- 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;