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

Oracle Database tutorials 4: database connectivity using SQL developer and command prompt

903 ratings | 290485 views
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Html code for embedding videos on your blog
Text Comments (133)
Saumyojit Das (1 month ago)
IS THE DATABASE ALREADY CREATED BEFORE? or do i have to create it before writing a query? tell in terms of sql developer
vicky more (2 months ago)
HELLO sir one question what if i have to connect with database with so how connect what is the procedure
fun sub k liye (2 months ago)
sir i follow you completly but my system cannot accept your quries help me sir
Kuldeep Raj Tiwari (2 months ago)
Hello Manish I need some help regarding Oracle database? I have opened sys / as sysdba;and shutdown it; now i am unable to make any connection with database.and getting error code:ORA-03113: end-of-file on communication channel Process ID: 0 Session ID: 0 Serial number: 0 please help
Ganesh Raajiv (7 months ago)
Yogesh Shinde (9 months ago)
sir I am getting this error please help how to solve it c:\Users\Yogesh>sqlplus sys/oracle as [email protected]:1521/orcl 'sqlplus' is not recognized as an internal or external command, operable program or batch file.
Dilawar khan (9 months ago)
how to solve ORA-00257: archive error?
Alexander Neto (1 year ago)
A very helpfull tutorial. Thanks a lot
Olgerta Prendi (1 year ago)
It gives me ERROR , how to fix it? Help me pls
nano solutions (1 year ago)
after writing sqlplus / as sysda it shows an error "sqlplus is not recognized as internal or external command or batch file "
Priyanka sharma (1 year ago)
Hi Manish, i am unable to connect as sysdba as it is givng me error"Insufficient privileges" Please help
Rams Japah (1 year ago)
I have both procedures but I keep getting error messages, like Network Adapter could not establish connection
Diansyah ST (1 year ago)
Honestly, i still don't understand why we should put our ip address.. I did put my ip address but when i test it, it said that network adapter couldn't establish the connection. Then I try to re-change the hostname to localhost, and it works... I am really confused.. But thanks for your videos by the way. They really really really help me learning sql and pl/sql... BIG THANK YOU FROM ME.... (y)
traveladventureyacht (1 year ago)
Thanks, Manish Sharma.
Gurman (1 year ago)
what is up with that weird accent.. :D Though, I am grateful for the video :)
Bharath Reddy (1 year ago)
sqlplus' is not recognized as an internal or external command operable program or batch file................can anyone find me the solution
Neeraj Luke (1 year ago)
Legit, the only youtuber I follow for these things! Thanks a ton
Choong Sin Fatt (1 year ago)
Is not work when i try to connect through SQL Developer by putting Hostname as IP address. It says : Status : Failure - Test failed: IO Error: The Network Adapter could not establish the connection
Choong Sin Fatt (1 year ago)
It is working fine when Hostname = localhost
KUNAL PATEL (1 year ago)
if i dont change the SID then is it ok ?
Noman Abir (1 year ago)
IO error :( OracleOraDb11g_home1TNSListener is running .... lsnrctl status result is completed successfully but why the IO error are showing even i putted wrong pass but it is showing same IO error .... guru ji pls help ........... :(
Level2 Term2 (1 year ago)
PLZ help!!! what is meant by v$database here ? is 'v$database' the name of the table ?
Mansi naik (1 year ago)
i dont have any username and password so how i do ??
Amit Baghel (1 year ago)
While clicking on test it gives me an error of : The network adapter could not establish the connection can someone please help...????
Robert Bhandari (1 year ago)
I like your intro energy really effective.
Swadhikar C (2 years ago)
You are so clean and descriptive in explaining concepts. thank you sir!
Maria Francis (2 years ago)
'status-failure- test failed -IO error : the network adapter could not establish the connection.. ' how to solve this problem? please help..
LUCKY GUPTA (1 year ago)
I am getting same problem ,have you got solution.
Diansyah ST (1 year ago)
maria francis i face the same problem too,,
arijit dutta (2 years ago)
Thanks for this. I just want to know, just like you connected to oracle database from command prompt by /no log, can we do the same in pl/sql developer without getting connected to any user?
tmitchable (2 years ago)
hey , how come I following the same as your direction, but entire of software does't work
Nikill Kodam (2 years ago)
>set ORACLE_SID=orcl >echo %ORACLE_SID%  when i m try to do this step >sqlplus hr/hrERROR: ORA-12560: TNS:protocol adapter errorI M start services function also but how to solve this error.
Mayur Rokde (2 years ago)
Hie.. What will be the difference if we connected to our system while creating user(by giving our system IP address) ? Is it going to save data in our system?? Basically my qtn is Why do we need to give our IP address?
Vichet Kim (2 years ago)
my sql developer doesn't have the ms access tab as shown at 0.51 time in the video. How to i enable this. i'm using oracle 12c, have a 64 bit Windows 10 OS and have quad core processor with 8gb ram. Ive installed the enterprise oracle 12c.
Vasif Eminov (2 years ago)
Hi.I saw this video.I installed sql developer and created oracle database.All thing working.So I want my sql developer connect to in the virtual box database(oracle database) How I can do it?
Sree Lekha (2 years ago)
Could you please let me know how could I create a new username and password for the connection.
Manish Sharma (2 years ago)
You can create new schema and name it whatever you want in Oracle Database. I have done a video on it here is the link https://youtu.be/enFFezPYhCg
kiran bons (2 years ago)
hi sir your videos are helping us to learn in a proper way and i have problem when i m creating new connection in that connection type when i mention sysdba i got an error : test failed ORA- 01031 insufficient privileges why i m getting that error pls can you explain sir
Yogesh Sawant (2 years ago)
can you explain the command: sqlplus /nolog
ayush jain (2 years ago)
can connection take place using netbeans ide(JDBC)
javed Ahmad rahimi (2 years ago)
Mr manish you are doing great job keep it up .
Manoj Mane (2 years ago)
while TESTING the connection it gives error:- "the network adapter couldn't establish the connection". i tried google this error but did not find solution yet ,could you help ?
Iqbal Ahmed (2 years ago)
Manish Sharma i am your fan mate you rocks i am learning many things from you keep doing that good work may god give you healthy and happy life this world need people like you :)
Francis Obiagwu (2 years ago)
i really liked your video. I am learning oracle and I find your video so useful
Deepak Bedge (2 years ago)
Ganesh Raajiv (7 months ago)
Furkan YILDIZ (2 years ago)
What's the answer Deepak ?
aneeth balla (2 years ago)
me too get same issue anbody get the answer pls tell me i put an comment to his video but he is not replying????
Kiran Kumar (2 years ago)
Test status for [email protected] shows IO ERROR.. please @Manish Sharma Sir help us..
Aakash Behl (2 years ago)
same issue....please somebody help me...
Vyanktesh Kanungo (2 years ago)
I am looking for a tutorial on executing spatial queries using oracle spatial..can you help?
Hiba Khan (2 years ago)
thank you for the videos sir; is it possible to get sql+ along with this installation???
Hiba Khan (2 years ago)
great, got it .. thank you soo much for your reply :) how about Form Builder? do i have to install it seperatley??
Manish Sharma (2 years ago)
SQL*Plus comes pre-install with Oracle Database Software. I have done a blog explaining the process of connecting with database using the same, here is the link http://bit.ly/connect-database-using-sqlplus
alekhyareddy patlolla (2 years ago)
very helpful sir..but i forgot the password of username sir..what should be done sir to make a connection now..
Manish Sharma (2 years ago)
Hello Alekhyareddy, Thanks fro writing to me. Have a look at the post on my FB page answering the same question https://www.facebook.com/TheRebellionRider/posts/226582994411745 Hope you will find it helpful.
Ridowan Ahmed (2 years ago)
Test-failed:The network adapter could not establish a connection . Now what ?
Saif Syed (2 years ago)
turnoff any other oracle,SQL,IIS service that is running
Pruthviraj Varma (2 years ago)
If we forgot the unique name of SID CODE so how can we find?
harish chowdary sure (2 years ago)
what is use by selecting color while connecting to a database?
Rohit korde (2 years ago)
Test-failed:The network adapter could not establish a connection What should i do? where can i find my desktop ip and port which will work to connect to database
Deepak Bedge (2 years ago)
Jyotimoi das (2 years ago)
I have a problem connecting with database in Oracle SQL Developer. While connecting it's throwing error "Status : Failure - Test Failed:IO Error : The Network Adapter could not establish the connection".I have seen in web about this error but failed to resolve this.Kindly help me!!!
Probably you didn not install the oracle's database. That's why you can't open it.
Jyotimoi das (2 years ago)
I saw your tutorial and followed the instruction mentioned .But the problem is still not resolved . Getting same error while connecting .In listener.ora i changed LISTENER : HOST=localhost(previously it was SYSTEM name) and in tnsnames.ora i changed HOST==localhost(previously it was SYSTEM name).Both files has SID as XE and not ORCL.I started the listener in cmd but it's not getting started as TNS-12560: TNS : protocol adapter error. TNS-00530: protocol adapter error......While connecting in SQL Developer i mentioned xe(it's default) and not orcl as mentioned in tutorial . # Manish ...Kindly help me with this!!!!!!
Manish Sharma (2 years ago)
Have you checked out this tutorial on my channel https://youtu.be/UWdODgQwE6k on the same error? Please take a look maybe you will find it helpful
Baji Ravella (3 years ago)
thank you very much sir................ ' _ '
Rajasekhar Maddu (3 years ago)
Manish Sharma, i am not able to make connection it is showing error like this ORA-12505, TNS:listener does not currently know of SID
Jayesh Borgaonkar (3 years ago)
I am getting an error - IO error got minus one from a read call while connecting SQL Developer to Oracle Database 11g ,
Abhilash Katta (3 years ago)
good helpful video
RPJ Fun Channel (3 years ago)
sir why on sqlplus username/pasword i get some error like this ERROR:ORA-12560: TNS:protocol adapter error i'am a newbie and i want ask sir , and i want to ask , hostname is filled with several ip . so where you take ip Sir to replace localhost and can connect sir. please answer my question. I want to be an analyst database
Mario Zee (3 years ago)
You have to Enable your Oracle services
Manish Sharma (3 years ago)
+Edo septian pratama Putra I suggest you to take a look at this Google+ post of mine may be this will solve your problem http://bit.ly/tns-12560
Vishnu Reddy (3 years ago)
Superb...very helpful....Thanks Manish
Vishnu Reddy (3 years ago)
+Manish Sharma...please answer my question Can you suggest me the book for below certification. 1.Oracle Database 11g: SQL Fundamentals I 1Z0-051 and 2.Oracle Database 11g: Program with PL/SQL 1Z0-144 please suggest me the books...as i am going for the above certification.
Manish Sharma (3 years ago)
+Vishnu Reddy  Thank you so much for encouraging and appreciating me. I am delighted as well as humbled by your comments.
MadeInChina81 (3 years ago)
Hold on just a second. Damn that wall paper. I feel high.
Abbas Hussain (3 years ago)
hi Manish in this tutorial i have a issue you cannot elaborate , how can get ip address of my own laptop. one more question Is it possible at a time my laptop act as server and client? plz answer me as soon as posible..
Basit Bhat (3 years ago)
In Hostname is it compulsory to give localhost as hostname.. Can't we give ipaddress of our machine..
Ipsita Pattanaik (3 years ago)
Thanks manish , I always watch your videos without a second thought to google. Great work !!
movie mixer telugu (3 years ago)
movie mixer telugu (3 years ago)
Hello Manish, I was able to successfully connect to sql developer
Prosperous Ki (3 years ago)
Thank you so much Manish, You are my guardian.
Vishnu Reddy (3 years ago)
yes right......Saw Thanda Aung
Hamid Rahmani (3 years ago)
Whats up Internet!
Priyanka Joshi (3 years ago)
Ivor Leon (3 years ago)
Hello Manish, I was able to successfully connect to sql developer. But i went back the next day to try some code, if i run the code i get the error "ORA 01033 oracle initialization or shutdown in progress...."
Basit Bhat (3 years ago)
+Ivor Leon Did you try restarting your system.
Ivor Leon (3 years ago)
+Ivor Leon Any help pls
Roger Fed (3 years ago)
Great Videos Manish...your efforts are much appreciated Thank you very much!!
Vaibhav GoOo (3 years ago)
Why to use cmd when all the same functions  can b done using sqldeveloper ?
jatinsview (3 years ago)
Great video... Very thankful for this stuff............
Rohan Rawat (3 years ago)
Hi Manish, Thank you for the video.But Im facing a very weird issue for the last 2-3 days or so. When I create a connection,I do not get all the objects like table,views ,procedure etc in sql developer.Im also not able to run any query.PLEASE HELP!!!
Chandu Parasigani (4 years ago)
Manish, I am thinking to learn Oracle DBA, and i am complete new to Oracle DBA and Sql too, so can you please guide me which tutorial i have to follow, please post the link for Oracle DBA.
Chandu Parasigani (4 years ago)
Hi Manish, Is it complete tutorial for Oracle DBA??
Ndubueze Nwankwo (4 years ago)
Hi Mannish, I am switching career to DBA, i am following your lecture here. how do i get the database used in this lecture so i will be sure i get same result
Hemant Shah (4 years ago)
Hi Manish, where can i find more videos, please provide me the link. thanks
Sonali Nayak (4 years ago)
Hi Manish, Thanks for your videos.Its really helpful. I have installed in 32 bit .It was all fine .I was even working with it .But now  an error was encountered while connecting. IO Error: The Network Adapter could not establish the connection Vendor code 17002   can u plz suggest me to solve it?
Sharath Shivanna (4 years ago)
Hi Manish, thank you for all your videos. They have been very helpful. I have question regarding this video. I have Oracle 12c installed on one machine. I have SQL developer on another machine. The two machines are connected via ad-hoc network.  When I try to connect to the database using the IP address, I get the following error: 'Status: Failure - Test Failed: IO Error: The network Adapter could not establish the connection'. Any help with this issue will be appreciated. Thanks
Yuva Raja (3 years ago)
+Sharath Shivanna You got your answer or still its not solved ? If its not solved ,let me know Bcoz your comment was posted 5 months before from now .
LuckyShotVidz (4 years ago)
So I can connect to the LAN through the command prompt but not through sqldeveloper. Anyone have any idea why?
Deepak Reddy (4 years ago)
Hi manish, Thanks lot your installation steps were easy and straight forward and i was very useful.please share oracle commands knowledge such as case,decode,translate from basic to complex command such as correlated sub query so that it will be helpful for beginners, Regards, Deepak
Ankit Venkat P (4 years ago)
I was able to unlock scott account but I am not able to establish a connection on oracle sql developer....Please help me with login credentials like connection name, username, password,, SID, etc.....i tried the following credentials but failed to connect with the error(Test Failed: IO error: Network adapter could not establish connection): connection name: ORCL username: scott password: tiger connection type:basic role: tried both SYSDBA and default hostname: localhost port: 1521 SID: orcl Please help me with the connection...
Blissfully_ineffable (4 years ago)
Very nice tutorial. I'm taking the OCA course n these vids are helping. You've earned a subscriber my friend:)
praveen kumar (4 years ago)
Really straight forward and made it so simple to understand....I appreciate it....well done job
Sara Hashmi (4 years ago)
Hi Manish, Thank you so much for these videos. was really helpful for me as I am a very new to SQL. Your videos make it so much easy to me. God bless. Also, I have one question, How do I unlock the user HR. I have followed your video but stuck here.. please help Manish. Regards, Sara 
Manish Sharma (4 years ago)
@Sara Hashmi Thanks for all your appreciation it means a lot to me and I am glad to hear that my videos are helping you in learning SQL :-) . Regarding your question on How to unlock a user, I would suggest you to watch my tutorial 41- How to unlock user using command line [ http://youtu.be/sMqq9MSVmQo ] and Tutorial 42 - How to unlock user using SQL Developer [ http://youtu.be/xRBfeTO1Pc8 ].  
Really helpful. Thanks, Manish.
William Jackson (4 years ago)
hi manish , thanks for the tutorial. i have download and can connect using the cmd but if keeps failing when i do it through the developer, please help.thanks
Manish Sharma (4 years ago)
@William Jackson Check for the proper port number. For the port number you can either use tnsname.ora file and look for your SID or You can check port in your listner status on command prompt (lsnrctl> status ). Hope this will solve your problem 
Devils Gaming (4 years ago)
its showing IO error
Devils Gaming (4 years ago)
hey bro, after inserting ip address in hostname, its not showing success ...its showing error
Milky Sahu (4 years ago)
In the first 3 minutes I felt like I'm listening to a sql tutorial on an FM channel :P But very helpful tutos! :)
Kiran Kumar (2 years ago)
Test status for [email protected] shows IO ERROR.. please @Manish Sharma Sir help us..
Manish Sharma (4 years ago)
@Milky Sahu :) This is a unique yet very welcomed comment. Thanks 
739adl (4 years ago)
In SQL Developer, when I try to right click on Connections, the Create Local Connections field is inactive. Do you know why?
jackimite (4 years ago)
Hi Manish, thanks for your tutorials . very helpful. i got a problem when i try to make a sys connection. it worked well using cmd but failed on the developer.pl help
Thusitha Jayasekara (4 years ago)
hi manish i want your help to create oracle database how can i contact you
Manish Sharma (4 years ago)
@Thusitha Jayasekara Soon I'll upload the video on database creation keep watching. and for my contact information you can either read my video description or visit my website.. Thanks 
Sonal Kumari (4 years ago)
Hi Manish Downloaded and Installed Oracle 11g and Sql Developer as per your first two tutorials. Still I am getting ORA-12505 error while connecting from SQL Developer. Works fine when I connect form DB. Please help.
Payal Singh (1 year ago)
what if i got the same error after applying the exact SID ?? still m getting this error in sql developer.
PRAVEEN SONI (4 years ago)
@Sonal Kumari @Manish Sharma  Hi,I checked the port in listener.ora in C:\app\Praveensoni\product\11.2.0\dbhome_1\NETWORK\ADMIN this path but it is showing 1521 and I am getting the same IO Error : The Network adapter could not establish a connection. Can you please help?
Sonal Kumari (4 years ago)
@Manish Sharma Port was 1522 and I was using 1521. Checked the same in listener.ora. All good now. Thanks !
Sonal Kumari (4 years ago)
@Manish Sharma I think system needed a reboot. ORA-12505 is gone. But now I am getting IO Error : The Network adapter could not establish a connection.
Manish Sharma (4 years ago)
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height: normal">Hi Sonal<span style="font-size:12.0pt;font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman""> ORA- 12505 generally this error occurs when you enter a wrong SID. So make sure your SID is correct. If you are able to login into your oralc using Command prompt then first login as sys ( c:> / as sysdba) then for your SID query v$instance view as select instance_name from v$instance; the result of this query will be your SID. Use that SID while creating connection. 
florin4steaua91 (4 years ago)
When I connect as SYSDBA it connects no matter what password I put in: SQL> conn SYS/oracle(the actual password) as SYSDBA; shows me the message "connected" but so does SQL> conn SYS/hgnkj as SYSDBA; Is it supposed to connect if the password is wrong? I am using a local machine (I am not connected to a server)
krishna pendyala (4 years ago)
  after writing  " sqlplus username/password" saying that 'sqlplus' is not recognized as an internal or external command, operable program or batch file.
Manish Sharma (4 years ago)
Set environment variable path to DB_home.
איציק א (5 years ago)
Umasankar V (5 years ago)
It shows connection error. sm prob with ip address i guess, when i tried to do with [email protected]
Sourav Bansal (5 years ago)
Hello Expertise Mr. Manish

Would you like to comment?

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