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

Подписаться 110 тыс.

Просмотров 61 тыс.

50% 1

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.rebellionrider.com/how-to-...
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: www.rebellionrider.com/how-to-...
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

Опубликовано:

30 ноя 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 165

@Rebellionrider 4 года назад

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 4 года назад

thank you so much

@Rebellionrider 4 года назад

Always a pleasure 😊

@rojarosethomas8173 3 года назад

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 3 года назад

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 11 месяцев назад

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

@alexmalyshev8675 4 года назад

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 4 года назад

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 3 года назад

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

@IronMan-ke8zq 3 года назад

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

@akashkantrikar5551 4 года назад

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

@mariamsn4559 2 месяца назад

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

@Rebellionrider 2 месяца назад

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! 😊🌟

@rupalinirmal7023 2 года назад

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

@njavamonkb 4 года назад

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

@aymankhalifa5676 3 года назад

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

@Rebellionrider 3 года назад

You just made my day

@smalllsz 2 года назад

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

@Marco-pq4hs 2 года назад

Liked & suscribed. Manish you are the man!

@atulkoshta641 3 года назад

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

@trentarmstrong5000 3 года назад

Excellent tutorial. Thank you!

@pjkavitha249 Год назад

Really thank you Manish . I did it

@kalindsingh2108 11 месяцев назад

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.

@amarazahid9039 3 года назад

Thank you so much.. Your videos are really helpful

@jayasreecarey7843 4 года назад

Thank you Manish for the detailed walk thru !!

@Rebellionrider 4 года назад

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

@ANIMABAIN 3 года назад

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 3 года назад

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

@sayarawasim3172 2 года назад

Thank you for such valuable knowledge sharing.

@ivanchogc Год назад

Great !!! Thanks Manish

@kamalutheen9793 13 дней назад

thanks bro , your presentation very useful

@KazzArie 4 года назад

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.

@ibrahimidris7741 3 месяца назад

Thank you, Manish.

@robertocorrea464 4 года назад

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.

@bhargavasai1510 4 года назад

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

@Rebellionrider 4 года назад

Always a pleasure

@kalindsingh2108 11 месяцев назад

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

@manideepakgopisetty2746 4 года назад

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.

@sahilaherkar888 2 года назад

Thanks man it really work🙂

@HenryLeu 2 года назад

Thanks! You saved my day!

@dealeras2143 Год назад

amazing thank you so much!

@sushmitadey4467 2 года назад

That really helped , thank you.

@bharathsharma8854 2 года назад

Thank you so much manish :)

@sanketkillekar 3 года назад

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

@enesaltan5502 4 года назад

Thank you very much.

@haimanotmenberu2926 2 года назад

Thank you Manish

@LuisMarquez-SOA 4 года назад

Great video, thanks for the explanation.

@Rebellionrider 4 года назад

My pleasure always happy to be of help ☺️

@rafaeldavidalvarezgonzalez6173 3 года назад

I love you, you're the Best!!

@user-dt4qy8hp6x 2 года назад

Thank you!

@shrikantkhurd3323 3 года назад

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

@madness817 2 года назад

thank you very much

@koralive4942 Год назад

THANK YOU

@joezoma5847 3 года назад

Subscribed on the spot :)

@vicolodo1 3 года назад

thank you very much, good explanation!!

@Rebellionrider 3 года назад

Glad it was helpful!

@pratibhanevhare2757 7 месяцев назад

Thank you bro this video very helpful to me

@Rebellionrider 7 месяцев назад

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

@prasadshinde9440 Год назад

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

@vij811 2 года назад

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 ?

@srichandrasekhar4352 2 года назад

Thank you

@hashimraza3331 2 года назад

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

@Tomasz200010 Год назад

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

@tungtran-py6iq 3 года назад

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?

@Thecinesthetic 2 года назад

Thank u ❤️

@mglights424 11 месяцев назад

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.

@shreyassalunkhe122 2 года назад

Much helpful...!!!

@Rebellionrider 2 года назад

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

@aboukaba402 2 года назад

Thanks

@giriy3052 4 года назад

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

@victorespiritu3431 3 года назад

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 3 года назад

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

@victorespiritu3431 3 года назад

@@Rebellionrider is there a video on it?

@ajaykulkarni2824 2 года назад

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

@Shelby63589 Год назад

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

@pavansharma7944 2 года назад

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

@trystayaway7663 Год назад

Jow i can create and execute triggers in oracle 21c

@RahulRaj-rb4eg 2 года назад

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.

@ahmadali-zz8om 4 года назад

OMG thank you a lot

@Rebellionrider 4 года назад

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

@eduardojavier112 3 года назад

how to configure it in oracle developer?

@tadashitani 3 года назад

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 3 года назад

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.

@irumimtiaz-zo4bq 3 месяца назад

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

@itws1juliasukr26 4 года назад

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 3 года назад

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

@pavansharma7944 2 года назад

Please make full video playlist of oracle 19 c SQL

@ThaerFAli 4 года назад

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 4 года назад

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

@ThaerFAli 4 года назад

@@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.

@sihatafnan5450 4 года назад

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

@sagarpatankar8919 4 года назад

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.

@debabrotobose6489 2 года назад

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.

@arungupta5528 4 года назад

Could you provide link to download Oracle 19c

@iqbalahmadkhan7847 4 года назад

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

@debiprasadsahoo9726 2 года назад

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

@pratibhanevhare2757 7 месяцев назад

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 7 месяцев назад

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.

@nicksmith418 3 года назад

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

@abrar8133 3 года назад

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 2 года назад

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 2 года назад

did you find a solution to this problem?

@manireddy1238 Год назад

Have u find the solution bro

@Alhazza944 4 года назад

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 3 года назад

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

@samisajjad802 3 года назад

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

@neelaptvptv7472 2 года назад

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

@Ani_stores 2 года назад

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

@ahsanulhouqe3303 3 года назад

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

@Mang3652 2 года назад

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

@Rebellionrider 2 года назад

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 - ru-vid.combeYcobrCKG0

@navarre2142 3 года назад

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 2 года назад

have you solved this problem?

@iqbalahmadkhan7847 4 года назад

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

@jitendranandurkar2888 4 года назад

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 3 года назад

commit;

@neelaptvptv7472 2 года назад

Logging denied ..plss tell me why

@pranayveeramalla7574 Год назад

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

@mohammedabomokh7818 9 месяцев назад

Did you find the solution ?

@abarth0800 3 года назад

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

@ishantdutt9872 3 года назад

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 3 года назад

am having the same problem too

@IronMan-ke8zq 3 года назад

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

@chammarasilva 2 года назад

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

@Rebellionrider 2 года назад

Watch this video to learn how to find db home ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4EJcbQuaeR0.html

@madhuporeddy7204 4 года назад

Pls make the video on Scott user

@Rebellionrider 4 года назад

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

@rahul0172ec 2 года назад

How to unlock Scott user

@nicksmith418 3 года назад

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

@nicksmith418 3 года назад

Nevermind! I was using the incorrect command prompt.

@samisajjad802 3 года назад

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 2 года назад

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

@raudbook9683 4 года назад

how can start from oracle 19c database tutorial

@Rebellionrider 4 года назад

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

@goup8327 4 месяца назад

❤❤

@Rebellionrider 4 месяца назад

Thank you for the love! ❤️ If there's anything specific you'd like to see or if you have any questions, feel free to let me know. Your support is appreciated! 😊 By the way, where do you consider yourself in terms of SQL proficiency: beginner, intermediate, or advanced? I'm interested in knowing more about your SQL journey! 📚🤔

@samshepherd6197 3 года назад

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

@santuex8188 2 года назад

did you find a solution to this problem?

@vasanthakumare2791 3 года назад

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

@vasanthakumare2791 3 года назад

Please help me.