How To Unlock HR User In Oracle Database 21c by Manish Sharma

[@arlettepwatsonify]

Thank you for this great vid. For anyone who gets Error ORA-65011: Pluggable database ORCLPDB does not exist - here is the script to get your pluggable DB name "SELECT pdb_name,status FROM cdb_pdbs;"

[@haameemshimar8828]

hr_main.sql file is not found in the folder

[@prasannag31]

You are awesome Manish. Thanks for such detailed video. Its very helpful. What I feel is great about you is, you explain each and every thing in detail - what we are doing exactly and why we are doing. I have seen other UT videos but none of them has explained in this detail. I was just blindly following whatever steps they were telling.

[@haameemshimar8828]

hy manish, procedure has been successfully created.by HR user is not showing in all_users.while connecting username and password is error

[@nicolasenriquevilloriaguti6602]

Your videos are amazing! Very good voice and video managing. For a non native english speaker, I can hear your videos even with the subs! Thanks a lot for your efforts!!!

[@Rebellionrider]

Thank you so much for your kind words and support! I'm thrilled to hear that you find my videos amazing and that my voice and video management are enjoyable for you. It means a lot to me, especially knowing that English is not your native language and you can still follow along with the subtitles. I appreciate your effort to engage with my content and I'm grateful for your continued support. It's comments like yours that motivate me to keep creating and improving. Thank you again, and I hope to bring you more videos that you'll enjoy in the future!

[@nicolasenriquevilloriaguti6602]

@@Rebellionrider Thanks to you for your generous reply! Your eng is so well pronounced and timed that almost even I can understand you without using the subtles.

[@anudipray4492]

After long time Manish good to see you i have learnt from you many things previously

[@Rebellionrider]

I am really happy to know that you find my content helpful. I am working hard to bring more informative content in future. Thank you so much Anudip

[@mehtabidreesi7942]

@@Rebellionrider @Manish Sharma plz sir kindly amke video on how to upgrade database 12c to 19c in linux from beginners level plz plz plz oracle 12c to 19c on linux p;zy step by step

[@soumyaps2902]

In the zip file,you have shared I couldn't find the hr.main file Could you please help me with this

[@suriyamuthukumar4937]

same for me as well

[@peterlisp3399]

thanks, in pluggable was successful, in regular orcl created by hands , my pleasure ,great man ,great tutorial

[@aytacturan2182]

I found the most descriptive information on this subject thanks to you, thank you very much.

[@tsehayneshhaile5343]

Manish, you are doing an excellent job! It is too beneficial. It took me a while to install it, but it's done now. Thank you a lot!

[@BewithuNnk]

I got an error while doing at the last stage after grant succeeded getting error like tns could not resolve the connect identifier specified?

[@satyabratapani8603]

Hii..Manish when I want to re install Oracle 19c it's show a error called "failed to add sys/sys install user to %2% group"... please guide me how to resolve it

[@insidehead]

ORA-01918: user 'HR' does not exist plz help

[@batboy-um9kv]

anyone knows what is the problem here: ERROR at line 1: ORA-65090: operation only allowed in a container database

[@manishkulkarni734]

Hello Manish sir, I have completed connecting the HR schema as shown in this video but as I logout the session it does not show the connection and I everytime while running the session connect the hr schema by referring your video can you please suggest some solution. Thanks in advance

[@FM-nq7wh]

hi Manish, do you know how to use hr user on oracle db 21c, but with a connection to the oracle free cloud? that was the only way i could install it, i am working on a mac m1 2020

[@amnaiqbal8307]

I have followed your tutorial and my user was created succesfully. But when I try to login as HR it says that user HR doesnot exist... :( any idea on how to fix this? By the way my pluggable database is open.

[@lawie7585]

I was able to find hr_main.sql. is there anyone who can help

[@realbeatrixbee]

thank you for you video. but after unlocking hr user i cant login into it. what should i do&

[@Rebellionrider]

Check the open mode of the pluggable database. Most probably it's mounted not open for read and write

[@Rebellionrider]

You can refer this SHORTS that created kzbin.infobeYcobrCKG0

[@insidehead]

TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist 64-bit Windows Error: 49: Unknown error getting this error plz help... OS: window home 11

[@Konika-q8w]

Manish these videos are amazing, can you help me with backup and recovery in a full detailed video in a single playlist i am confused how to take backup of single database and and full and increments backup.

[@ukaszwnek5089]

Hi. I have error ORA-65011: Pluggable database ORCLPDB does not exist. What should i do?

[@ukaszwnek5089]

I solved the problem 🙂

[@Rebellionrider]

Do share the solution and help other in the community.

[@tomeklewandowski3478]

Wiesz może co wstawić po ALTER SESSION SET CONTAINER = ' ' ? Gdy wpisuję orclpdb z filmu yo wyskakuje mi że nie istnieje takie coś. Lub gdzie tego szukać może?

[@BewithuNnk]

Hi Manish, tq for uploading such kind of videos which is really helpful. I've a doubt why my PC has taken a lot of time to get installed almost more than 2hours oracle 21c. is there any settings that should change to overcome this problem with my laptop (4gb , 1tb wind10-64bit)

[@ramanihoney8123]

hi, i did notfind description to find ORACLE_HOME

[@Rebellionrider]

How to find out the SID and DB Home in Oracle Database by Manish Sharma kzbin.info/www/bejne/anatlJWHqsaYiJI

[@SqlByPrashant]

SP2-0310: unable to open file "_C:\oracle\dbhomeXE\demo\schema\human_resources\hr_analz.sql" what to do next? pls guide next

[@Ahmed_Tarek673]

same problem

[@vineetadola1547]

Hi Manish, I have followed the steps as it is but after all I got the error SP2- 0606: cannot create spool file in logs path. And drop hr cascade and user hr doesn't exist

[@Adarshparmar18]

same error how did you have resolved the error

[@troymelok831]

@@Adarshparmar18 same for me

[@Englishuncovered]

Hi Maneesh ur videos are very useful. Could you please upload videos related to db performance tuning and query tuning also checking dbase health checkup

[@gracedo2603]

Is anyone else having trouble finding the hr_main.sql file?

[@AmitKumar-kx3qi]

Thank you so much bro

[@aabijitshrama1382]

Thanks

[@Rebellionrider]

Welcome

[@Ahmed_Tarek673]

I hate oracle so much