Это видео недоступно.
Сожалеем об этом.
How to install Oracle Database 21c Express Edition and SQL Developer on your computer - for FREE.
HTML-код
- Опубликовано: 14 авг 2024
- Want to learn Oracle SQL? Install the programs for free.
To find out more about my Oracle SQL Udemy course, please go to: rebrand.ly/ora...
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: rebrand.ly/que...
98-364: Database Fundamentals (Microsoft SQL Server): rebrand.ly/dat...
70-462 SQL Server Database Administration (DBA): rebrand.ly/sql...
Microsoft SQL Server Reporting Services (SSRS): rebrand.ly/sql...
SQL Server Integration Services (SSIS): rebrand.ly/sql...
SQL Server Analysis Services (SSAS): rebrand.ly/sql...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): rebrand.ly/mic...
----
In this video, we will install:
1. The backend for the database. Here, I will use Oracle SQL 21c Express, as it is free. You will need a 64-bit computer for this, but most modern computers are 64-bit.
2. The front that you can use. Here, I will install Oracle SQL Developer - again, for free.
3. Then we need to connect them together.
Want to learn Oracle SQL? Then why not look at my Oracle SQL Udemy course - rebrand.ly/ora...
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
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.
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.
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
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 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.
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 ?
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?
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
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==)
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.
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
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
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
Almost reached but it is not working at new connection please help me
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
Great video, I'm up and running. Thanks for the clear explanations!
A great teaching style made this video enjoyable, 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,after installing i couldnt find .xe extension any reason??
Hi User. Thank you for your question. Can you please be more specific. 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👍
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 you sir, i was able to install thanks to you
THANKS YOU
sir , iam getting the error at end of the oracle 21c express edition installation.
Thank you Sir, Very simple and good explanation
Thank you so much for this detailed video
I had a different port number, those having errors may want to check that
Thanks Sir 100% it works
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
Great video 👍
Can we use HR schema to practice ??
Wish i could give more than 1 like.
Can u please help me ,I'm getting error ..
Excellent video. Thank you
Keep up the good work
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!
tq so much sir... very useful🙏
Thank u
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
Thanks a lot so great Video
thank you for this.
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
u are the best
very helpfull, thank you
thanks very much sir
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
Thanks a lot
thanks
Please help me
Yes me also this error
How to set password
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