September 26, 2008 by Satendra Kumar

How to unlock Sample HR database in oracle

For working with tutorial of oracle Introduaction to oracle/sql you need to work on the tables which is locked in oracle. for Unlocking these tables you have to follow these steps

1. Login in sqlplus or sqlplus or isqlplus as a user “system” with respective password.

2. Execute the following command

ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;

here password is your passord which you want to use for your account remember this password for further use.

3. Login in with user HR with password specified above

Now you can use all tables specified in tutorial.

Please leave your comment If you encounter any problem…

101 thoughts on “How to unlock Sample HR database in oracle”

Balkishan | March 18, 2009 at 10:58 am

Thanks, it help me out to try hand on HR schema.

Reply
Rajeswaran | September 28, 2009 at 7:28 am

Thanks a lot.I was trying for nearly half a day on unlocking the HR schema.
It is only from your website i got the answer.
Thanks a lot.

Reply
siddharth | November 11, 2009 at 6:52 pm

that’s really an a easy way thanks alot

Reply
Jimmy | February 2, 2010 at 11:28 am

Thank u sooo much, I was trying to open hr schema for two days & I wouldn’t do that without your help
Thanks again

Reply
Salman | April 11, 2010 at 11:55 am

Thankssssssssss

Reply
schumi | May 10, 2010 at 8:10 am

thx a lot. simple working response to a problem. thanks

Reply
Ansa | May 15, 2010 at 6:48 pm

Thank u, You saved my day. I tried it for the scott database, it worked

Thanks very much

Reply
bhushan | September 25, 2010 at 6:00 pm

thanks a lot,problem facing with my pc was e-explorer not working but it is possible using this command

Reply
Neel Gandhi | October 8, 2010 at 12:16 pm

thanks a lot,it is really a perfect guidance with minimum efforts.You really made my day.
It really works…

Reply
Rahim | December 6, 2010 at 8:39 am

Thanx…… It’s cute….!

Reply
priyanka | January 8, 2011 at 5:04 am

sir , would you tell me that why can i not able to open hr account

Reply
- satendrakumar | January 8, 2011 at 7:57 am
  
  can u explain little bit …
  is there any error or maessage is coming and on which step ?
  
  Reply
  - divya | July 26, 2013 at 3:41 pm
    
    oracle not available
Khalid Asghari | January 16, 2011 at 3:46 am

Thanks a lot, it help me to practice most of the oracle 10g samples

Reply
Rajib Pradhan | February 13, 2011 at 3:31 am

Thank You Very Much For Help Me TO Unlock User Hr.

Reply
Robert | May 18, 2011 at 7:32 am

I still cant unlock HR user help! i am 3 weeks in to my SQL class and just got it installed. Had a hard time with me wind 7 64 bit so i installed it on my old pc. i have been altering hr account all night and nothing.

Reply
- Robert | May 18, 2011 at 7:36 am
  
  error code “status : failure -ora-28000: the account is locked”
  
  Reply
KAUSHIK SUDHEE | May 23, 2011 at 3:12 am

Thanks man … This helped me a lot !!!

Reply
Jagan | June 9, 2011 at 4:29 pm

Thanks a lot…

Reply
basha | July 18, 2011 at 7:12 am

thank you very much…….

Reply
anand | August 3, 2011 at 8:59 am

how to unlock mi hr account

Reply
Belind | September 19, 2011 at 8:36 am

huhhhh…. finally i found right tutorials for me…. your articles really helped me…
thank u very much…

Reply
abdul | October 8, 2011 at 9:54 pm

hello , i am using oracle 10g (10.2 version) and when i used ur theory it shows error
ORA-01918: user ‘HR’ does not exist

Reply
ravikiran | October 11, 2011 at 4:17 am

Thanks very much. I was trying to unlock it using the database homepage which i couldn’t see, and was literally struggling since a day. This is the simplest i could get.

Reply
chandra bhushan kumar | October 29, 2011 at 6:22 pm

excellent thought nice description ………..

Reply
jpetross | November 13, 2011 at 10:20 pm

thank you so much!! the simplest and clearest answer to my problem 😉

Reply
Gurjit | December 2, 2011 at 5:50 am

Sincere Thanks .

Reply
liviu | January 27, 2012 at 11:13 am

Thanks a lot! U are great!

Reply
Bhaskar | February 2, 2012 at 12:59 pm

Thanks a lot Satyendra Kumar. This really helped me unlock the HR user schema and able to see tables & related records.

–Bhaskar

Reply
huge | February 11, 2012 at 2:10 am

thanks a lot

Reply
Moustafa | March 22, 2012 at 3:13 am

thanks veryyyyyyyyyyyy much
this realy helped to open the account

Reply
Naresh | April 1, 2012 at 1:11 am

Thank you very much!

Reply
FURQAN KHAN | April 5, 2012 at 12:02 pm

THANK U JANU :-* 😀

Reply
vinoth | April 9, 2012 at 1:22 pm

thank uuuu

Reply
satya | June 2, 2012 at 6:29 am

hi all
whenever i try to login to isqlplus environment i.e http://localhost:5560/isqlplus/ .it throws me error ‘page cannot be displayed’.not sure why but it was working fine for couple of days..but from today morning i am facing this issue.can anybody help ?

thanks
satya

Reply
manoj kumar reddy.g | June 20, 2012 at 5:28 pm

user ‘HR’ does not exist. Is the error coming to me after typing the command…..help me please its urgent

Reply
- Satendra Kumar | June 20, 2012 at 5:47 pm
  
  Hi,
  To unlock sample schema HR you should have pre installed Sample schemas in database.Oracle Universal installer asks to install Sample Schemas or Not while configuration of new oracle database instance. By default it is selected to install sample schemas .In case if you missed the installation of HR Schema please refer to following page and follow the instruction and Run the given scripts to create the same sample HR Schema.
  
  http://docs.oracle.com/cd/B10501_01/server.920/a96539/scripts.htm
  
  Hope it may help…
  
  Reply
  - DiptaRanjan | November 18, 2012 at 5:33 pm
    
    At the time of installation Oracle11gR2 in step of password management
    worngly i lock the scott user. So i failt on trouble to get connected to user scott……………..but ur query really works…………………….
    ……………………………….
    thanku sir………..
Ratna | July 3, 2012 at 4:13 pm

Hi ,

You made my training easy as butter……………….Thanks you dud

Reply
developer | July 12, 2012 at 6:40 am

Thanks alot…..

Reply
Rajith | July 12, 2012 at 11:34 am

hi, I tried to use the code given about but unfortunately im getting following error message ,
ERROR at line 1
ORA-01918: user ‘HR’ does not exist

Can u plz help me with this ?

Reply
- Satendra Kumar | July 12, 2012 at 5:11 pm
  
  Please read above reply given to manoj …
  
  Reply
Madhuri | July 15, 2012 at 10:21 am

Hi sir,

I’m trying to unlock hr but, I’m getting an error pointing “alter and it says oracle not available the error code is Ora-01034

Thanks in adv

Reply
- Satendra Kumar | July 17, 2012 at 1:52 pm
  
  Hi ,
  As per mentioned error it seems your database is not up …
  First try to start database correctly then you can unlock HR User.
  Please follow the cause and solutions for ORA-01034 first .You can find lot of hint by searching “ORA-01034” on google..
  
  Reply
Madhuri | July 20, 2012 at 6:43 am

Ty sir…. figured out that problem…. Now I have another problem…. I have unlocked hr user but unable to view the practise tables and My Firefox is not not responding either…. Ps let me what am I missing here.. Ty

Reply
- Satendra Kumar | July 21, 2012 at 6:47 am
  
  Hi,
  
  Use this link and follow instruction to create HR Schema practice tables …
  http://docs.oracle.com/cd/B10501_01/server.920/a96539/scripts.htm
  
  Hope it may help..
  
  Reply
jason | August 26, 2012 at 6:30 am

wow i am so impress about the simplest way of solving this error

Reply
ramesh | September 13, 2012 at 6:53 am

what process shall happen in engine when i try update.?

Reply
Aminul511 | September 16, 2012 at 5:55 pm

Hi, when I used this ALTER command the message “user altered” appears. But I am still unable to login using HR. When I attempt a login “Your username and/or password are invalid.” appears. But I know HR user exists in th user table that I have seen from system. What is the problem??????????

Reply
dianneK | September 22, 2012 at 11:36 am

i successfully altered hr in the sql*plus but when i log in with it it says i should give privilege first and i guess what i created is a normal account and not the hr …. what am i missing? thanks in advance

Reply
- Satendra Kumar | September 22, 2012 at 1:20 pm
  
  Hi,
  
  Login as system user try these steps
  1.Select * from all_users
  check weather hr user is exists or not
  
  2.if user is exists then
  select * from DBA_ROLE_PRIVs where grantee=’HR’
  
  will give the assigned roles to HR user . To normally connect and working with HR user there should be two roles CONNECT, RESOURCE assigned to that schema.
  
  if those two roles does not exists in that table then assign those roles to HR using following command
  
  Grant connect,resource to hr
  
  and try to connect again
  
  3. if HR user does not exist in ALL_USERS then you have to create HR schema manually .To create HR schema you can follow the answer given to other people in abover reply given by me.
  
  Reply
Neha | October 27, 2012 at 9:07 pm

with alter user command i’m able to connect to HR…but when i’m trying to use oracle application express my browser, it says …. Invalid Login Credentials!!
what may be the problem?
thnx in advance.

Reply
- Satendra Kumar | October 28, 2012 at 4:03 am
  
  Hi,
  I never used oracle application express but the problem may be in connect string assuming you are specifying correct username and password.
  First try to connect to HR schema using single line credential in sqlplus i.e HR/HR@ORCL where assuming “ORCL” is your connect string for database. If it is connecting then
  1.Open registry
  2.Go to ORACLE_HOME
  3.Create a new string value
  4.Rename it to Local
  5.Double click and provide value ORCL.
  
  This registry setting is very use full sometime for Oracle Forms Development.Else you have to search Oracle Application Express resources to connect the database step bye step.
  
  Reply
Sovanlal | November 10, 2012 at 6:41 am

WHY IT IS SHOWING INSUFFICEINT PRIVILEDGES??

Reply
Evan | December 16, 2012 at 7:15 am

thanks a lot 🙂 its been a great help sir

Reply
shashank Nikam | January 8, 2013 at 6:42 am

u r too good

Reply
vicky | February 7, 2013 at 3:58 pm

Thanks Allot…

Reply
preet | February 14, 2013 at 11:03 pm

thanks man.It was really helpful

Reply
prakash | March 18, 2013 at 4:45 pm

a great thanx….. 🙂

Reply
kishore | March 19, 2013 at 9:17 am

hi sir,
its showing insufficent priviliges??? and my sql plus hr user name does not exist???

Reply
- Satendra Kumar | March 19, 2013 at 9:46 am
  
  Please check previous reply by me in which i provided link for the script of HR Module in case if you missed to install sample HR schema.
  
  Reply
Mohamed Reda | March 19, 2013 at 9:42 am

thank you very much it was very helpful thank you

Reply
Taofeek Adegoke | April 2, 2013 at 11:17 pm

Thanks a lot guru……it helped ease my headaches…………….It worked perfectly!!!!!!!!!!!!!!!!!

Reply
bhaskar | May 10, 2013 at 12:14 pm

THANKS A LOT!!

Reply
Nazmul Hasan Nero | May 20, 2013 at 7:38 am

Thnx a lot for the post but may be it is not enough for me. I am using Oracle SQL Developer and can not find an easy solution for it.
Can i get a full a to z direction?

Reply
Nazmul Hasan Nero | May 20, 2013 at 7:48 am

oh thnx, i got the solution by following this
http://docs.oracle.com/cd/E16338_01/server.112/e10831/installation.htm#I4364

Reply
Louis | May 27, 2013 at 8:14 pm

Nice tip! Thank you!

Now how can I view the tables from SQL Developer?

Reply
- Satendra Kumar | May 28, 2013 at 10:41 am
  
  First connect Using HR schema then go to object navigator explore HR Connection .You can see all type of objects there..
  
  Reply
Patrick | June 12, 2013 at 3:16 pm

Thank U

Reply
Hanwant Singh | June 14, 2013 at 7:25 am

its nice….thank you!

Reply
Qibin | June 26, 2013 at 3:35 pm

Hi Kumar,
I run the line, and it responds: “ORA-01031: insufficient privileges”.
I am using oracle express 11g. Do you know how can I unlock it with Oracle Express 11g Edition? Thanks

Reply
Pratik | July 3, 2013 at 6:27 am

Thnks a lot..entering new entry with system a/c was time was consuming..hr a/c saves time..

Reply
Anoop | July 7, 2013 at 6:02 pm

thanks.. its really work

Reply
eblawe | July 12, 2013 at 1:26 pm

thanks a million times u helped me…

Reply
fred | July 13, 2013 at 12:08 am

Thanks mehn… Very helpful

Reply
gayanati | July 18, 2013 at 6:58 pm

GREAT AND THANKS

Reply
deepk | July 26, 2013 at 7:54 pm

thanks a lot…it worked!!!

Reply
pratik | August 3, 2013 at 11:41 am

hello sir… actually m a fresher in learning oracle nd i have visited ur site for the first time nd cleared my doubts ….. thanks a lot… it was glad for me to see your posts….
plz keep replying to the visitors…..

i would like to ask you that how can i install oracle 10g in my pc having redhat(linux) operating system.
starting from the first step…. that which package i must download ……upto the installation of the same..
thankyou in advance…

Reply
Jan | August 7, 2013 at 4:51 am

THANK YOU!

Reply
Sandy | August 8, 2013 at 11:39 pm

finally I found the answer I was looking for this a entire day. thanks a bunch bro.

Reply
Adnan Alhazmi (@AdnanAlhaZmii) | August 14, 2013 at 6:41 pm

it really helped me

Thanks alot

Reply
vasanth kumar | September 2, 2013 at 5:08 am

thanks a lot..

Reply
Chatwitz | September 19, 2013 at 9:17 am

thanks a ton

Reply
sandeep | September 21, 2013 at 6:30 pm

Thanks You ,account got altered.

Reply
Nimra Ali | November 1, 2013 at 3:54 pm

Thanks ALot it works :)) very help full

Reply
mishranitin | November 12, 2013 at 3:16 am

Thanks Dude

Reply
FAIZAL FK (@5zalFK) | November 16, 2013 at 4:29 am

can u help me?error message occur in hr ,its say “Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied”

Reply
- Satendra Kumar | November 16, 2013 at 4:38 am
  
  You have to login with correct credential.. How are you logging in sqlplus?
  
  Reply
  - FAIZAL FK (@5zalFK) | November 16, 2013 at 7:17 am
    
    ok,problem solved 😉
Balakrishna | January 19, 2014 at 12:04 pm

Thank you so much…..

Reply
sai | January 23, 2014 at 8:42 am

thank u boss

Reply
sam | February 12, 2014 at 1:21 pm

thanx a million…worked for me

Reply
Salman | March 2, 2014 at 6:57 pm

but I dont have sql plus, I use SQL developer instead, how should i unlock HR schema with sql developer

Reply
- Satendra Kumar | March 3, 2014 at 1:22 am
  
  you can go to cmd and type sqlplus and perform the steps. Alternatvely you can use sql developer also just login as system user and perform steps..
  
  Reply
sim | March 5, 2014 at 2:35 am

Wow 6 years after this post was made and people are still finding this information useful! It helped me, spent 4 hours searching the web trying to figure out why I still couldn’t get a successful connection.

Reply
mominjc@gmail.com | May 24, 2014 at 4:17 am

How to use pl/sql in oracle

Reply
bala | July 5, 2014 at 7:18 am

Thank you….

Reply
d | July 23, 2014 at 11:48 am

really helful………… 🙂 thanks a lot , after wasting so many days finally i got the desired result i wanted…….

Reply
peter | September 16, 2014 at 8:50 am

alter user HR identified by 123(123 is a password u cn name what u want
) account unlock;

Reply
manika | September 27, 2014 at 2:12 pm

i used this command “ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;” but its is still showing not connected please help.

Reply
prasad | October 2, 2014 at 6:54 am

thanks a lot.

Reply