HomeОбразованиеRelated VideosMore From: Manish Sharma

Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service

367 ratings | 57725 views
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (73)
harry potter (2 months ago)
How to connect to remote oracle database over windows lan network what software is needed?is it necessary to work by windows server ?
swadhin biswal (3 months ago)
HI Unable to open my pluggable database, after following below steps; SQL> grant dba to system container =all; Grant succeeded. SQL> commit; Commit complete. SQL> alter session set container=pdborcl; ERROR: ORA-65024: Pluggable database PDBORCL is not open. SQL> alter pluggable database pdborcl open; alter pluggable database pdborcl open * ERROR at line 1: ORA-01031: insufficient privileges Kindly help.
Khaifa Gifari (5 months ago)
Thank you sir.
sexy bhabhi (8 months ago)
How to get connection name
soumya ranjan sahoo (10 months ago)
Dear manish bhai.I am hopeless please help me.I have installed oracle 12c successfully.When i open sql plus it is showing to enter username and password.I have tried everything.but failed.what to do now
Liban Garasow (11 months ago)
Great Explanation, appreciate it Sir, we are waiting complete oracle 12c lessons. From Somalia
Manish Sharma (11 months ago)
Thank you so much. Lots of love for all the Somalian audience. I am glad that you find my content helpful. Also, thanks for the suggestion I will see what I can do Oracle 12c. By the way, I will be doing a Live stream on Oracle 12c R2 certification soon on my facebook. Please do join me there. www.Facebook.com/TheRebellionRider
lylez00 (11 months ago)
I had to assign an environment variable TNS_ADMIN = <path of directory containing tnsnames.ora> and then restart SQL Developer in order to get the list of Network Aliases to show up in the drop-down box.
lylez00 (11 months ago)
Be sure to use lowercase hr for the password.
Harshitha (1 year ago)
Manish, upon executing sqlplus/ as sysdba. I am getting error:ORA-01031: insufficient privileges. what should i do?
Mohammad Haque (1 year ago)
You are Great!!!!!!!!!!!!!!!!
Abdullah Shahneel (1 year ago)
hey listen .. I created my own database. I want to create tables and everything in it ... but it is saying limited privileges ... please help me out of this. what should I do?
Mohammed Esmael (1 year ago)
Hallo Manish , I followed your steps and I could not find the file Sampleschema.xml file in sample folder you have . Where can I find this file or download it . Thank you....
Must D (1 year ago)
After connecting to hr in unable to connect to sys , can you please help. I followed the steps from ye previous videos n I can unlock hr schema but having trouble to login to sys..
d mansi (1 year ago)
I was connected successfully with hr but unable to connect to SYS, can you please explain why?
mhmdwahab (1 year ago)
thank you for your great effort could you please show us how to connect SYS and HR account by sqldeveloper in orcale 12c release2 in windows platform
Christian Martin (1 year ago)
The error I'm getting in both cases is invalid username/password; logon denied
Johnny Phan (1 year ago)
Hello, YES... I got an error : SP2-0158: unknown SHOW option "con_name" Anybody know why?
Zakaria Abdi (1 year ago)
Thanks alot
Karan Chaparwal (1 year ago)
Thanks brother you helped a lot...Keep up the good work
EntireB EntireC (1 year ago)
I want to practice SQL queries ,how do i get tables for practice?
Mark Donaldson (2 years ago)
Thanks Manish! After big struggle, your video helped me to connect to pdborcl database.
Prashanth Kannan (2 years ago)
Hi Manish.. Your video is awesome. I tried the same, but am Unable to connect to my sqldeveloper, while connecting "HR", I have given Pluggable Db Container, which is "PDB1" in the service column.. and also I have put the IP address in hosts file (both - Linux & windows). Still I am facing same Error - "failure - Test failed I/O Error - network adapter could not establish connection"... Kindly help pls.. Regards Prashanth K
Sanket Wagh (2 years ago)
For SYS connection, the password was that which was created with a username while configuring the database right?
DON'T VISIT THIS CHANNEL (11 months ago)
But what for the hr user??
Eric William (2 years ago)
The reason SHOW con_name; works in this video is because Manish is using a newer version of SQL Developer, while the SQL Developer bundled with the Oracle 12c installation is an older version that does not have the command featured in the video. I still haven't figured out how to upgrade the bundled SQL Developer without messing up the rest of the installation.
Jeetu Das (2 years ago)
Thanks man it helps alot ..i was stuck in this HR thing ..Cheers
WLIIwox (2 years ago)
Man, your videos are great and really helpful. Thank you for making them.
Arthur Obiadazie (2 years ago)
Im still getting error .. where did you set the HR username and passwords initially??
Adarsh Gupta (2 years ago)
SP2-0158: unknown SHOW option "con_name" ??This error keeps coming ? What to do?
Php Root (2 years ago)
I forgot my password that i've given on oracle installation.Pls help me to retrieve my password and make it to work.
Catarina P (2 years ago)
You're the best!! Thanks a lot for this tutorials :)
Shweta Sharma (2 years ago)
Thankyou so much..
Ron Dean (2 years ago)
Truly a wonderful video series, Manish. I'm taking Oracle classes at a university in a new hybrid format ... Oracle University access, once a month all day class, and independent study. Most of us have been stuck on really basic things. The particular issue around getting access to the sample schemas you describe in your videos has been immensely helpful.
Vaibhav GoOo (2 years ago)
I m getting this error when i type SHOW con_name; **ERROR** == SP2-0158: unknown SHOW option "con_name"
Jeetu Das (2 years ago)
show is sqlplus's command, not sql developer's,
UMAR ALI (2 years ago)
I faced same error.
MD ASIF MUZTABA (2 years ago)
Thank you sir... all tutorials are really very helpful .
Mihoci Ionut (2 years ago)
Thank you very much Manish, great job. Keep going! :D
Manish Sharma (2 years ago)
Thank you so much. Your appreciation means a lot to me. Please do make sure to Like, Share and Subscribe. Thanks
Padmaja M (2 years ago)
great video ..thank you!!!
Manish Sharma (2 years ago)
Thank you so much. Your appreciation means a lot to me. Please do make sure to Like, Share and Subscribe. Thanks
Somenath Paul (2 years ago)
Thank U Bro....Ur Videos Are Really Helpful
César Escobar (2 years ago)
Thanks Manish. You're the best!
Enrique Calderón (2 years ago)
You're the best! thanks!
Manish Sharma (2 years ago)
Always a pleasure. I am happy to know that you find my videos helpful. Please do make sure to Like and Share.
Muhammad Qadri (2 years ago)
I have used user name as : hr and password: hr plus follow the same steps like u go through, i saw some other videos but no one has explained how to get username n password to connect. Please let me know asap. Thanks!!
Pragati Jaiswal (2 years ago)
hi , are u able to connect as for me access denied
Muhammad Qadri (2 years ago)
how can i unlock the hr username and password? while connecting i m getting error: IO error the network adapter couldn't establish connection. Please advise on this
Thank you master!
Subrata Dutta (3 years ago)
Thanks Manish Sharma... Ur tutorial has made our life much easier :) Great work (y). Please continue to post such useful videos :)
Manish Sharma (3 years ago)
+Subrata Dutta Thanks a lot for the encouraging words your appreciation means a lot to me.
jorge Lopez Rojas (3 years ago)
Thank you =)
U're my indian savior
+Manish Sharma Thanks to you! I was ready to uninstall the Oracle database because I couldn't use the hr schema
Manish Sharma (3 years ago)
+Angelo Andre Zambrano Lopez Your comment has become the star comment of the day and is being featured on all my social media. Make sure to check it out. Twitter:https://twitter.com/RebellionRider Facebook Page:https://www.facebook.com/RebellionRider.officia Facebook Profile:https://www.facebook.com/imthebhardwaj Instagram: https://www.instagram.com/rebellionrider/
Manish Sharma (3 years ago)
+Angelo Andre Zambrano Lopez Thanks for this huge compliment. I am truly humbled by your appreciation.
Thank you, it helps!
david banner (3 years ago)
+Manish Sharma, Hi. I'm getting SP2-0158: unknown SHOW option "con_name" error in SQL Developer. Do you know why? Many thanks.
Vikas Ray (3 years ago)
Can anyone tell how to resolve below issue? when i type show con_name in SQL developer i face below error: SP2-0158: unknown SHOW option "con_name"
Zhang Wenzhao (2 years ago)
Did you figure out what is causing this error? I am having the same issue here Thanks
larrytate28 (2 years ago)
Getting the same error as well. The only command that worked for me is "SHOW user".
Vikas Ray (3 years ago)
+Sintia Angarita  Working on it. Will let you know asap.
Sintia Angarita (3 years ago)
+Vikas Ray I am getting same error.  Any updates on the resolution?
unlsoccer1 (3 years ago)
Just wanted to say thank you :)
Shaun McArthur (3 years ago)
Excellent video, thank you.
BATANA ferdinand (3 years ago)
very usefull thanks
Sniki3 (4 years ago)
Great quality Manish, thank you!
Anuradha Mudgal (4 years ago)
Very useful for Oracle's students :-)
Anuradha Mudgal (4 years ago)
Very useful for Oracle's students :-)
Gajanan Patil (4 years ago)
Yess it is..
Olivani Baisheka (4 years ago)
How do you get back to the password management window after you have completed installation. I need to unlock a user and give it a password
Manish Sharma (4 years ago)
+Lucky Luchiano Here are the links on How to Unlock User in Oracle Database, Please Check How TO Unlock User Using Alter User Statement https://youtu.be/sMqq9MSVmQo How To Unlock user Using SQL Developer https://youtu.be/xRBfeTO1Pc8

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.