#2 How To Connect With HR User/Schema In Oracle Database 19C | HR User Connection To SQL Developer

Hello Friends, today we are going to UNLOCK hr User in oracle 19c, you can follow below methods to connect hr user:
TO CONNECT HR USER :
Go to CMD
C:\Users\admin : sqlplus / as sysdba
SQL: select name, open_mode from v$pdbs;
SQL: alter session set container=ORCLPDB;
SQL: alter pluggable database open;
1] find tnsname.ora file: to know path :
1. Go to the control panel
2. Type advanced system
3. Click on View Advanced system setting
4. Click environment variable
5. Click on oracle path to know the db_home path
2] Net Configuration Tool :
1. Local Net Service Name Configuration
2. Click Add
3. Service Name ORCLPDB
4. Prorocol: TCP
5. HOSTNAME: localhost , PORT: Standard 1521
6. TEST Connection: YES/NO
7. ENTER THE NAME WHICH YOU WANT.
SQL: alter user hr identified by hr account unlock;
C:\Users\admin: lsnrctl reload
----------------------------------------------------------------------
Book Domain & Hosting with Discount : www.hostg.xyz/...
------------------------------------------------------------------------
Follow US :
@Website:
pradeepworld.com
@UA-cam Channel:
/ pradeepworldofficial
@Linkedin :
www.linkedin.com/in/pradeep-wagh
@Facebook Page :
/ pradeepworldofficial
@Telegram Group :
t.me/PradeepWo...
@Facebook Group :
/ 356682202431801
-------------------------------------------------------------------------
Don't Forget To Like | Share | Subscribe
--------------------------------------------------------------------------
#pradeep_world
#hr_user
#oracle_19c

[@saivamsi1159]

Thank you so much for the video it helped me a lot

[@pradeepworldofficial]

It's my pleasure to help people like you. Keep learning, keep exploring..!

[@shanmukhaayyappa5878]

I am tried your process. Now HR schema is connected. Thank you Bro

[@viswayandapalli7440]

Superb bor 🎉🎉❤

[@pradeepworldofficial]

Sorry didn't get

[@sushantsalunkhe4482]

Very Useful Thank You Very Much 🙏

[@pradeepworldofficial]

Thank you keep in touch do Subscribe

[@motivationalvideo_22]

nice

[@pradeepworldofficial]

Thanks

[@shruthiv9146]

very useful sir

[@pradeepworldofficial]

Thank you

[@akashpandey-mh6pi]

thanks bro

[@mrtharunprao]

I have entered the same but it's showing a table or view does not exist..
What to do, any alternate method.

[@shividubey2741]

I am unable to connect to hr user, can you please assist on the same, I have followed all the steps but it’s not working

[@pradeepworldofficial]

You can contact on [e-mail]

[@mrtharunprao]

Is this a permanent solution or not, because whenever I open Oracle SQL and try to connect the database it's showing the table does not exist..

[@pradeepworldofficial]

We need to execute this command first

[@pradeepworldofficial]

Contact us if you find any problem

[@agastyamanju6359]

Aise install karke mehenga pad gaya 🤦🏻‍♂️
Error baar baar aa raha hai

[@pradeepworldofficial]

Kya error hai