Inicie o SQL*Plus:
sqlplus /NOLOG
Connect como SYSDBA:
SQL> CONNECT / AS SYSDBA
ALTER USER username ACCOUNT UNLOCK;
ALTER USER username ACCOUNT LOCK;
ALTER USER username IDENTIFIED BY password;
ALTER USER username IDENTIFIED BY password ACCOUNT UNLOCK;
