in this video we will look at how to install Oracle 11g on Windows operating system.
So let’s get started.
First we will download our Oracle 11g for that let me open my browser.
And here.
you have to search for oracle download.
And here in the first search result you will see this oracle database so just click on
it.
So once you click on it in next page you will see latest version of oracle.
So I can see 19.5 I can see 19.3 as well but when you scroll down here you will see this
oracle database express edition.
And inside that you can see Oracle database 11g Release 2 express edition for windows
64 . so just click on it so once you click on this one in next page you will see this
support for windows 64 bit Windows 32 bit and linux 64 bit.
So will be installing on windows 64 so I click on windows 64 bit . so in the next page you
have to login with your oracle account so if you don’t have oracle account so just
create one account but I already have my oracle account so I will be login with my oracle
account.so once you sign-in it will automatically download oracleXE for you.
And you say save file and say ok which will start download for you.
I think it will take a while and we will wait till the download is completed.
So our download is completed so let’s close this.
And go to download folder so here I can see this OracleXE file so which is zip file so
I have to unzip.
Right click on this one and extract here and go insdie disk1 and here you will see this
setup.exe so installation click on this one.
so my installation is started.
Let me minimize this.
So it says welcome to the installshield wizard for oracle database 11g express edition . and
click on this next.
And I accept the terms in the license agreement and click on next.
And here it will be installing this under c oraclexe so we will go with default setting
and if you want to change it you can change the path for installation but I go with default
and click on next.
And here I have to set password so I will set the password and again confirm the password
and say next.
And ay install.
Ya so this process will take a while now you can see this shortcut is created on my desktop
now it is creating and starting service for oracle database.
Now it started configuration for my database.
Now our installation process is completed.
So now click on finish.
So for starting database you just click on this shortcut . so you will get this error
so lets close this.
And go to this c drive.
And here we have oraclexe.
Go to app.
Go to oracle.
And go to products.
Go to eleven point two point zero . server . so here you see this get started shortcuts
. so just go to properties . and here you see this one.
So just change port with 8080.and say apply. and ok.
And lets close this. and not lets try again.
So our database is being opened in this web browser.
Now click on application express.
So here lets give users . so its SYS.
By default you will get sys user.
And set password.
And say login.
So here you have to create workspace . so for that database . let’s give some user
. so I say XE.
And I give user . what could be the user.
I say xe.
And password XE.
Password XE.
And say create workspace.
So it says successfully created workspace XE.
To begin Click here to login.
So I click on this one.
Here I can see this XE.
User name is XE.
Let me enter my password.
And say login.
So here I can see this home page of oracle.
And lets click on sql workbench.
So here lets click on this SQL commands.
And here you can write your query.
So I say select sysdate from dual.
And say run.
So here I can see this sysdate.
And lets go back to sql workbench.
So here you can this righthand side you see is create object.
So here you can create table, view, index, sequences all these.
So lets create on table.
So you can put this , you can use this wizard for creating the table.
Lets go back to sql workbench . now lets go to object browser.
So click on it.
And here you see all these tables which are part of my this schema.
So here I see this department, so if I click on department . I can see the columns.
And if I go to data.
I can see the data inside my this department.
Same way I go to employee.
So in employee I have few data.
So.
Lets query this employee data.
So go to workbench.
Go to sql command.
And say select * from emp.
And say run.
So I can see this select result.
So now will connect to oracle database using sql plus.
So I type sql.
And here I can see run sql command . so click on it.
So here for connecting database I say connect.
And give the database so I use XE.
And here enter the password.
So I connected to my database.
So I say select * from emp.
So I can see the result of select statement in sql plus.
That’s all for this oracle installation process.
I hope this video will help you to install oracle database on windows system.
Thank you for watching this video and see you in the next video.