Some time, Oracle beginners used HR sample schema and its database for practice and after the fresh installation of Oracle 11gR2, HR account is locked and they are not able to log in with HR account.
When try to log in with HR account, it ask for password and if they use some sample password like HR for HR account, it will show error that account is locked.

We can login with oracle system’s User and login with sys as sysdba t unlock HR account, this alter query can be used to unlock HR account.

HR_first_time_error

alter user hr identified by hr account unlock;

In this alter query will set HR user password (HR) and unlock that as well

After this we can easily able to login and do practice with HR schema.

Unlock_HR_account

 

 

 

 

 

 

 

 

 

 

 

 

 

Enjoy  🙂