How to Unlock an Expired Oracle User Whose Password is Unknown

 

In my previous article, I mentioned how to solve Oracle Password Expired Error (ORA-28001). In some cases, we must unlock user with the existing password. I will show you how to unlock an expired user which you do not know user’s existing password.

Let’s list expired users.

 

We can list “user$” view for users’ passwords. spare4 column shows the encrypted password.

 

We can unlock “ocinar” user with its existing encrypted password.

 

Now, “OCINAR” is active and can connect database again with its original password.

Onur Çınar
Author: Onur Çınar

2 comments

  1. alter user user_name identified by new_pass;

  2. thank you by Onur Çınar

Leave a Reply

Your email address will not be published. Required fields are marked *