and this video will look at how to download and install oracle 19c on windows system let's get
started so first we'll download oracle 19c so for that let's open our chrome browser
and here in the search bar search for oracle database
download so once you search for this one
in the first search result you will see this oracle database download so just click on it
so in the next page you will see the latest version of oracle so right now we can see oracle
uh 19c as a lattice wasn't so in case in future if oracle released a new database
so in that case probably this oracle 19c will be available uh somewhere here so here also you
can see this oracle 18c and 11g the older version of oracle so now let's scroll up
and here for this downloading article 19c here you can see this oracle solaris
and here you can see this microsoft windows 64-bit so we're gonna install on this windows 64-bit so
here we have the zip file so just click on it for downloading this article 19c so when you click on
this one you have to accept this oracle license agreement so check that and click on this download
so in the next page it will ask you to login into oracle account so if you don't have oracle account
so here you have this create oracle account so just click on it
so in the new tab you have to enter your email id password and then add the rest of the details
so once you fill up all the information and you just click on create the account
so that way you can create your oracle account so once so i already have my oracle account so let me
login with my oracle account so once you sign in automatically it will start the download for you
so here you can see this my download is already started so it's a big file so we'll take some time
so we wait till the download is completed and will resume this video after download is completed
so it's look like our download is completed so let's go to the download
folder and here you can see your uh downloaded file so now in the next step what you have to do
you have to copy this file and place somewhere you want to install so what happened when you
unzip this one it will have the exe file and you start your installation using that esv file
and your db home will be set as current directory so what we have to do just create one folder
inside the c directory and probably you can create some folder something like oracle
19c
and inside that uh let's let's copy this file so our downloaded zip file is copied so what
we did we copied this uh downloaded file from this download folder and created this
article 19c inside my c drive and pasted this zip file so now and in the next step
let's extract this file and say okay so our extraction process is completed so we'll take
almost five to ten minutes based on your windows configuration so now let's go inside this folder
and when you scroll down at somewhere bottom you will see this setup.exe files
so now let's start our installation process so for that just double click on this setup.txt
and say yes
so your installation process will start so it's look like we had some issue with uh
starting the installation so what i found is that the folder which you created if it has
any space it will create the problem so what i did is i removed the space and i made it the
the folder called oracle underscored 19c and now let's again start the installation
so now you can see the installation is started so it's launching this oracle database set of wizard
so in the first option it says create and configure a single instant database
or set up the software only so we'll go with the first one the default one and click on next so
here in the next option we have something called desktop class and service class so we
are installing our the normal office user laptop so we go with the desktop class and click on next
so here you have different option to you know create some windows account so here in the
first one you have this use virtual account then existing windows user create a new windows user so
all this uh account is used you know to sit down with the start your oracle service but we go with
this use windows buildings account so we don't need to bother about any other extra accounts
and uh click click the fourth one fourth one the last one and just simply click on the next
and yeah say continue yes so here these are the some options so the first one it says is
the base location so here let's drop down so here i think the by default it took this
where we unzip our uh zip files so that's why i we copied uh this zip file under oracle 19c
and then you have this database file location which is inside this
our db home folder then this database edition is go with the enterprise edition and all this win
then we have this global database name so by default it says orcs let's copy this the name so
we don't further make sure you copy or make a note of this so what is that it's a db name so i say
db name as oracle cl and then we have to set the password so let's go with the same one o r c
l o r orcl so we set the password as well so let's make note the password is o rcl and here
you have this pluggable database which is nothing but rcl pdb so pdb is this one and click on next
or maybe something wrong with this one o r c l o r c l and click on next
let's go with this yes
so this is checking the pre uh prerequisites for this article 193 now i think i'll show you
all the checks are completed and just hit the install so yeah so finally your
oracle 19c installation will start and yeah will take some time based on your
uh the system configuration and we will wait till this installation process completed
so right now if you look at the progress of this our setup so it is almost
57 percent completed and we can see this right now this oracle database configuration process is in
progress same time we can see this oracle database conf configuration assistance is also in progress
so yeah it's a quite heavy software which will take maybe 40 to 60 minutes based on your windows
system configuration so now our oracle database installation process is completed and here you can
see this url through which you can access your database so now let's make a node of this one
as well so let me copy this and put in our not so this is the url and just click on the close
now let's go to the url so for that let's open a chrome browser and here enter that url
and go to it once and proceed to local unzip
so now let's login into this oracle portal so for that the username by default you gonna use
the system and the password which we set file installation so this is our password
and the container container name just leave it to blank and click on login
so this is our database home where you can see some the chart and bars about your
database activities but i think i don't find it that much useful
so now we'll look at how you can connect to your oracle 19c database using sql developers so for
that i already downloaded sql developers so let me open my sql developer so here
by default we can see this some dns files which are detected by oracle sql developer
so now let's edit this orcl so for that right click on this one and go to properties
so here what we have to change we have to change the user so here we have
system user and the password is orcl which uh we set in this while installation
and say test so it says success and save it and let's connect and then say rcl
so we are connected to our overseal database so let's expand this so let's see what table we have
so these are the default table which comes with this one so let's see if we have any other table
maybe no other tables now let's run some sql so i say select this is date from dual
and just execute it so here we can see this one now let's create some table so create table then
tb1 then c1 worker 10 and let's execute this the table is created so let's refresh this
so if i scroll down here i can see my table tb1
so here it has column let's enter some data so i say i and let's commit this
now let's say select staff from tv one
so here i can see this high the the output of my select statement so this is how you can connect
to your this oracle 19c database using oracle sql developer so you can create your tables and all
and do a select or any any ddl operation on top of your tables yeah that's all for this oracle 19c
installation process so hope this video will help you to install oracle 19c on your windows system
and thank you for watching this video and see in the next video