THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU AND A HUNDRED TIMES THANK YOU I've been trying to get into databases for like 4 days, and now I know how. THAAAAAAANNNNKSSSSS
Hi Jaspheral. Please have a look at stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript . Phillip
After update 21.0 then get Data convert issue unicode to non unicode in SSIS package from oracle source (OLEDB) to SQL Server , I check NLS_LANG = AMERICAN_AMERICA.AL32UTF8, or need to change other values ?
thank you very much sir, please let know, In oracle sql developer at time connection, on SYS which Password did you use? please let me know, I want to use, because I struck here... i can't login... please anyone clear my problem..
Hello Sir, I have a doubt. I already had previous version (which I don't remember) already Installed. So I made some change in registry then only it let me download this version. But it got partially installed and not successfully installed. Will it generate any error in future?
Oracle SQL Developer: I click +. I fill in what you said and then i click Test: I get error: Status : Failure -Test failed: IO-fout: The Network Adapter could not establish the connection (CONNECTION_ID=41hmGy6TT5+tYXrbCvVzVA==)
I make a new connection but it doesn't work, it says " Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=vKlwRHkER1cnSNl0+dhU/Q==)
I keep getting this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=xzxwBzlCQ++Y71f0w/qxeg==)
@@AnilKumar-mp9hk that makes no difference. I've tried everything possible. I've given up on trying to set up oracle/sql developer. Only a fresh install works. oracle and will stick with tsql or msql
Hi @printassia, I had same issue. Turned out to be some kind of network issue as the oracle database on my machine is either not listening on the localhost addesses and/or blocking access to that. As workaround I put in my machine's IP address and was able to connect without any issue.
Hi sir while installing SQL developer I am getting 2 java tabs one is showing SQL developer loading and another one showing oracle Tab. It is not installing and show only loading this software does not fetching files from folder. What should i do.
Hello sir, I am 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=3QrfVajCR+ubRUZlgkcnYQ==)".
CONNECTION ERROR SOLUTION!!! 1. go to services - make sure that OracleTNSListener and that OracleServiceXE are both running. if not "Start" both of them. 2. if that doesn't fix it go to cmd and type in LSNRCTL status a bunch of info pops up go down to Listening Endpoints Summary... here you will find your HOST: PORT: SERVICE: in SQL developer my "Hostname" ended up being an IP address the port was still 1521 and as far as service my system worked with both xe as SID and xepdb1 as Service name. So most likely problem/fix is finding the correct host/hostname. Hope this helps someone save the few hours it took me!
The ones having the error : The Network Adapter could not establish the connection I follow a tutorial and It reslove the problem, this the link : ruclips.net/video/z45q0k2nhqw/видео.html In the tutorial he has fill the Service name box. I left it blank yet The problem is solved. So you do not need to fill the service name
hi I get this message when i try to test as you shown. An error was encountered performing the requested operation: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=KAxuVA0lTICiREmifaNgyA==) Vendor code 17002
Hi, i followed all the process as mentioned in the video..able to login after completing installation .. but next day when i logging in it gives an error: "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=N6rhgk4UTX6yIfiSxpewyg==)" When i searched in internet with that error, to start all oracle services. i checked this too by opening "services.msc" all the ORACLE services by default running .. still getting the error as mentioned..
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=C0YpNI4CTsi+3hm1V9ClDg==)
Wow what a fantastic tutorial!! Thank you so much - you are a legend! You explained it all so clearly. I am all set to practise SQL now. Thanks again.
Thank you so much. The Oracle documentation is not very user friendly and this video made it simple and easy. I hope you keep making more videos.
Thanks a lot for this kind of video. Now I am successfully installed oracle DB as well as sql developer.
Glad it helped. I hope you enjoying using it. Phillip
I was able to do SQL now. Thank you for this video!!
Great 👍I'm glad it helped! There's lots more help in my Udemy course, especially if you want to learn Oracle SQL. Phillip
Through your video I'm able to installed the oracle Database
Thanx a lot for this wonderful description. Really helped me to get into Sql with this vdo.
Great video, I'm up and running. Thanks for the clear explanations!
A great teaching style made this video enjoyable, thank you
THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU AND A HUNDRED TIMES THANK YOU I've been trying to get into databases for like 4 days, and now I know how. THAAAAAAANNNNKSSSSS
That's great. I hope that you enjoy your database learning. Good luck. Phillip
HEY MAN I GOT THIS ERROR.
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
CAN YOU HELP ME WITH THIS?
Hi Jaspheral. Please have a look at stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript . Phillip
Hello Sir, Thank you very much for such a detailed video . Finally managed to install and connect the database
Great 👍I'm glad it helped! There's lots more help in my Udemy course, especially if you want to learn Oracle SQL. Phillip
@@SQLServer101 thanks for the heads up .. will surely check it out👍
Thank you sir, i was able to install thanks to you
Hi, very very helpful to install. Thanks. What next with you ?
Hi Setalag. I'm currently updating my DP-600 course, as the exam has been updated. Phillip
Thank you Sir, Very simple and good explanation
Thanks Sir 100% it works
After update 21.0 then get Data convert issue unicode to non unicode in SSIS package from oracle source (OLEDB) to SQL Server , I check NLS_LANG = AMERICAN_AMERICA.AL32UTF8, or need to change other values ?
Thank you so much for this detailed video
Wish i could give more than 1 like.
thank you very much sir, please let know, In oracle sql developer at time connection, on SYS which Password did you use? please let me know, I want to use, because I struck here... i can't login... please anyone clear my problem..
Hello. Thank you for your question. It's the same password you set up at 4'23". Phillip
THANKS YOU
Almost reached but it is not working at new connection please help me
Excellent video. Thank you
Hello Sir, I have a doubt. I already had previous version (which I don't remember) already Installed. So I made some change in registry then only it let me download this version. But it got partially installed and not successfully installed. Will it generate any error in future?
Hi Dhwani. No idea. I would suggest uninstalling it completely and then try reinstalling it again. Phillip
Hello sir,after installing i couldnt find .xe extension any reason??
Hi User. Thank you for your question. Can you please be more specific. Phillip
Great video 👍
Can we use HR schema to practice ??
Keep up the good work
Oracle SQL Developer: I click +. I fill in what you said and then i click Test: I get error:
Status : Failure -Test failed: IO-fout: The Network Adapter could not establish the connection (CONNECTION_ID=41hmGy6TT5+tYXrbCvVzVA==)
Did you find a fix for this ?
@@minotoror_ Try this
ruclips.net/video/z45q0k2nhqw/видео.html
Don't forget the Windows "Advanced" Firewall config
which password I'm I suppose to write when doing the connection test, is it the same password as the oracle account ?
Hi Wager. It's the same password that you used when installing Oracle Database. Phillip
tq so much sir... very useful🙏
Thanks a lot so great Video
I make a new connection but it doesn't work, it says " Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=vKlwRHkER1cnSNl0+dhU/Q==)
thank you for this.
I keep getting this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=xzxwBzlCQ++Y71f0w/qxeg==)
try entering ... orcl in sid option
@@AnilKumar-mp9hk that makes no difference. I've tried everything possible. I've given up on trying to set up oracle/sql developer. Only a fresh install works. oracle and will stick with tsql or msql
Try this
ruclips.net/video/z45q0k2nhqw/видео.html
Hi @printassia, I had same issue. Turned out to be some kind of network issue as the oracle database on my machine is either not listening on the localhost addesses and/or blocking access to that. As workaround I put in my machine's IP address and was able to connect without any issue.
@@fkwvdpol This also worked for me - putting in my IP in place of localhost.
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=mpX+AXmRRoON9tKG9PfBmA==)
hi, did you manage to fix this?
very helpfull, thank you
Hi sir while installing SQL developer I am getting 2 java tabs one is showing SQL developer loading and another one showing oracle Tab. It is not installing and show only loading this software does not fetching files from folder. What should i do.
Hello sir, I am 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=3QrfVajCR+ubRUZlgkcnYQ==)".
Hi Laxmi. Please have a look at this video: ruclips.net/video/ZTMsdH4hyrE/видео.html . Phillip
Thank u
Thanks a lot
I had a different port number, those having errors may want to check that
thanks very much sir
sir , iam getting the error at end of the oracle 21c express edition installation.
thanks
Sir when I am installing its showing rollback and please try again
Hi Sudheer. Please try the solutions on stackoverflow.com/questions/54989134/oracle-xe-installation-aborts-with-no-error-explanation . Phillip
u are the best
Can u please help me ,I'm getting error ..
CONNECTION ERROR SOLUTION!!!
1. go to services - make sure that OracleTNSListener and that OracleServiceXE are both running. if not "Start" both of them.
2. if that doesn't fix it go to cmd and type in LSNRCTL status a bunch of info pops up go down to Listening Endpoints Summary...
here you will find your
HOST:
PORT:
SERVICE:
in SQL developer my "Hostname" ended up being an IP address the port was still 1521 and as far as service my system worked with both xe as SID and xepdb1 as Service name.
So most likely problem/fix is finding the correct host/hostname.
Hope this helps someone save the few hours it took me!
Yes me also this error
Please help me
How to set password
The ones having the error : The Network Adapter could not establish the connection
I follow a tutorial and It reslove the problem, this the link :
ruclips.net/video/z45q0k2nhqw/видео.html
In the tutorial he has fill the Service name box. I left it blank yet The problem is solved. So you do not need to fill the service name
hi I get this message when i try to test as you shown.
An error was encountered performing the requested operation:
IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=KAxuVA0lTICiREmifaNgyA==)
Vendor code 17002
Hi. Thank you for your question. Please have a look at stackoverflow.com/questions/14340729/vendor-code-17002-to-connect-to-sqldeveloper . Phillip
Hi, i followed all the process as mentioned in the video..able to login after completing installation ..
but next day when i logging in it gives an error:
"Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=N6rhgk4UTX6yIfiSxpewyg==)"
When i searched in internet with that error, to start all oracle services. i checked this too by opening "services.msc" all the ORACLE services by default running .. still getting the error as mentioned..
Hi. I would double-check that ALL the services are actually running. Phillip
Thank you so much
Status : Failure -Test failed: The Network Adapter could not establish the connection (CONNECTION_ID=jk+dVcYvRxuFYOtxvFYMTQ==) I have an error
Hi Alex. Please have a look at ruclips.net/video/r9pHqOfV2f0/видео.html . Phillip
Try this
ruclips.net/video/z45q0k2nhqw/видео.html
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=C0YpNI4CTsi+3hm1V9ClDg==)
Hi Kozlo. Thank you for your message. Please have a look at ruclips.net/video/ZTMsdH4hyrE/видео.html . Phillip