No video :(

How to Install Oracle Database 18c XE on Windows OS || Connect using SQL Plus and SQL Developer

Подписаться 4,4 тыс.

Просмотров 81 тыс.

50% 1

In this video you will learn how to install Oracle database 18c Express Edition (XE) on Windows 10, 8, 7 64 bit OS. Oracle database express edition (XE) is a free database provided by Oracle for learners and self training purpose.
Install, configure and start learning.
This video talks about:
1) How to download the Oracle database 18c XE and install on Windows OS.
2) Configure the database for plugable database (PDB).
3) Showcase how to connect to the 18c database using SQL Plus
4) Download and connect to the 18c database using Oracle SQL Developer.
Oracle 11g XE Installation Guide Video: • Oracle Database 11g XE...

Опубликовано:

26 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 215

@Myonlineedudotcom 2 года назад

If you are getting ORA-12541: TNS:no listener error, please check the listener status and what IP and port it is listening to by running the below command. It might be either the listener is not running or the localhost is not resolved correctly. lsnrctl status

@AymanSussy 2 года назад

What to do after that ?

@joelgeorge1064 2 года назад

After checking what should be the next step?

@naveenkumar9797 2 года назад

Showing invalid user name and pwd

@fathimak491 2 года назад

After typing select * from global_name; query , it shows SP2-0640 not connected What I do brother..

@thecrazyrandomkings 3 года назад

honestly you saved my life my professors guide to install oracle did not even work ive been spending hours on yt to troubleshoot but you are so helpfull im gonna share your video to my classmates thank you

@Myonlineedudotcom 3 года назад

You're very welcome!

@sitiasmahabdullah5821 3 года назад

I never left comment in utube..but u save my life..Thank you very much..May God Bless u

@Myonlineedudotcom 3 года назад

So nice of you ..thank you!

@thephoenix7435 3 года назад

This video is a lifesaver.. Everything we need in a single video. Thanks a lot for making something like this

@Myonlineedudotcom 3 года назад

You are welcome!

@PatrickChampion 2 года назад

This was very helpful, direct, simple, and stable. I tried installing earlier before using this and I messed up the listener somehow I connected to XE once before setting up the listener, but after trying the wrong way to setup the listener, and, I think rebooting, I couldn't connect at all. I had tried starting the oracle instance and service before doing the listener. What a mess. I tried then doing the listener the right way but the system was already messed up. SO.... I totally uninstalled Oracle and followed THESE instructions. Everything worked perfectly!! Thank you SO MUCH. Well presented. Patrick

@Myonlineedudotcom 2 года назад

Thank you! Glad that this video solved your problem.

@venkateswarlureddy8668 2 года назад

Very very thanks for you because I have been suffering for more days how to install this but i have seen more videos in RU-vid for that installation so far but nobody explain clearly but when I had seen your video, i solved my problem. 🙏🙏🙏🙏👍👍👍👍👍👍

@CalitranoN 2 года назад

This is the best video for setup... container db and pluggable.. is a different concept, than SQL server, so its important to know you have to create those as well...

@Myonlineedudotcom 2 года назад

Thanks

@Drkblaze484 3 года назад

i realy had problems with running oracle 18c because i missed many parts that nobody told me to configure... thanks alot man

@Myonlineedudotcom 3 года назад

You're welcome!

@lancebennett5366 3 года назад

You were a lifesaver. Thank you for this video. it got me up and running and taught me many things about Oracle DB setup.

@Myonlineedudotcom 3 года назад

Glad it helped

@ganapathynaikar1075 2 года назад

One of the best video 👌 try to install for past two day but after watch this video I installed the oracle successfully 😀 thanks alot.

@Myonlineedudotcom 2 года назад

Great 👍

@ajbufort 3 года назад

Thank you for this! Got me back up to speed after being away from the Oracle scene since 11g.

@Myonlineedudotcom 3 года назад

Glad we could help!

@marniharikrishna9435 3 года назад

Did oracle 11g is available now

@davehock7239 3 года назад

Had to do the steps mentioned by Tejas Deshmukh in the comments below plus a couple of other things but it all worked out! Thank you so much for posting this!!!

@Myonlineedudotcom 3 года назад

Great to know that the video was helpful. Also Thanks to Tejas Deshmukh for the steps mentioned.

@KrishanDhanda Год назад

Best explained Demo with lot of explainations and how to doit, and why it is soo. Thanks Man!!!

@dirantomas150 3 года назад

I was so lost the whole day by watching videos but then I found you🌼💛 you are great

@Myonlineedudotcom 3 года назад

Yay! Thank you!

@vladimirsimic7082 3 года назад

Me too :)

@vibhutisalvi 2 года назад

thank you .... working on oracle after 10 years....this was apt...

@Myonlineedudotcom 2 года назад

You're most welcome.. keep it up!

@Razor20131 2 года назад

thanks a lot for posting this tutorial. Only error I had was because instead of localhost had to type my ip address. All works great :)

@Myonlineedudotcom 2 года назад

Glad it helped .. if you mention localhost with your IP in the host file .. then localhost will work .. its good to have that entry in the host file

@xrayfish2020 3 года назад

This video is the nuts! Thank you very much very informative video I enjoyed watching this and installing oracle 18c and SQL developer well done keep these good videos coming

@Myonlineedudotcom 3 года назад

Glad it helped!

@anjanasathyan7974 3 года назад

Thank you so much for this video.. it's really helpful.. 😇🙏. Thank you. My request is could you plz upload more videos that explaing all the SQL operations and some real-time experiments using Oracle. It will be really helpful for beginners like me.. Thank you🙏

@Myonlineedudotcom 3 года назад

I will try my best ..Please subscribe to our channel to get such educational videos.

@ankurrathour7235 2 года назад

Wowwwwwww sir this is best video. What I was looking for. It has everything from scratch to end... 🙏🙏🙏🙏

@Myonlineedudotcom 2 года назад

So nice of you.. thanks!!

@interactmadhu 2 года назад

This video is really helpful. All required information is in one place. Thank you!

@Myonlineedudotcom 2 года назад

You're very welcome!

@magic.pencil2.0 2 года назад

This was soo useful video. Thank u sir for this grate session. I came to all about Oracle Database because of ur videos. Keep it up, we are waiting for other videos like this. THANK YOU sir!

@anaivanovic3647 2 года назад

Good job man, you saved my life tyyyyy!!!!

@anadragicevic141 2 года назад

Yaaaas!!! Mine toooo

@Myonlineedudotcom 2 года назад

You're welcome!!

@Myonlineedudotcom 2 года назад

Glad to hear that!

@nirvana124 3 года назад

I did not get this successful , please help @11:58, this is the error "Connecting...ORA-12541: TNS:no listener The test did not succeed. Some of the information you provided may be incorrect. Click Back to review the information provided for net service name, or Change Login to change username."

@Myonlineedudotcom 2 года назад

Can you please check the listener status and what IP and post it is listening to by running the command. It might be either the listener is not running or the localhost is not resolved correctly: lsnrctl status

@madanmangaonkar8623 3 года назад

Thank you sir very much 😍I was waiting for this detailed video.

@Myonlineedudotcom 3 года назад

Pleasure!

@michlef774 3 года назад

Thanks a lot , your video is very nice and explained to me everything to start

@Myonlineedudotcom 3 года назад

Glad to hear that

@ezlucifer 3 года назад

Thank u so much, sir! This video saved my life! Wonderful tutorial!

@Myonlineedudotcom 3 года назад

Glad to hear that!

@notatall1944 3 года назад

thank you you are more helpful than my teacher

@Myonlineedudotcom 3 года назад

Happy to help

@AlgorithmHQ Год назад

very very helpful thank you 🙌🙌

@sushantabhowmick1031 3 года назад

nice video sir ... i am serching more videos to set up oracle , but this video is awesome...

@Myonlineedudotcom 3 года назад

Thanks and welcome

@vinnielasagna 3 года назад

You may have saved my ass at my new job. We'll see when I try it at work tomorrow! haha

@Myonlineedudotcom 3 года назад

Glad that we could save something much worthy :-)

@pilafvibes9170 3 года назад

How much time it takes for installation?

@CalitranoN 3 года назад

It doesn't take the password! I would Gladly pay someone to get this to work, i have been doing it all day...not kidding!

@MrDave17jan 2 года назад

very helpful video, thank you very much. Sir, one thing i want to make sure is that HR_XE is not appearing on the left side of the screen which appears in your video..please help

@sudheerkumarreddy6447 2 года назад

I am not able to installed how you showed in video, I stuck on installing last 5 hrs its showing only creating oracle xe databse

@archananagaraj4054 3 года назад

Thank you so much for this video... Really it is very useful and I created oracle dBase successfully.

@Myonlineedudotcom 3 года назад

Most welcome 😊

@thegreatchase8610 3 года назад

thank you so much ,i really needed that keep it up bro

@Myonlineedudotcom 3 года назад

Glad to hear that it helped!

@IDontKnow-tc3iu 3 года назад

At 12:00 I get ORA-12541 : TNS:no listener error Please help me 🙏

@Myonlineedudotcom 2 года назад

@riteshyadav6084 2 года назад

Informative Video. Thanks for sharing.

@Myonlineedudotcom 2 года назад

My pleasure

@jameelsyed9045 3 года назад

Thanks a lot. It helped. Appreciate your effort.

@Myonlineedudotcom 3 года назад

Glad it helped

@indianputon814 3 года назад

One of the best videos on you tube i have a request bro can u make a video on windows 10 installation by free softwares

@Myonlineedudotcom 3 года назад

Thanks!!

@yamanshrivas3479 2 года назад

Life Saver !! Thank you so much❤

@Myonlineedudotcom 2 года назад

You're welcome!

@sireeshabhima3813 3 года назад

Very helpful video. Thank you.

@Myonlineedudotcom 3 года назад

You Welcome!

@ishikajain2314 2 года назад

Thanku great help

@krishnathamatam5488 3 года назад

Thank you so much, saviour..

@Myonlineedudotcom 3 года назад

Glad it helped!

@andysaun3276 3 года назад

Thank you very much. Very informative!

@Myonlineedudotcom 3 года назад

You're welcome!

@bekunozaru 2 года назад

Thank you so much! Very nice and informative video!)

@Myonlineedudotcom 2 года назад

You're very welcome!

@shadowsarena2616 2 года назад

When I'm trying run create table query then it will shown me an error : insufficient privileges What am I do to resolve that error

@lakshmanm2771 3 года назад

Thank You !! Its really helpful..

@Myonlineedudotcom 2 года назад

You are welcome!

@jaimejimenez4526 3 года назад

thank you very much this video have been very helpfull

@Myonlineedudotcom 3 года назад

Glad to hear that!

@siamimam2109 2 года назад

Great video brother

@Myonlineedudotcom 2 года назад

Much appreciated

@TimePass79020 2 года назад

Thanks alot bro.. it helpd me alot

@Myonlineedudotcom 2 года назад

Glad it helped

@dirantomas150 3 года назад

OMG tnnnnnxxx you sooooo much 😍😍😍

@davidjackson7675 3 года назад

Thanks that was very helpful.

@Myonlineedudotcom 3 года назад

Glad to hear it!

@dagdupatil38 2 года назад

Can I install the XE on windows home?

@danielnettey2850 2 года назад

I was not able to connect the SQL plus with the data source.

@JoJo-tc4cp 3 года назад

I am having problems with the test, I enter the username and the password correctly but the test always fails and if I ignore it I still can't connect to XEPDB1 in SQL Plus.

@azigtovmasian207 3 года назад

your video helped me sooooo much

@Myonlineedudotcom 3 года назад

Glad to hear that!

@gcfhornet 3 года назад

Great tutorial. Thanks a lot.

@Myonlineedudotcom 3 года назад

You are welcome!

@phamdung3268 3 года назад

thanks you so much, you saved my day.

@Myonlineedudotcom 3 года назад

Glad I could help!

@chakibbounoun2349 Год назад

THANK_YOU

@k.r.gagandeep6131 3 года назад

Thank you it helped me..

@Myonlineedudotcom 3 года назад

Glad to hear that

@bandinisaple6572 2 года назад

i'm getting this error -Connecting...ORA-12541: TNS:no listener please help me to solve this error

@Myonlineedudotcom 2 года назад

please check the pinned comment for resolution.

@itph1892 3 года назад

Thank you and GODBLESS

@Myonlineedudotcom 3 года назад

You Welcome

@Yash__Kumar. 2 года назад

How to synchronise both the oracle sql terminal with this developer application so that whenever I create some table in terminal I can view that in developers application also.

@Myonlineedudotcom 2 года назад

Its a client-server architecture .. if you create table using a particular client .. the table will be created in the server database ... and automatically sync with all clients

@dirantomas150 3 года назад

I'm so thankfullllll🌟🌟

@Myonlineedudotcom 3 года назад

Thanks!!

@ach952 2 года назад

Tx you sir

@Myonlineedudotcom 2 года назад

YW!

@sudheerkumarreddy6447 2 года назад

My system model was lenovo g50-70

@saidaaliyeva8930 3 года назад

THANK YOU VERY MUCH!

@Myonlineedudotcom 3 года назад

You're welcome!

@lakshmir6214 3 года назад

Really very useful

@Myonlineedudotcom 3 года назад

Glad to hear that

@dirantomas150 3 года назад

Ammmmaaazigggg video😍

@Myonlineedudotcom 3 года назад

Glad you liked it

@emersonsouza6020 3 года назад

I can't alter loggin - error 12541 ora...

@Myonlineedudotcom 3 года назад

Sorry, not sure what is the issue from your comment.

@CalitranoN 3 года назад

Oracle configuration assistant does not recognize the install password....

@maulanasidik7350 2 года назад

I'm getting error at 12:20 ORA-12154: TNS:could not resolve the connect identifier specified. I followed the steps before and created the net configuration again but still getting the error, how can I solve this?

@Myonlineedudotcom 2 года назад

Please check the listener status by running the below command and check host IP and post are correct: lsnrctl status

@sovanjan 3 года назад

Fantastic 😍

@Myonlineedudotcom 3 года назад

Thanks 🤗

@innovativeSP 2 года назад

How long does installation take?

@Myonlineedudotcom 2 года назад

More than an hour ..depending on the hardware of the PC

@danielnettey2850 2 года назад

My configuration didn't work.

@lovachittumuri 2 года назад

nice

@Myonlineedudotcom 2 года назад

Thanks

@lovachittumuri 2 года назад

good.

@Myonlineedudotcom 2 года назад

Thank you! Cheers!

@techtutoz5919 2 года назад

JAJHAKALLAH

@azigtovmasian207 3 года назад

tnxxxxxx a lot 🌼

@Myonlineedudotcom 3 года назад

Most welcome

@abdallahawainat9217 3 года назад

Thank u so much

@Myonlineedudotcom 3 года назад

Most welcome 😊

@santoshburada1657 3 года назад

Super bro....continue in the English or Telugu.😎😎🥳

@Myonlineedudotcom 3 года назад

Thank you!

@toan7224 3 года назад

Thank u so much

@Myonlineedudotcom 3 года назад

Glad it helped

@annourtahaabougrene3649 3 года назад

Good evening! my installation stops where there is the blue installation line. what do I have to do?

@Myonlineedudotcom 3 года назад

Please check if the hardware requirements meets the criteria

@subhamkumarbehera7759 3 года назад

After that xepdb1 setup , it shows me not connected but I have done in right way

@Myonlineedudotcom 3 года назад

Please check in the Net Config that XEPDB1 is there with proper host port and service name. Also password is case sensitive. Try again.

@CalitranoN 3 года назад

SQL plus gives me a TNS:protocol adapter error... this is in windows 10

@Myonlineedudotcom 3 года назад

My suggestion would be to follow the steps minutely as shown in the video. Many people have mentioned the steps work. I hope you are not missing any steps.

@maggiems1989 3 года назад

Hello, I'm getting error: TNS: destination host unreachable in SQL plus command prompt

@bhushanambhore8378 3 года назад

Have you solved this?

@sudheerkumarreddy6447 2 года назад

Can you help me

@asifaawan5945 3 года назад

where i can find the Application express and then SQL workshop in 18c

@Myonlineedudotcom 3 года назад

Did you check Oracle site?

@bhuvneshjangid9138 3 года назад

Please anyone tell me how long time it take for installation?

@Myonlineedudotcom 3 года назад

60min + depending on the hardware of the PC

@susmitha4735 3 года назад

At the end of the installation it was strucked sir and also it didn't show any error message also sir

@Myonlineedudotcom 3 года назад

Not sure what happened. Please try again.

@pilafvibes9170 3 года назад

How much time it will take to install sir?.. My Ram is 4gb

@Myonlineedudotcom 3 года назад

60min + depending on the hardware of the PC

@medjl6083 3 года назад

how to create your database oracle123

@MTahir-tn7tc 3 года назад

Actually i didn't notice my container and pluggable database information then how can i get that details again??

@Myonlineedudotcom 3 года назад

Same way as shown in the video.

@MTahir-tn7tc 3 года назад

@@Myonlineedudotcom ok and tnq

@ashwin7166 3 года назад

What will be the SYS and SYSDBA password in this setup ? Please suggest

@Myonlineedudotcom 3 года назад

SYS and SYSADMIN password is the same that you setup during installation. Please check the video once again specially after 4.30 mins.

@neerajXR 4 года назад

Hindi will be more favourable to understand for viewers. Keep Growing 👍

@Myonlineedudotcom 4 года назад

Thanks for your feedback.

@bigbossman3492 3 года назад

oh wow nice idea, what about the people who doesn't speak hindi ? don't be selfish

@nanoic2964 3 года назад

My net configuration assistant is tiny.

@Myonlineedudotcom 3 года назад

Not sure what do you mean by tiny

@nanoic2964 3 года назад

@@Myonlineedudotcom There's an issue with the scaling, the interface and text is very small.

@nanoic2964 3 года назад

I put up with it, fortunately SQL developer was not affected by this issue. I think it has something to do with me using a 4K monitor. Which video would you recommend for proceeding with learning Oracle Databases?