HomeОбразованиеRelated VideosMore From: MyOnlineEdu.com

Oracle Database 11g XE (Express Edition) Install guide and connect with SQL Developer

1609 ratings | 332133 views
Welcome to MyOnlineEdu.com's video tutorial. In this video you will learn how to install Oracle Database 11g XE (Express Edition) and then connect the database using Oracle SQL Developer IDE tool. You can avail an instructor based live class from MyOnlineEdu.com. To enroll click the lick: https://www.myonlineedu.com/course/view/6/oracle-sql-and-plsql-11g-fundamentals
Html code for embedding videos on your blog
Text Comments (515)
MyOnlineEdu.com (1 year ago)
We have received 200K+ views. Thank you all for this over whelming support. This encourage us to work hard. Please subscribe to the channel.
Umar Baig (10 months ago)
you should mention this is video start 👌
Antonio Banco (4 days ago)
Thank you buddy, very good tutorial.
Narendra Prasad (8 days ago)
Hai i need to install oracle 11g 64bit enterprise edition in ubuntu 16.04 64 bit server. Could you prepare a vedio or share a link if you already prepared.
Pawan Kumar (8 days ago)
not connecting username /password?
MyOnlineEdu.com (8 days ago)
Please watch the video once more time .. you might be doing some mistake ..
Deb Pati (18 days ago)
I followed the video and everything worked as a charm. After that I restarted my system. Now I can connect to DB through sql command line. But the admin page: http://localhost:8080/apex/f?p=4950 doesn't open anymore. It stays frozen. And, I can't connect to the local db through sql developer. I see this in logs: ocr registry key SOFTWARE\Oracle\olr cannot be opened Plz help.
el famoso (21 days ago)
oracle express edition is no more available for windows on oracle site. can you upload it ?
el famoso (8 days ago)
+MyOnlineEdu.com xD that's exactly what my professor said, before he checked himself
MyOnlineEdu.com (8 days ago)
That should not be the case. Please check the oracle.com site properly
Akash {sky} Kumbhar (24 days ago)
Nice video
Akash {sky} Kumbhar (24 days ago)
Thank you sir
MyOnlineEdu.com (8 days ago)
You welcome :-)
Ravindra Chavhan (27 days ago)
thank you sooooo much
Evil Genius (29 days ago)
BRILLIANT..!!!!!!! you solved a problem that i was banging my head for from last 2 days..!!! thanks a tonne....!!!!!
MyOnlineEdu.com (8 days ago)
Glad to hear that .. YW!
My nigga, I love you!! Thanks a trillion
Chinmay Gawde (1 month ago)
Great video! Thanks a lot!
Ashwin Srinivas (1 month ago)
Amazing tutorial. Thanks for the video!! :) :)
Samana (1 month ago)
Thank you very much for this guide. Very thorough and insightful
Tato (1 month ago)
8:46 Get Started
Joshua Rebello (1 month ago)
Thanks! Helped solve my issue.
Nilay Borsadiya (1 month ago)
According to your video the 3rd step (where you select "database 11g express edition") and the 4th step (which contains username and password) was not came when I installed and oracle is not installed in my pc then what should I do?
Rukaiya Ănwarღ (1 month ago)
Thanks alot :) and congrats you got a subscriber lol
MyOnlineEdu.com (1 month ago)
You welcome and thanks for the subscription :-)
Mladen Gliševic (1 month ago)
Great video. Thanks
prateek shrivastava (2 months ago)
great job..... cleared all the doubts.
aiza khan (2 months ago)
Thanks a ton buddy!!! My sql developer is now working smoothly. I was struggling whole day finding the right video and voila your video is exactly what I needed. Once again, Thank you so much. You rock!!
aditi bhagat (2 months ago)
Very Well Explained..... Thanks for useful video....keep on uploading such videos
MyOnlineEdu.com (2 months ago)
Pleased to know that the video is useful... Please subscribe to get many such educational videos.
Ram parshad (2 months ago)
Is sorting possible in Oracle database 11g express edition??
MyOnlineEdu.com (2 months ago)
Sorting is part of the SQL queries. Yes sorting is possible using ORDER BY clause in Oracle 11g Express edition.
Farhan Khan (2 months ago)
thanku sir
shabnam sandhi (2 months ago)
Hello sir I wrote the localhost but it is showing that computer cannot find this device. What should I do now please suggest me😢
MyOnlineEdu.com (2 months ago)
First check the Oracle service is running from Windows task manager. After that check it is listening to 8080 port as mentioned in the video. You may watch the video again to write the complete URL with localhost:8080
Marcelo Batista (2 months ago)
Congratulations on your video, it helped me a lot because I was not getting a clear answer elsewhere. I was not able to do college classes because I could not do this procedure that you did in the video. Again thank you very much my friend, it helped me a lot.
MyOnlineEdu.com (2 months ago)
We are very glad to know that the video helped you a lot! Thanks for watching.
Sean N (3 months ago)
Great tutorial, still works perfectly for the newer versions of SQL Developer, thanx alot
MyOnlineEdu.com (3 months ago)
Nice to hear that... thanks
Soufiane Seaghi (3 months ago)
thank u
vasu v (3 months ago)
very very useful i searching this for last one year......... thanks bro
Malla Aravind (3 months ago)
For me, typing 'localhost:8080' in browser worked!!
ewomack (3 months ago)
Thanks! I'm up and connected on my local machine now. Clear explanation! Thanks again!
Ankit Kumar (3 months ago)
Thank you sir!! You helped me a lot.
MyOnlineEdu.com (3 months ago)
Glad to hear that!
Đhaяʍaηgツ (3 months ago)
mine is stuck on configuring database ? :(
Đhaяʍaηgツ (3 months ago)
MyOnlineEdu.com ahh nvm , what i did was clear data, registry, temp and all oracle folders and their associations, services and then reinstalled 👍 thbx
MyOnlineEdu.com (3 months ago)
Details of the issue please
Oracle database connectivity https://youtu.be/yjJ7qooRRC4
Dinesh Kumar (4 months ago)
It worked perfectly , Thank you so much for the video tutorial
MyOnlineEdu.com (4 months ago)
Glad to hear that!
shubham choudhary (4 months ago)
thank you so mush sir.
MyOnlineEdu.com (4 months ago)
You welcome! Please subscribe to our channel to get more educational videos.
Month Ihnake (4 months ago)
thank u so much nice tut
Aruha (4 months ago)
Thank you!
Anusha Vemuri (4 months ago)
Thank you very much
Faraz Siddiqui (4 months ago)
Hi, thank you for this amazing tutorial. Having installed my oracle, how can i develop a small application now? Is there a place where i can download the Oracle FORMS and connect oracle forms to this database? Many thanks again.
https://www.youtube.com/channel/UCs2q5zumLkUIPiCsE7HJtzQ
Rinku Gautam (5 months ago)
[SOLVED] Error ORA-12505 (ISSUE) I was getting "ORA-12505 TNS: listener does not know currently know of SID given in connect descriptor" error, while connecting to database using SQL Developer. (SOLUTION) Use "Service Name = XE" instead of "SID" to connect to Pluggable databases.
Alin Piero Javier (5 months ago)
The best video. thanks
chalkomatas (5 months ago)
I want to import excel data sheets into a database and use queries to export data from database. Which version of oracle should I download? Is the express edition ok? I should also use oracle sql developer for the queries? Or sql navigator?
chalkomatas (5 months ago)
Thanks a lot! I did it! But now I have a strange issue; Oracle webpage (127.0.0.1....) opens only when I disconnect LAN! Any ideas to fix that? I have already opened ports 8080 etc at windows firewall.
MyOnlineEdu.com (5 months ago)
You can export and import data from/into a database table by using SQL Developer. Also you can use PL/SQL procedure to do so but SQL Developer has no-code UI based approach which makes it easy. It does not matter for Oracle database version. You can use any client tool for your query (SQl Developer, TOAD, SQL plus) depending on you choice free/paid and convenience.
Sri Kanth (5 months ago)
thank u very much. very helpful
pujitha divi (5 months ago)
I am so glad to have your video sir, it was really helpful to me . just now i did,Thanks a lot sir.
MyOnlineEdu.com (5 months ago)
Thanks and glad to know the video was helpful. Please subscribe to our channel.
Noah Miller (5 months ago)
Hello, how to change password after expiration? Please help believe my password is invalid and needs to be updated
MyOnlineEdu.com (5 months ago)
Just reset the password. google it. SQL> connect /as sysdba SQL> alter user SYSYEM identified by "newpassword";
Taiyab Ansari (5 months ago)
Thanks a lot
Shaurya Kamune (6 months ago)
U are amazing ..Thank You so much ...
MyOnlineEdu.com (6 months ago)
You welcome. Please subscribe to our channel to get many such educational videos.
Navnit Ramteke (6 months ago)
Excellent Tutorial Thanks for the detailed explanation.
Shubham Rawat (6 months ago)
SQL> THANK YOU VERY MUCH 2 I HAVE BEEN TRYING SO MANY TIMES TO INSTALL THIS SOFTWARE BUT FAILED TO DO SO 3 AT LAST AFTER SEEING YOUR VIDEO TUTORIAL I WAS ABLE TO INSTALL THAT SOFTWARE 4 THANKS AGAIN !
udhay cherry67 (6 months ago)
how to singout
MyOnlineEdu.com (6 months ago)
From where?
Noah Miller (7 months ago)
Thank you very much for this video, I recently began a job where I must learn SQL with oracle database as a secondary responsibility. I successfully followed your steps, but I am left wondering how I would continue to make more databases through Oracle 11c express. Would I need to create a new workspace after putting in http://localhost:8080/apex/f?p=4950 in my browser? I put the internet shortcut for 'Get Started' from the oracle folder and saved a text file with the local host URL for quick access. After creating the database, do I connect it to SQL developer IDE same as shown in your video? Thank you for the help!!
MyOnlineEdu.com (7 months ago)
Google will be your best friend if you want to learn bits and pieces. We at MyOnlineEdu.com offer complete professional course on Oracle Database for beginners.
Noah Miller (7 months ago)
Thanks for the prompt reply! Does MyOnlineEdu.com have any instructional videos that showcase creating schemas and databases using commands? Or are there references to which you can point me? I am still a very early novice to all things SQL!
MyOnlineEdu.com (7 months ago)
Good to hear that the video worked for you. To answer your question, yes you need to create a workspace for each database you want to create. Also logged in as SYSTEM, you can create schema and database using SQL commands. Also you need to connect to each database through SQL developer as shown in the video.
Shilpa N (7 months ago)
thank u so much ...
Nilesh Pawar (7 months ago)
Works fine...thx Bro...
mohammed andalossi (7 months ago)
thank you so much
Ashwin Carpenter (7 months ago)
Thank you so much for making this video. This helped me a lot. :)
Free Talk Poland (7 months ago)
I was worried I wouldn't understand, but you have a pretty good English accent for a guy from India.
Kingdom Foundation (7 months ago)
This video was so helpful to me, thanks a lot
Anil Kumar Gupta (8 months ago)
While I am providing -- > http://localhost:8080/apex/f?p=4950 it's not loading the page showing error message --> This site can’t be reached localhost refused to connect. Could you please help me out?
Amalendu Kundu (8 months ago)
Try http://127.0.0.1:8080/apex/f?p=4950 first .. if not working check your hosts file in C:\Windows\System32\drivers\etc directory
Shambel Dessale (8 months ago)
very interesting video
Satyaki Bose (8 months ago)
When I try to start the SQL Developer, It asks for full name of the Java path. I tried entering the jdk path, but it did not work.
Amalendu Kundu (8 months ago)
Check the video .. I have used a lower version of SQL Developer which does not need JRE or JDK path .. In case you want the higher version of SQL developer, check google on how to resolve JRE path issue
Arkadyuti Paul (8 months ago)
Thank you so much Sir. Just a general query, is "SYSTEM" the default username for all Oracle databases?
Amalendu Kundu (8 months ago)
True but think about accidentally running a command which can harm your DB because SYSTEM has all the privileges. It is better to use a separate user just to avoid that kind of situation. Otherwise for practice and learning purpose, one user is okay.
Arkadyuti Paul (8 months ago)
Amalendu Kundu Thank you so much Sir. That means if only one person uses the machine, there's no harm in using SYSTEM.
Amalendu Kundu (8 months ago)
Yes SYSTEM is the default and comes for admin activity. It has full access and so it should not be used by all. Ideally the SYSTEM admin should create another user or schema and people should use it as shown in the video.
I specifically typed "Windows 10" This shit is a nightmare and worse than Vista! Windows has unnecessary Windows and features! If I wanted commercials, I would watch tv! But I cannot find how to freaking execute . SOme help me because this is now freaking 2 weeks and my assignments are OVER_______DUE! This website is in my textbook to install Wow you geniuses are not geniuses at all!
Rukhsar Ali (8 months ago)
Nice work!! Keep it up!
you have to open your mouth to speak and be understood:(
I don't mean to be mean, but I was relly trying to do my assignment and not fall behind and could not understand him. I am not racist, I just want plain English, but I am plaing it again, Thank you so much.
MyOnlineEdu.com (9 months ago)
Thanks for the feedback. Though many people has given positive feedback about the video and said it really helped them, we will keep a note about your feedback.
Ben Hine (9 months ago)
Thank you. I was not able to connect to anything with the Oracle instructions. Seems like they were outdated. All I wanted to do was program, not spend a day and a half trying to connect. This might sound idiotic, but I would like to get better with connecting to servers and jiving different applications and what not. Any suggestions for fundamental knowledge would be appreciated.
MyOnlineEdu.com (9 months ago)
Start with SQL and PL/SQL ..this will help you to understand basics of DBMS
Antoine Malinur (9 months ago)
Thank for your video ! when i try to connect " connect SYSTEM/oracle " i have a error : "ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0 Serial number: 0" i have already started my database and my password is oracle. Can you help me ?
MyOnlineEdu.com (9 months ago)
When are you getting this error? Are you able to login in Application express as shown in the video (9:00) using SYSTEM and password? Double check if Oracle process is running.
Rushan De Silva (9 months ago)
Thank you so much brother
Vikrant Dhumane (9 months ago)
Very helpful!!
Ajay bharwal (10 months ago)
problem in loading oracle homepage pls help
muhammad WALID (10 months ago)
THANKS :)
mastertoy85 (10 months ago)
Why oracle is so ugly ? It looks like from 1980 :/
MyOnlineEdu.com (10 months ago)
Well, enterprise softwares are like that .. Powerful softwares are inversely proportionate to their looks :-)
Marcin L (10 months ago)
thanks
MyOnlineEdu.com (10 months ago)
Welcome :-)
prasad rayudu (10 months ago)
Thank you very much!
Navneet Kumar (10 months ago)
nice ..very very nice sir...keep it up..
MyOnlineEdu.com (10 months ago)
You welcome!
Crainicul (10 months ago)
Thank you, bro)))
Nadhirah Zulkifli (10 months ago)
why it appears "windows cannot find http...."
MyOnlineEdu.com (10 months ago)
Please check the video once again .. the solution is provided ... you need to tweak the localhost information
Vikas Patgar (10 months ago)
Thank you sir. Very useful video
MyOnlineEdu.com (10 months ago)
Glad that it helped. Please subscribe.
Rasika Kedar (11 months ago)
Thank you sir
Aniket Ambre (11 months ago)
tons of thanks sir...!!!
Ionita Diana (11 months ago)
Thank you !!!!
'Mualle Mats'ela (11 months ago)
thank you
Junaid Ahmed (11 months ago)
how to create a DB or it will be created automatically when create a new user in dbms, also tell us about schema
MyOnlineEdu.com (11 months ago)
In oracle world the schema name is the database for you ... each schema can hold the Table, view, package objects. Yes when you create a user, the schema is created for it. If you watch the video the MYONLINEEDU schema is created when we have created the user.
Junaid Ahmed (11 months ago)
good one
Ravi Kakustam (11 months ago)
Thank you so much Bro!
Jnglobal Solutions (11 months ago)
Thanks. Required information.. https://goo.gl/6e7K2o
Sergio González (1 year ago)
¡Muchas gracias! me has salvado :D THANK YOU VERY MUCH!
Rabaa Rd (1 year ago)
thank you so much
Cooper Zagu (1 year ago)
Thanks man!
Elijah Wilson (1 year ago)
You rock man!
MyOnlineEdu.com (1 year ago)
Thanks :-)
kuldeep t (1 year ago)
Dear Sir, Thank You very much. This tutorial helped me.
kuldeep t (1 year ago)
please share your contact no. and is this the same way to connect everyday?
MyOnlineEdu.com (1 year ago)
Thank you! :-)
Vishwas SiddeGowda (1 year ago)
Thank you.
MyOnlineEdu.com (1 year ago)
You welcome!
Hitesh Rathore (1 year ago)
Thanks a lot. I was using @ in password, it was not working.
shivam gupta (1 year ago)
If I want to start my express edition after complete installation, do I again have to follow all tha procedures? Or is there any other alternative?
shivam gupta (1 year ago)
Okay thanks...
Amalendu Kundu (1 year ago)
Once Oracle XE is installed, you don't have to install it again. What you have to do is make sure the database is running and open SQL Plus or SQL Developer to resume your work.
togrul aliyev (1 year ago)
THANKS! Useful information
shaneleerosario (1 year ago)
Thanks man. I learned more from this video than google searching for help.
MyOnlineEdu.com (1 year ago)
Your comment made our day! Please don't forget to press subscribe button. Have a good day!
retrosuff (1 year ago)
Thank you. You are a life saver.
MyOnlineEdu.com (1 year ago)
You welcome .. Please subscribe to get such educational videos :-)
Eden Roth (1 year ago)
Hi, i followed all your steps but when i connect to the oracle by using this command: connect sys/sys as sysdba; I got the message that : connected to an idle instance. from what I understand is the database isn't connected yet. I tried the following command also: shutdown and then startup again. but I got this message : ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [kspifisp:ksfdread_resilver], [0x0060E98A8], [0x0060E9600], [512], [], [], [], [], [], [], [], [] Could you or anyone here help me please? Additional info: my laptop is running Windows 10 pro and full loaded with visual studio (maybe they get conflict? I don know) It is a bootcamp windows 10 pro running on Mac. (Maybe this is the problem? I don know)
MyOnlineEdu.com (1 year ago)
You need to connect in SYSTEM schema and the password choosen ..for example as shown n the video connect SYSTEM/<pass> ... SYS is most probably not active ... i have to check that ... but try SYSTEM schema
Mon Lopez (1 year ago)
Hello Sir! I received an error message "ORA-12505, TNS:listener does not currently know of SID given" after testing the new connection. Can you help me on this?
Mon Lopez (1 year ago)
I followed the steps on your video. Right now, I tried to bring my laptop and bring it at the office to try again. But unfortunately, I cannot connect to 127.0.0.1 when clicking on Get Started T T
MyOnlineEdu.com (1 year ago)
make sure the database is running .. are you able to connect using SQL Plus? .. assuming you have followed the steps shown in the video correctly, give the correct SID.

Would you like to comment?

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