Oracle 19c: HOW TO UNLOCK HR USER in Oracle Database 19c by Manish Sharma

In this Oracle DBA tutorial, you will learn how to unlock HR user in Oracle Database 19c by Manish Sharma. Unlock the pre-defined HR database and start learning Oracle Database today. www.rebellionri...
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: www.rebellionri...
Previous Tutorial
► How to Install Oracle 19c: • How To Install Oracle ...
►Master Oracle TNS: • How To Create [TNS Ser...
-------------------------------------------------------------------------
►►►Social Media - Where I sort of Live
/ therebellionrider
/ rebellionrider
/ rebellionrider
/ mannbhardwaj
-------------------------------------------------------------------------
►►►Books I refer to
PL/SQL amzn.to/2QE1jX0
Performance Tuning amzn.to/2sgiAw4
1z0-071 Exam amzn.to/2sgfeJw
Python Programming amzn.to/305UEbh
-------------------------------------------------------------------------
►►►Camera Gears
Favourite Lens 1 amzn.to/2NbUE46
Favourite Lens 2 amzn.to/37SMA03
My New Video Light amzn.to/35FgXFK
Camera Remote [Secrete Weapon] amzn.to/2QH8aPj
Super-Fast inexpensive SD Card amzn.to/2shqhCg
Awesome Vide Mic amzn.to/2QGdliz
On-Camera Mic Worth Every Penny amzn.to/2tIEkBd
Sound Recorder amzn.to/2QZmeTm
Camera- I am using Canon 600d which is not available in the Market Now. But I am soon switching over this camera amzn.to/2R2W3v8
All of the above are affiliate links. Please use them to support the channel
#RebellionRider #OracleDBAwithRebellionRider #OracleDB

[@Rebellionrider]

Since Oracle Database 12c release 2, oracle decided to ship only HR schema with the Oracle Database software. Which means if you want to use and unlock other sample schemas like OE, SH, OC and others then you will have to download them from GitHub. github.com/oracle/db-sample-schemas/releases/tag/v19c if you want me to do a video on how to install Sample user from GitHub in Oracle Database then comment and let me know.

[@mithileshkushwaha7420]

thank you so much

[@Rebellionrider]

Always a pleasure 😊

[@rojarosethomas8173]

Hi sir..I am unable to open hr schema in my sql developer.I am using oracle database 12c release 2.i have tried many methods to unlock it but its not working out.pls can u help me out...

[@syedmohsin3397]

Hi Manish, I couldn't able to locate listener.ora file in my computer. Could you please is there any alternative way to find that.

[@batboy-um9kv]

I watched lots od tutorials, but none od them helped. This one not only helped but everything is perfectly explained.

[@alexmalyshev8675]

I've spent approximately 10 hour trying to connect to users scott and hr, I've red enormous amount of documentation and different articles, I've droped DB 5 times because I thought I've done something wrong during the installation and only in your video I've finally understood what was the reason of all my mistakes. I forgot to restart litener and open DB. Thank you, Manish, you are my rescuer!!!

[@Rebellionrider]

Really happy to be of help. Wish you loads of success with DB in future. Also, please do share the video to help others in the community.

[@syedmohsin3397]

Where did you find listener .ora file. I couldn't able to locate on my computer.

[@IronMan-ke8zq]

@@syedmohsin3397 C:\App\db_home etwork\admin

[@aymankhalifa5676]

Best database teacher ever.. thank you so much you saved my life.

[@Rebellionrider]

You just made my day

[@prasannag31]

Thankyou so muchhhhh....I have been really struggling to do this. Uninstalled Oracle and SQL Developer as well but cldnt overcome the issue. Your video was very helpful. Now my HR User is unlocked.

[@mariamsn4559]

thank you, ive spent over 10 hrs trying to fix this problem util i came across your channel!

[@Rebellionrider]

I'm glad I could help you out! 😊 If you could quickly master any advanced SQL skill, what would it be and why? Your insight is valuable! 😊🌟

[@kalindsingh2108]

thank you brother i was struggling alot, issue was in database hr was in mount mode and was not able to change its mode to read, write but your vedio helped alot. Again thank you.

[@ANIMABAIN]

Hello Manish, I am your new subscriber. I was able to unlock the HR user by the NetCA configuration method. Thank you for the wonderful videos. Keep up the good work.

[@Rebellionrider]

Great 👍All the best. Please share the video on your social media that will my channel.

[@jayasreecarey7843]

Thank you Manish for the detailed walk thru !!

[@Rebellionrider]

I am glad you like the video. Please do share and like it. Thanks

[@bhargavasai1510]

Thank you very much Manish. This helped me a lot.

[@Rebellionrider]

Always a pleasure

[@rupalinirmal7023]

thank you so much for your videos about Oracle database, they've helped me a lot.

[@KazzArie]

Excellent information, thank you. I got into a new instance, created a non sys type user, and got the password error. So frustrating!! I don’t need to see all the sys tables. I’ll try this tomorrow. Thank you again.

[@Marco-pq4hs]

Liked & suscribed. Manish you are the man!

[@akashkantrikar5551]

One of the best tutorial video, Upload more videos on oracle 19c so that one can become Master like u

[@kamalutheen9793]

thanks bro , your presentation very useful

[@smalllsz]

This was so helpful with my homework! Thank you!!

[@ibrahimidris7741]

Thank you, Manish.

[@pjkavitha249]

Really thank you Manish . I did it

[@kalindsingh2108]

Is it better to use oracle sql developer tool on mac directly or through a virtual machine?

[@atulkoshta641]

you helped me twice in my hard time.. thanks man ❤

[@ivanchogc]

Great !!! Thanks Manish

[@trentarmstrong5000]

Excellent tutorial. Thank you!

[@robertocorrea464]

Hi! Thank you very much for your videos about Oracle database, they've helped me a lot. Can you do a video or a blog entry explaining the multitenant architecture used by Oracle database? Container vs pluggable DBs. Thank you in advance.

[@sayarawasim3172]

Thank you for such valuable knowledge sharing.

[@HenryLeu]

Thanks! You saved my day!

[@njavamonkb]

wonderful presentation , I look forward to watching all your videos.....

[@amarazahid9039]

Thank you so much.. Your videos are really helpful

[@bharathsharma8854]

Thank you so much manish :)

[@pratibhanevhare2757]

Thank you bro this video very helpful to me

[@Rebellionrider]

I'm glad you found the video helpful! If you have any more questions or need further assistance, feel free to ask. Happy learning!

[@sahilaherkar888]

Thanks man it really work🙂

[@sushmitadey4467]

That really helped , thank you.

[@debabrotobose6489]

I'm getting the error: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 64-bit Windows Error: 61: Unknown error Please help to resolve this.

[@victorespiritu3431]

WoW! You don't know for how long I have been looking for this explanation. Thank you for this video and thank you for taking the time to make it and share the knowledge. You definitely made my year!!!!! By the way, can I install Oracle database on my mac without using a virtual machine? I borrowed my girlfriend's laptop to make this possible. Appreciate immersively your work.

[@Rebellionrider]

Thank you so much for your lovely comment. Yes, you can install oracle on your Mac though the process is not this simple.

[@victorespiritu3431]

@@Rebellionrider is there a video on it?

[@shreyassalunkhe122]

Much helpful...!!!

[@Rebellionrider]

Thank you so much. Please do share on your social media and with your friends.

[@vicolodo1]

thank you very much, good explanation!!

[@Rebellionrider]

Glad it was helpful!

[@LuisMarquez-SOA]

Great video, thanks for the explanation.

[@Rebellionrider]

My pleasure always happy to be of help ☺️

[@shrikantkhurd3323]

TNS-01190: The user is not authorized to execute the requested listener command i am facing this error sir..

[@koralive4942]

THANK YOU

[@haimanotmenberu2926]

Thank you Manish

[@sanketkillekar]

Love u bro..aftr a sleepless night u came as a saviour ❤️

[@rafaeldavidalvarezgonzalez6173]

I love you, you're the Best!!

[@dealeras2143]

amazing thank you so much!

[@mglights424]

Hi Manish, I have installed Oracle database 19c inside a virtual machine with Windows 10 OS. Now I am trying to connect the database using SqlDeveloper v23.?? but the connection fails. Please throw some light.

[@eduardojavier112]

how to configure it in oracle developer?

[@enesaltan5502]

Thank you very much.

[@manideepakgopisetty2746]

Hi Manish, I'm using oracle 18c and issue I'm facing is when I have connected to DB from sql developer db session is resetting frequently. How to make my db session constantly without resetting.

[@에덴리시버]

Thank you!

[@aboukaba402]

Thanks

[@bramvilokhande2677]

Hi Manish, i tried the steps showed by you in this video and was able to unlock the HR user but when i was trying to connect HR user using SQL Developer i am getting error "test failed ora-01017 invalid username/password". It will be of great help if you can provide steps on how to connect to HR user using SQL Developer.

[@Rebellionrider]

first check if you are putting correct login information like user name and password. Second check if the pluggable database containing HR schema is turned on. If it is turned off then follow the steps that I have demonstrated in this 50 second Instagram video instagram.com/reel/CPV5WxGAsxo/

[@pavansharma7944]

Please make full video playlist of oracle 19 c SQL

[@ThaerFAli]

Thanks Manish, that explanation was really awesome. HR user is now unlocked!!!. finally, I wonder, do we need to do that every time we to log in as hr user??

[@Rebellionrider]

No you don't... Once you unlocked the schema you can use it like any other user you have in your database.

[@ThaerFAli]

@@Rebellionrider Thank you mate, how about using sqlplus interface it doesn't accept user name and password. Is there any way to log in? Cheers.

[@madness817]

thank you very much

[@hashimraza3331]

select name , con_id from v$pdbs; Sir, if this statement return on Row then

[@joezoma5847]

Subscribed on the spot :)

[@Alhazza944]

Thank you for your tutoring. HR user in unlocked now. However, I have been struggling with locking user again when I turn off laptop then I have to repeat all steps again !! I did commit but same issue. Do you know why??

[@MoinKhan-cg8cu]

I have also same issue, r u able to resolve it ?

[@samisajjad802]

@@MoinKhan-cg8cu Try Alter pluggable database orclpdb open; log with sysdba account.

[@vij811]

i have installed pdb after installation of 19c. so as per your step i am not able to open hr user. still error user does not exist. can you help me ?

[@iqbalahmadkhan7847]

SQL> ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE open * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode. i did all but lastly i get above result . not opening mount database

[@prasadshinde9440]

ORA-12154: TNS:could not resolve the connect identifier specified showing me this error while connecting to hr

[@pavansharma7944]

How to demonstrate two sessions competing for resources as a result of a lack of using a commit or rollback in oracle 19 c

[@ajaykulkarni2824]

I am getting no listener error while connecting to tns using net configuration assistance

[@madhuporeddy7204]

Pls make the video on Scott user

[@Rebellionrider]

Thanks for the feedback. Let me see what I can do.

[@trystayaway7663]

Jow i can create and execute triggers in oracle 21c

[@ishantdutt9872]

Thank you Manish for this helpful tutorial. I have a small request and that is how to connect to hr schema in oracle 19c using SQL developer, can you please make a tutorial about it as I am having trouble unlocking hr schema using SQL developer.

[@stevemungai3542]

am having the same problem too

[@IronMan-ke8zq]

After unlocking HR user in Oracle Database 19c using the above video, open the SQL developer and follow the below steps: 1. add new database connection 2. name = HR, username =HR, password= hr, hostname = localhost, port = 1521, servicename = orclpdb 3. Test the connection and save it

[@Thecinesthetic]

Thank u ❤️

[@tungtran-py6iq]

i follow your tutorial untill the end, but it keeps saying user hr does not exist, so what do i do now? download oracle 11 to have hr already?

[@tadashitani]

Hi, I'm setting up an Oracle DB 19c on a CentOS 8 machine and I followed all your steps, but I couldn't unlock the HR user. It's a fresh instalation of both OS and DB, my PDB came out to be "ORACLEPDB1", I set the tnslistener.ora accordingly. What could be wrong?

[@tadashitani]

I got the solution, I don't know why, but the user HR was not created when I executed the script to set up the sample database. So I had to manually create it in SQLPLUS, by running: SQL> @?/demo/schema/human_resources/hr_main.sql. After executing the above (which created the HR user) I was able to unlock the user and connect to it. Hope it helps somebody.

[@Tomasz200010]

I get this message ORA-00942: table or view does not exist after trying to execute the statement shown in 4;47

[@debiprasadsahoo9726]

sir kindly help me how to unlock scott user in oracle 19c??

[@ahmadali-zz8om]

OMG thank you a lot

[@Rebellionrider]

Always a pleasure. Your appreciation means a lot to me.

[@nicksmith418]

What do we do now after we have unlocked hr user?

[@abrar8133]

ORA-12154: TNS:could not resolve the connect identifier specified Warning: You are no longer connected to ORACLE. the error i'm getting. What i'm doing wrong? same steps as yours!

[@prasadshinde9440]

have you find solution for this

[@pawebilski9859]

Hi, I have problem. I did everything like in your movie but I cant alter user HR. I have properly connected to my pluggable databse (xepdb1 in oracle 21c in READ WRITE mode) but I have an error ORA-01918 user 'HR' does not exists. What can I do with that? Thank in adcance.

[@santuex8188]

did you find a solution to this problem?

[@manireddy1238]

Have u find the solution bro

[@karthikms03]

Hi manish i am getting error while connecting to HR schema in oracle 19c TNS-01190: The user is not authorized to execute the requested listener command. Please help how to get this issue resolved and make the connection to HR schema

[@erenyeager_0510]

after doing all these stuffs, i am getting the same problem as before.. nothing changed at all.. its snhowing ORA-01017: invalid username/password; logon denied

[@giriy3052]

Hi Manish , I am getting error in win7 as ORA 12543 , please help on this

[@itws1juliasukr26]

Hello. I try to follow your video, but... I can't find folder 'network'. I installed desktop version. Did I do something wrong during installation? I connected to SQL Developer as user SYS and can't see user HR in directory 'Other Users'. Is it ok or I have to see him there?

[@suheljaglan4109]

hey I have the same issue. Have u find any way to resolve it?

[@pratibhanevhare2757]

sir please solve another issue I face this issue while connectivity java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist please solve this problem

[@Rebellionrider]

The mistake is quite evident - the table you're trying to query hasn't been created. There's a possibility you might be misspelling the table's name. To verify, you can check if the table exists in your database by running the following query: SELECT table_name FROM all_tables; This will display a list of all tables created under your user. Make sure to double-check the table name spelling.

[@neelaptvptv7472]

Hii...I'm getting g logging denied ..plss tell me why

[@arungupta5528]

Could you provide link to download Oracle 19c

[@abarth0800]

Really nice tutorial. Too bad the last step gave me a ORA-12154

[@pranayveeramalla7574]

Hi manish its saying as no rows selected what to do ?

[@mohammedabomokh7818]

Did you find the solution ?

[@vasanthakumare2791]

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-01190: The user is not authorized to execute the requested listener command

[@vasanthakumare2791]

Please help me.

[@zod1ack_csgo_clips425]

@@vasanthakumare2791 Open command prompt through Run as Administrator.

[@irumimtiaz-zo4bq]

i cant find network file does someone know how to locate this file in 19c?

[@Mang3652]

what it the user HR does not exist? in my case the same msg appears. "ORA-01918: user 'HR' does not exist"

[@Rebellionrider]

Check if the pluggable database containing your HR schema is open for read write or not. If not then open it. You can refer this 30 second shorts for that - kzbin.infobeYcobrCKG0

[@navarre2142]

I got all the way to the end, but when attempting to execute the final command to connect the HR user, I am getting the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Any tips on how to solve this? Many thanks!

[@hussienkahoul9738]

have you solved this problem?

[@Ani_stores]

I am getting error when connecting hr schema error code is ORA-12514

[@iqbalahmadkhan7847]

SQL> SELECT name, open_mode FROM v$pdbs; NAME OPEN_MODE ---------- ---------- ORCLPDB MOUNTED SQL> ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE open * ERROR at line 1: ORA-65054: Cannot open a pluggable database in the desired mode. what is going on here worng , my database is not openging

[@nicksmith418]

I am logged in as an administrator but am unable to reload my listener. Is there a way to fix this?

[@nicksmith418]

Nevermind! I was using the incorrect command prompt.

[@neelaptvptv7472]

Logging denied ..plss tell me why

[@ahsanulhouqe3303]

I ve just followed your procedure and it says, ORA-28000: The account is locked.

[@rahul0172ec]

How to unlock Scott user

[@samisajjad802]

Didn't worked for me. Getting Error Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (CONNECTION_ID=RIkX6sb6RAutQHHzD1d8yg==)

[@Pavan_Aiyappa]

Give the service name as orclpdb in sql developer , dont give it in SID and username and password as showed hr / hr , connection name give a new connectin name maybe hr_conn

[@chammarasilva]

%db_hom% etwork\admin not able to open this path in explorer

[@Rebellionrider]

Watch this video to learn how to find db home kzbin.info/www/bejne/anatlJWHqsaYiJI

[@sihatafnan5450]

TNS-01190: The user is not authorized to execute the requested listener command Getting this error.What to do?

[@sagarpatankar8919]

Try to run Command Prompt Screen using "Run as Administrator" and then execute the command. I was able to resolve my problem in this way.

[@raudbook9683]

how can start from oracle 19c database tutorial

[@Rebellionrider]

Check out this blog and see if it's of some help to you. www.rebellionrider.com/how-to-learn-oracle-db/

[@AsianTrackGamerYT]

Plz make a video on how to create new user in oracle 19c

[@Rebellionrider]

Thanks for the idea I will do a video on it soon.

[@AsianTrackGamerYT]

@@Rebellionrider also make a video on how to transfer or access one database to other computer

[@jitendranandurkar2888]

its unlocked using this way, but get locked every time i log off the system. i have to unlock every time when i log in to system. is there any way to do it in one time..

[@Rundatbul]

commit;

[@daye1997]

Great tutorial, I have Oracle19c , Here are the list on commands, Any suggestions ? Thank you SQL> alter session set container =orclpdb; Session altered. SQL> show con_name; CON_NAME ------------------------------ ORCLPDB SQL> select name,open_mode from v$pdbs; NAME -------------------------------------------------------------------------------- OPEN_MODE ---------- ORCLPDB READ WRITE SQL> alter user hr identified by hr account unlock; alter user hr identified by hr account unlock * ERROR at line 1: ORA-01918: user 'HR' does not exist

[@santuex8188]

did you find a solution to this problem?

[@astirmon7610]

lsnrctl reload LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 22-APR-2023 15:02:45 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) TNS-01190: The user is not authorized to execute the requested listener command

[@samshepherd6197]

Followed instructions, result, ERROR at line 1: ORA-01918 user 'HR' does not exist.

[@santuex8188]

did you find a solution to this problem?