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

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

1898 ratings | 385038 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 (534)
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.
Anonymous Geek (3 months ago)
can I upgrade 10gxe to 11gxe without uninstalling the old one. Please assist
masthi maja (4 months ago)
Hii bro. After installing when i run the plsql program. I'm unable to get the output. Pls do a vedio on this.
Umar Baig (1 year ago)
you should mention this is video start 👌
Shubham Garg (18 hours ago)
can this connection can be made through sql command line?
Blank Mess (1 month ago)
am I getting it? In Oracle, every user is granted with its own single database. To create a database - create a new user through Oracle Application Express.
MyOnlineEdu.com (30 days ago)
You are correct in the sense that these are called schema
Md Muntazim (1 month ago)
nice tutorial.good work.keep going
MyOnlineEdu.com (30 days ago)
suriati Jamalludin (2 months ago)
tqvm for your informative video. maybe you may upgrade the sound record because its not clear enough
Prathamesh Sarode (2 months ago)
Thnx bro 😭😭😭 you helped me it tells to buy it , but you fucked them 🤣🤣🤣
Soumyajit De (3 months ago)
Thanks for the video.... Correct explanation
MyOnlineEdu.com (3 months ago)
You welcome!
Gaming Mania (3 months ago)
i have a question if i stop the database is it goin to delete the db?
MyOnlineEdu.com (3 months ago)
No. You will not be able access the DB. once you restart the Db service, you will be able to access it again. Nothing will be deleted.
Katrina Tandi (4 months ago)
NGP (4 months ago)
Very Very Thank you #Man.Have a great Day.
MyOnlineEdu.com (4 months ago)
You welcome! :-)
Subhendu Kumar Singh (4 months ago)
Thank you for given such type of information. i have a question. can i create new user by using this IDE? if yes, then please tell me how?
MyOnlineEdu.com (4 months ago)
Yes you can use the IDE to run CREATE USER command for user creation. But you have to login as SYS user to create another user.
TANMOY DEBNATH (5 months ago)
oracle database page is not opening
Jwel Ahmed (5 months ago)
thnx bro.your tutorial very helpful
Pradeep R (5 months ago)
I have installed oracle 11g R2 version and installed Informatica 9.6 .So can install this one with same SID name or different
mohit patel (5 months ago)
Thanks..buddy for help..
Ashish Gupta (6 months ago)
Thanks for the explanation. Q. If password is expired then how we can reset the password.
MyOnlineEdu.com (6 months ago)
alter user user_name identified by "new_password" replace "old_password" ;
technology maher (6 months ago)
How to download sql
Negan Barca (6 months ago)
I'm so fucking done with Indians, please can we go into WW3 and nuke them already?
Ravin prabhakar (6 months ago)
Hi,I want to create an institution store management system.In which store will accept the demands of machinery & tools equipment & buy & allot those to relevant dept.the head will approve & review them also whenever required.Is Oracle is best option to do so?
MyOnlineEdu.com (6 months ago)
Oracle, MySql and others are the options but the question is how much will be a data volume and transaction every day. If you think it is not going much higher, MySQL could be the better choice considering the cost come with Oracle DB. But yes, Oracle can handle most of the scenario.
udhayakumar venkatesan (6 months ago)
hi, can i work without internet or we can work online only? and i do not have credential to download from oracle site.how to download?
MyOnlineEdu.com (6 months ago)
Create a login in oracle.com and download the software. Since this installation is local, you can work offline but after the installation.
vrowmuria (7 months ago)
Thanks dear, it helped a lot to setup my Oracle Db and Oracle SQL Developer
MyOnlineEdu.com (6 months ago)
Great to know that! :-)
Antonio Banco (7 months ago)
Thank you buddy, very good tutorial.
Narendra Prasad (7 months 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 (7 months ago)
not connecting username /password?
MyOnlineEdu.com (7 months ago)
Please watch the video once more time .. you might be doing some mistake ..
Deb Pati (7 months 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 (7 months ago)
oracle express edition is no more available for windows on oracle site. can you upload it ?
el famoso (7 months ago)
@MyOnlineEdu.com xD that's exactly what my professor said, before he checked himself
MyOnlineEdu.com (7 months ago)
That should not be the case. Please check the oracle.com site properly
Akash {sky} Kumbhar (7 months ago)
Nice video
Akash {sky} Kumbhar (7 months ago)
Thank you sir
MyOnlineEdu.com (7 months ago)
You welcome :-)
Ravindra Chavhan (8 months ago)
thank you sooooo much
Evil Genius (8 months ago)
BRILLIANT..!!!!!!! you solved a problem that i was banging my head for from last 2 days..!!! thanks a tonne....!!!!!
MyOnlineEdu.com (7 months ago)
Glad to hear that .. YW!
Keitumetse Brian Mphasa (8 months ago)
My nigga, I love you!! Thanks a trillion
Chinmay Gawde (8 months ago)
Great video! Thanks a lot!
Ashwin Srinivas (8 months ago)
Amazing tutorial. Thanks for the video!! :) :)
सामना (8 months ago)
Thank you very much for this guide. Very thorough and insightful
Tato (8 months ago)
8:46 Get Started
Shua Rebello (8 months ago)
Thanks! Helped solve my issue.
Nilay Borsadiya (8 months 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ღ (8 months ago)
Thanks alot :) and congrats you got a subscriber lol
MyOnlineEdu.com (8 months ago)
You welcome and thanks for the subscription :-)
Mladen Gliševic (9 months ago)
Great video. Thanks
prateek shrivastava (9 months ago)
great job..... cleared all the doubts.
aiza khan (9 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 (9 months ago)
Very Well Explained..... Thanks for useful video....keep on uploading such videos
MyOnlineEdu.com (9 months ago)
Pleased to know that the video is useful... Please subscribe to get many such educational videos.
Ram parshad (9 months ago)
Is sorting possible in Oracle database 11g express edition??
MyOnlineEdu.com (9 months ago)
Sorting is part of the SQL queries. Yes sorting is possible using ORDER BY clause in Oracle 11g Express edition.
Farhan Khan (9 months ago)
thanku sir
shabnam sandhi (10 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 (9 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 (10 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 (9 months ago)
We are very glad to know that the video helped you a lot! Thanks for watching.
Sean N (10 months ago)
Great tutorial, still works perfectly for the newer versions of SQL Developer, thanx alot
MyOnlineEdu.com (10 months ago)
Nice to hear that... thanks
Soufiane Seaghi (10 months ago)
thank u
vasu v (10 months ago)
very very useful i searching this for last one year......... thanks bro
Malla Aravind (10 months ago)
For me, typing 'localhost:8080' in browser worked!!
ewomack (10 months ago)
Thanks! I'm up and connected on my local machine now. Clear explanation! Thanks again!
Ankit Kumar (11 months ago)
Thank you sir!! You helped me a lot.
MyOnlineEdu.com (11 months ago)
Glad to hear that!
Dharmangツ (11 months ago)
mine is stuck on configuring database ? :(
Dharmangツ (11 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 (11 months ago)
Details of the issue please
akash ingole techno_trend (11 months ago)
Oracle database connectivity https://youtu.be/yjJ7qooRRC4
Dinesh Kumar (11 months ago)
It worked perfectly , Thank you so much for the video tutorial
MyOnlineEdu.com (11 months ago)
Glad to hear that!
shubham choudhary (11 months ago)
thank you so mush sir.
MyOnlineEdu.com (11 months ago)
You welcome! Please subscribe to our channel to get more educational videos.
Month Ihnake (11 months ago)
thank u so much nice tut
Aruha (11 months ago)
Thank you!
Anusha Vemuri (1 year ago)
Thank you very much
Faraz Siddiqui (1 year 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.
Rinku Gautam (1 year 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 (1 year ago)
The best video. thanks
chalkomatas (1 year 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 (1 year ago)
Thanks a lot! I did it! But now I have a strange issue; Oracle webpage ( opens only when I disconnect LAN! Any ideas to fix that? I have already opened ports 8080 etc at windows firewall.
MyOnlineEdu.com (1 year 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 (1 year ago)
thank u very much. very helpful
pujitha divi (1 year 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 (1 year ago)
Thanks and glad to know the video was helpful. Please subscribe to our channel.
Noah Miller (1 year ago)
Hello, how to change password after expiration? Please help believe my password is invalid and needs to be updated
MyOnlineEdu.com (1 year ago)
Just reset the password. google it. SQL> connect /as sysdba SQL> alter user SYSYEM identified by "newpassword";
Taiyab Ansari (1 year ago)
Thanks a lot
Shaurya Kamune (1 year ago)
U are amazing ..Thank You so much ...
MyOnlineEdu.com (1 year ago)
You welcome. Please subscribe to our channel to get many such educational videos.
Navnit Ramteke (1 year ago)
Excellent Tutorial Thanks for the detailed explanation.
Shubham Rawat (1 year ago)
udhay cherry67 (1 year ago)
how to singout
MyOnlineEdu.com (1 year ago)
From where?
Noah Miller (1 year 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 (1 year 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 (1 year 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 (1 year 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 (1 year ago)
thank u so much ...
Nilesh Pawar (1 year ago)
Works fine...thx Bro...
mohammed andalossi (1 year ago)
thank you so much
Ashwin Carpenter (1 year ago)
Thank you so much for making this video. This helped me a lot. :)
Free Talk Poland (1 year ago)
I was worried I wouldn't understand, but you have a pretty good English accent for a guy from India.
Kingdom Foundation (1 year ago)
This video was so helpful to me, thanks a lot
Anil Kumar Gupta (1 year 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 (1 year ago)
Try first .. if not working check your hosts file in C:\Windows\System32\drivers\etc directory
Shambel Dessale (1 year ago)
very interesting video
Satyaki Bose (1 year 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 (1 year 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 (1 year ago)
Thank you so much Sir. Just a general query, is "SYSTEM" the default username for all Oracle databases?
Amalendu Kundu (1 year 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 (1 year 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 (1 year 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 (1 year 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 (1 year 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 (1 year 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 (1 year ago)
Start with SQL and PL/SQL ..this will help you to understand basics of DBMS
Antoine Malinur (1 year 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 (1 year 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 (1 year ago)
Thank you so much brother
Vikrant Dhumane (1 year ago)
Very helpful!!
ajay bharwal (1 year ago)
problem in loading oracle homepage pls help
muhammad WALID (1 year ago)
mastertoy85 (1 year ago)
Why oracle is so ugly ? It looks like from 1980 :/
MyOnlineEdu.com (1 year ago)
Well, enterprise softwares are like that .. Powerful softwares are inversely proportionate to their looks :-)
Marcin L (1 year ago)
MyOnlineEdu.com (1 year ago)
Welcome :-)
prasad rayudu (1 year ago)
Thank you very much!
Navneet Kumar (1 year ago)
nice ..very very nice sir...keep it up..
MyOnlineEdu.com (1 year ago)
You welcome!
Crainicul (1 year ago)
Thank you, bro)))
Nadhirah Zulkifli (1 year ago)
why it appears "windows cannot find http...."
MyOnlineEdu.com (1 year ago)
Please check the video once again .. the solution is provided ... you need to tweak the localhost information
Vikas Patgar (1 year ago)
Thank you sir. Very useful video
MyOnlineEdu.com (1 year ago)
Glad that it helped. Please subscribe.
Rasika Kedar (1 year ago)
Thank you sir

Would you like to comment?

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