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…
Thanks, it help me out to try hand on HR schema.
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.
that’s really an a easy way thanks alot
Thank u sooo much, I was trying to open hr schema for two days & I wouldn’t do that without your help
Thanks again
Thankssssssssss
thx a lot. simple working response to a problem. thanks
Thank u, You saved my day. I tried it for the scott database, it worked
Thanks very much
thanks a lot,problem facing with my pc was e-explorer not working but it is possible using this command
thanks a lot,it is really a perfect guidance with minimum efforts.You really made my day.
It really works…
Thanx…… It’s cute….!
sir , would you tell me that why can i not able to open hr account
can u explain little bit …
is there any error or maessage is coming and on which step ?
oracle not available
Thanks a lot, it help me to practice most of the oracle 10g samples
Thank You Very Much For Help Me TO Unlock User Hr.
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.
error code “status : failure -ora-28000: the account is locked”
Thanks man … This helped me a lot !!!
Thanks a lot…
thank you very much…….
how to unlock mi hr account
huhhhh…. finally i found right tutorials for me…. your articles really helped me…
thank u very much…
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
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.
excellent thought nice description ………..
thank you so much!! the simplest and clearest answer to my problem 😉
Sincere Thanks .
Thanks a lot! U are great!
Thanks a lot Satyendra Kumar. This really helped me unlock the HR user schema and able to see tables & related records.
–Bhaskar
thanks a lot
thanks veryyyyyyyyyyyy much
this realy helped to open the account
Thank you very much!
THANK U JANU :-* 😀
thank uuuu
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
user ‘HR’ does not exist. Is the error coming to me after typing the command…..help me please its urgent
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…
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………..
Hi ,
You made my training easy as butter……………….Thanks you dud
Thanks alot…..
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 ?
Please read above reply given to manoj …
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
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..
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
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..
wow i am so impress about the simplest way of solving this error
what process shall happen in engine when i try update.?
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??????????
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
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.
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.
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.
WHY IT IS SHOWING INSUFFICEINT PRIVILEDGES??
thanks a lot 🙂 its been a great help sir
u r too good
Thanks Allot…
thanks man.It was really helpful
a great thanx….. 🙂
hi sir,
its showing insufficent priviliges??? and my sql plus hr user name does not exist???
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.
thank you very much it was very helpful thank you
Thanks a lot guru……it helped ease my headaches…………….It worked perfectly!!!!!!!!!!!!!!!!!
THANKS A LOT!!
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?
oh thnx, i got the solution by following this
http://docs.oracle.com/cd/E16338_01/server.112/e10831/installation.htm#I4364
Nice tip! Thank you!
Now how can I view the tables from SQL Developer?
First connect Using HR schema then go to object navigator explore HR Connection .You can see all type of objects there..
Thank U
its nice….thank you!
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
Thnks a lot..entering new entry with system a/c was time was consuming..hr a/c saves time..
thanks.. its really work
thanks a million times u helped me…
Thanks mehn… Very helpful
GREAT AND THANKS
thanks a lot…it worked!!!
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…
THANK YOU!
finally I found the answer I was looking for this a entire day. thanks a bunch bro.
it really helped me
Thanks alot
thanks a lot..
thanks a ton
Thanks You ,account got altered.
Thanks ALot it works :)) very help full
Thanks Dude
can u help me?error message occur in hr ,its say “Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied”
You have to login with correct credential.. How are you logging in sqlplus?
ok,problem solved 😉
Thank you so much…..
thank u boss
thanx a million…worked for me
but I dont have sql plus, I use SQL developer instead, how should i unlock HR schema with sql developer
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..
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.
How to use pl/sql in oracle
Thank you….
really helful………… 🙂 thanks a lot , after wasting so many days finally i got the desired result i wanted…….
alter user HR identified by 123(123 is a password u cn name what u want
) account unlock;
i used this command “ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;” but its is still showing not connected please help.
thanks a lot.