How to unlock HR sample user in Oracle Database 18c by Manish Sharma

[@Rebellionrider]

Timestamps ( 01:12 ) Step 1: Find out the container ID ( 02:10 ) How do we get to know whether we are connected to a CDB or PDB ( 04:41 ) Step 2: Find out the service name ( 05:49 ) Step 3: Create an entry in TNSNAMES.ORA ( 09:13 ) Step 4: Switch from Container DB to Pluggable DB ( 11:04 ) Step 5: Unlock the HR user

[@JunaidAhmed-ox2xd]

how do i find other accounts, and how do i use this ? do i simply open sqlplus and log in with HR

[@kingofthehill2891]

PLS help, I've been trying to connect to the ORCLPDB but the system tells me it does not exist. I then tried to use the XE in the tnsora file but error again. i have tried to use 3 different approaches xepdb1, xepdb2 and xepdb3 to connect to the HR but NOTHING is working. PLS PLS HELP!

[@stevecurno6737]

Thank you Manish, I would not have done it without your video

[@Rebellionrider]

Thank you so much for your kind words! I'm thrilled to hear that my video was helpful to you in unlocking the HR sample user in Oracle 18c. It's always rewarding to know that I've made a positive impact on someone's learning journey. If you have any more questions or need further assistance, feel free to reach out. Happy to help! 😊

[@ositaplay]

Thanks for sharing your knowledge!!! I am from Nicaragua, in central america

[@kingshukpal6848]

The video helped me twice.First was while installing it. The pluggable database was shut down unexpectedly.At last was able to change to read-write mode...pheewww

[@DavidSantos-vf1qi]

Awesome!!!! i was trying to follow some tutorials written in the oracle 11g era, that used the HR database that came with oracle xe. Needless to say, I got completely stuck in 18c. But your video saved the day, thanks a lot !!!

[@AlvaroxJr]

THANKS this was so usseful, i was making a cluster in linux and the guide i was following was in another version, i just had to change the rute in linux

[@abhijitsherekar1016]

THANKS SIR, COULD DO IT PERFECTLY BECAUSE OF YOUR CLEAR EXPLAINATION!!

[@Rebellionrider]

I am glad to know that you found my video helpful 😊

[@creativity-mg4816]

Thank you for your help and I appreciate your helping

[@simplementejair0]

thank you! from Colombia! you really helped me! you have a new fan! :D

[@rajalakshmisrinivasan7369]

simply superb .. great work

[@Rebellionrider]

Thank you so much.

[@luiseduardoguillenpoot4550]

Excelent video. Thanks and greetings from Mexico! :D

[@Rebellionrider]

Thank you very much!

[@diegoramirez1926]

Thank you so much for your help, you are a genius it helps me a lot

[@notyourfriend4566]

OMG.. amazing tutorial.

[@mohauramakhula2326]

Like Bowwwsssse! DOONEE! Awesome Manish

[@odin2024]

Dear. I perform all the steps as is, without having any problem. The problem is when I turn off or reject my pc, I have to re-unlock the database, because it returns as it was before. It does not save the unlocking changes. Could you help me?

[@samuelchewaka8621]

I like your videos, there are very informative. Good Job!

[@divergenny]

Маниш, ты топчик, спасибо большое

[@derlyzuleyangelmedina3136]

excellent !! thank you very much

[@Rebellionrider]

Always a pleasure. I am glad you found the videos helpful

[@zayb007]

Hi Manish. I hv been using windows 7 . In my laptop DB_Home .. tns.. not there so how do we can get it .. I must need this plz help me

[@Taleen11]

this tutorial was very helpful, thank you very much.

[@AjitPatilRM]

This is very helpful, thanks a lot!

[@Rebellionrider]

Glad it was helpful!

[@sandeepreddy5084]

thanks for making this video ..... Sir, I need to connect local database (my laptop) by using MobaXterm, could you please tell me how to do this...

[@carloschiquillo5726]

Excelente video

[@ousmanecarvalho2650]

Hi Manish, Thank you a lot. Your video really helped me ^^

[@annaole2871]

Hello Manish! Thank you for your tutorial. Have you any idea what should I do if I face the following problem: SQL> ALTER PLUGGABLE DATABASE open; ALTER PLUGGABLE DATABASE open * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fetched column value is NULL Thank you, Anna

[@saliouseck4263]

thanks it's clear

[@StratKat1998]

Play "Revolution 909" of Daft Punk behind this video. Manish's voice is rhythmical and blends ideally with the track.

[@matijakukec4731]

bro you are the mvp

[@paultam9390]

very helpful!! thank you

[@Rebellionrider]

I am glad that you find the video helpful.

[@Robay146]

Thank you!

[@troublor]

Thank you very much!

[@tron_town]

thanks for the video Manish, i was able to unlock HR, but when i try to unlock OE and PM i get error that user does not exist. looks like i have to install from github.com/oracle/db-sample-schemas/releases/tag/v18c . Any videos on installing the github sample schemas,? i don't understand the readme that comes with the samples

[@SAK-y6j]

Thanks for sharing the information. Your all videos are awesome. I have a query, I followed above steps and opened hr db successfully , worked in sqldeveloper without any issues but if I close sqldeveloper and open again ,and try to work in HR db its throwing error ,Status : 'Failure -Test failed: ORA-01109: database not open ' Its happening every time when I close sqldeveloper version 19.2. Every time I have to follow steps in command line to move from container db to pluggable db ........and so on.. Please provide some inputs

[@Rebellionrider]

In multi-tenant architecture whenever you shutdown your system oracle engine shuts all the pluggable database by default. That’s the reason you are getting this error. To solve this error, you can do two things- 1. Open your pluggable database every time you restart your system. For that use this statement Alter pluggable database open; 2. Open your pluggable database and save its state. Once you do that oracle will save the state of your pluggable database. This way you don’t need to open your PDB again and again. For this run this statement alter pluggable database pdb_name save state; Run both the statements through the sys user. Have a great day!

[@SAK-y6j]

@@Rebellionrider thank you very much

[@julak2305]

i love you so much ;( thank u u saved me ;*

[@jasmanpreetkaur]

Thank you

[@soldadopreciso]

thanks pal, help us on Linux , Oracle 18c XE installed on oracle-linux-7.6 , how to unlock hr sample there. Thanks

[@k.kiran081]

thnks for share this video .....

[@lokesha7461]

Hi, Sir i am unable to run 18c set up file in windows 7 64 bit, after running set up file it is disappearing the command prompt, and no any error or log file is generated, even i checked the regedit , firewall and antivirus as well can you please help me

[@nitinpatil1163]

hi after doing all the steps still getting "ORA-12154: TNS:could not resolve the connect identifier specified" while connecting to hr db

[@gattuvinay71193]

manish, make a video for unlocking scott schema in oracle 18c, please I am not able to unlock scott in 18c it shows user scott does not exist

[@k.kiran081]

how to solve this error ORA-12560:TNS:protocol adapter error showing in my oracle 11g EE

[@mahendrasrivastava9885]

why do we need to unlock hr?

[@adrymateoramon7087]

I love youuuuuuuu, sooooo much!!!

[@avw6839]

thanks a lot sir :))

[@vertexfxdev1536]

Thank u bro

[@satyaprasad8980]

Sir i tried but for ORCLPDB open mode its coming READ WRITE .in your case its coming as MOUNTED.Please reply..or anyone else getting this error plz reply. Thanks in advance

[@Rebellionrider]

Read Write means it's already open.. you don't need to do anything. Skip the step and proceed ahead. Everything is fine

[@kassgroup1033]

still getting same error - ERROR at line 1: ORA-01918: user 'HR' does not exist.

[@Rebellionrider]

Did you open the PDB?

[@אלכסנחשונוב-פ5ע]

@@Rebellionrider Hi i get the same error and my PDB is open, how can i continue from here? Thanks :)

[@mr.o7316]

ORA-65011: Pluggable database ORCLPDB does not exist.

[@k.kiran081]

hey sir i need help how to install orcale 12c in ubuntu 18.04 ............

[@martinlescotcerda3025]

you explain so fast

[@Rebellionrider]

I am sorry for your inconvenience. Your valuable feedback is duly noted. What I can do here is to provide you with the detailed blog that I have done on this topic which contains all the steps that I have explained in the video. You can check that out here. Hope you will find it helpful. Have a great day www.rebellionrider.com/how-to-unlock-hr-user-in-oracle-database-18c-by-manish-sharma/#.W6tJkWgzbIV

[@00admiral]

everything is okay ,, now how can i connect it from jdeveloper ..they tell me"Test failed: ORA-01017: invalid username/password; logon denied"

[@SURESH11021986]

you should change the service name from XE to the entry you made in tnsnames.ora , say in my case i created a new service named XEPDB1.. because XE listens to older container DB not pluggable db we altered using alter session to use the pluggable db

[@ravishankarkumar6409]

हिंदी में विडियो बनाये

[@formaniremon1573]

Chal bhag bihari ... yahan koi peepal ke ped ke neeche pathshala nahi chal rahi

[@MortifyJeden]

Thank you!

[@Rebellionrider]

Always a pleasure

[@vinukondakalyan9798]

Thank u bro