How to reset the same password for oracle user.

To reset Expiry users password,In which password was unknow by DBA and in application it was encrypted.

In that case find the password from user$ table then set the same for the user.

Eg:

SQL> select name,password from user$ where name='SCOTT';

NAME PASSWORD
------------------------------ ------------------------------
SCOTT DF894844C3ERGV440210B67

SQL> ALTER USER SCOTT IDENTIFIED BY VALUES 'ECF0B513DC97E15D' account unlock;