Thursday, April 24, 2014

Unlocking HR Account in Oracle XE Database

In this post I will be showing the steps to how to unlock HR account in Oracle XE database. After some days, when you try to access HR schema, it says Account Locked. 

I always forget the steps in order to unlock the HR schema, so that's the reason I am writing this simple post.

Open command prompt and enter the command as follows :

sqlplus / as sysdba

This will not ask password and will open the SQL plus prompt.



Now after this enter the command to unlock the HR account.

ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY password;



And that's it. This will unlock the account and you will be able to access HR schema again.

Thanks !!

1 comment:

  1. If you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you gotta watch this video
    right away...

    (VIDEO) Have your ex CRAWLING back to you...?

    ReplyDelete