How to install Oracle Database 21c Express Edition and SQL Developer on your computer - for FREE.

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..

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==)

THANKS YOU

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..

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 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

thank you for this.

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!

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

thanks

Great video, I'm up and running. Thanks for the clear explanations!

Thank you Sir, Very simple and good explanation

Thanks a lot so great Video

Excellent video. Thank you

Great video 👍
Can we use HR schema to practice ??

very helpfull, thank you

Thanks a lot for this kind of video. Now I am successfully installed oracle DB as well as sql developer.

u are the best

A great teaching style made this video enjoyable, thank you

Thanx a lot for this wonderful description. Really helped me to get into Sql with this vdo.

Keep up the good work

Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=mpX+AXmRRoON9tKG9PfBmA==)

Almost reached but it is not working at new connection please help me

Through your video I'm able to installed the oracle Database

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 ?

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==)

thanks very much sir

Hello Sir, Thank you very much for such a detailed video . Finally managed to install and connect the database

I was able to do SQL now. Thank you for this video!!

sir , iam getting the error at end of the oracle 21c express edition installation.

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.

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

How to set password

Status : Failure -Test failed: The Network Adapter could not establish the connection (CONNECTION_ID=jk+dVcYvRxuFYOtxvFYMTQ==) I have an error

Thank you so much for this detailed video

Wish i could give more than 1 like.

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?

Please help me

Sir when I am installing its showing rollback and please try again

tq so much sir... very useful🙏

I had a different port number, those having errors may want to check that

Can u please help me ,I'm getting error ..

Yes me also this error

I keep getting this error: Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=xzxwBzlCQ++Y71f0w/qxeg==)