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

[Music] [Applause] hello everyone welcome to my online edu.com video tutorial in today's tutorial we'll learn how to install oracle database 18c express edition into windows operating system so i have a windows 10 operating system but this will work to any windows 7 8 and 10 you know having 64-bit operating system okay so let's begin with how to installation uh process so first we'll be going to the oracle.com so once we go to oracle.com what we'll do is at the bottom of the page there is a resource for developers we'll click that okay and here you know under the technologies will click the databases so also from here you can click the databases okay any either of the things will work so and also later on this video what we'll try to do after installation will try to connect to the sql developer to the installed database okay so once we go there once we reach there so there will be a downloads part so we will click on the oracle database okay and here you know these are all the standard oracle uh versions so we'll be looking for the express edition so just in case who doesn't know anything about the oracle database express edition so let me tell you that express edition is given by oracle for the learners so i have a video on 11g express edition so people who don't want to you know use the latest version they can go to the lower version of 11g but remember one thing that from the 12c onwards the oracle has changed its architecture to multi-tenant and this multi-tenant architecture actually is available as an express edition in 18c so if you want to work on a multitude and then 18c express edition is the one that you have to use 11g is not multi-tenant so lots of architecture has changed from 11g so in my channel you will find find one video with 11g and this video is about 18c express edition so over here you know we got the this link that oracle database 18c express edition click on that so now you know this will actually ask you to download so basically you know if you click over here okay so it will actually download the whole uh the whole installation file so it will ask you to actually sign in so just sign in using your oracle credential so as you can see you know it is asking me to you know uh save save it somewhere so if you click ok you know it will ask you for the folder path and then you know so as you can see you know it's a 2gb database so for sake of time you know i already have you know downloaded it it's a 2gb installation zip file so let's do one thing uh let's let's go let's first extract it okay you know other thing that you know it has the installation guide as you as you can see so installation guide for windows let's click that and if you need any help you know you can get from here okay so it's always better to refer the documentation but okay but in this video actually i'll show you you know how to do that okay so one thing that you need to see that okay the requirements this is one important one so software requirements and the system requirements so these are the operating systems you know you can install it and also ram is minimum ram is 2gb and also it will take approximately 8.5 gigs you know for the oracle software plus two gigs for more for temporary storage so almost you know you can assume that it's 11 11 gb data space it's needed in your storage okay okay so that unzip process has finished so now you know there is a file called setup.exe just run as administrator click yes so it has started the preparing the installation of 18c express edition into my local windows operating system okay so click next so i accept click next so this is very important so you know it is actually getting installed into uh this particular folder so this is very important you need to remember this path okay so click next okay now it is asking for the password to to be you know for the sys that is his system and uh pdb admin accounts so let's enter the password as you know oracle one two three all small okay so actually you know actually in your case you have to set the password by your preference uh i mean and also you know this this is a password is case sensitive so you have to be very careful well while entering the password click next so now you know destination folder so this is the folder that initially you have choose and the oracle home this is one of the important part that this is your oracle home directory okay so and also this is the oracle base directory so now i'll click install so it will take some time to install so let's wait for the installation to finish okay guys since it is installing you know it will take some time so let us in the meantime download the you know oracle and the sql developer so sql developer is a tool to you know connect to your database so remotely it's a client tool basically you know it will it will connect to your oracle install database so go to technologies and go to database okay here you know under the tools you know you'll get oracle sql developer so go to there all right so click on the sql developer so here you know you will get the latest uh sql developer version so the windows 64-bit with you know jdk8 included so you if you do not have jdk installed basically then you can you know download this one or if you already have jdk installed then you may need you may do not want to you know in download this file rather you know this file because this is little bit you know you can see that you know it's almost 80 mb lesser space because it doesn't have the jdk so once you download this so then you need to give the jdk path but i since i do not have jdk installed so i'll download this one again you know i'll download that this thing so it will ask me to save if i accept to a file and then i'll ask here save here okay i'll pause the video for a moment uh to this installation to finish so the installation has completed and now you know it says that the database installed successfully now few things you need to notice here it says that multi-tenant container database and which is available at localhost port 1521 and pluggable database which is available at localhost 1521 at x e p d v one so what are these two things i'll tell you so since the architecture has changed from the 12c so uh you know here you know we'll have two kind of database one is the cdb called container database and one is the pdb called the pluggable database now in the container database we don't touch it we do our all development in the plugable database which is the pdb okay so that is what it is giving so by default you know uh i mean by default uh the oracle has given a pluggable database which is at xe pdb1 so that is the database so now let's click on the finish button and then i'll try to connect using first sql connect and then try to you know connect using the sql developer as i have shown you that i already have downloaded the sql developer from the oracle website click finish so nothing will happen here uh you know because the oracle has installed install it in the background so now so now if you come here you know so this is the one that got installed correct so now you have the sql plus let's connect using sql plus so we'll connect using system and then password is our oracle one two three so now you see here we got connected to our express edition right now if you but remember one thing that the one that we got connected here is the container database right but and also i told you that we do not do any development in the continent database so how do we know that which database we got connected so we'll write this query so from v dollar database as you can see here so what we'll do we'll run this query and you can see here that you know the database name is xe and the cdb this particular column is yes means it's a container database it's not a it's not a you know the plugable database so how do you connect to the plugin pluggable database so we'll write this command that connect system then our password password at the rate xepdb1 so now we are trying to connect to that xcpdb1 but remember one thing that xcpdb1 is not set up yet so we need to do some additional step to connect so our tns listener is actually trying to connect to our xepdb1 but you know this is not available so this is the step that you need to configure so we need to configure the net configuration assistant so come over here and then click here click yes if windows ask you for some permission now here you know we'll select the local net service name configuration and then click next and then we'll select the add click next now the service name we need to provide the service name so it will be xcpdb1 click next tcp fine and the host name is localhost now use the standard port 1521 now click next yes i want to perform a test click next then the login details change login now here you know you need to give the system and the password remember password is case sensitive now connecting text successful so click next now the net service name xcpdb1 i'll say yes no okay fine finished right so now here now if we try to connect using this one so you know we'll be connected to the xc pdb1 now how do we know that we are connected to xcpdb1 that is the that is the plugable database so we'll write this query select start from global name and here you know you see that the global name will be xc pdb1 if you are not if you are connected to the container database cdb then it will be xe okay so this is how you know you got configured to the plugable database and also you connect using the sql database so now if you write something some any useful query now you'll see that everything is working fine so now we'll go move ahead and try to connect using the sql developer okay so this is where the sql developer uh installation zip was downloaded and i have extracted it so this is the folder all right so now you know since that i have downloaded the jdk one so i don't need to do anything so jdk everything is here so just double click on this sql developer.exe okay so here we actually now will connect so click on the plus sign and then you you have to give a name to this particular connection so i'll give the name xc18c system okay and then give the username as system and the password is oracle123 and then you can save the password and now here in the localhost in the it will be localhost the hostname 1521 is fine but sid we cannot use the xc remember so this will be a service name so it will be xepdb1 let's test it so success i have successfully connected to this particular database i'll do connect so now you see here you know i got connected to this particular database right so now you know i can see all the tables here you know i can see all the tables and if i want if you want to see the packages you can do it here you can see the procedures you can see here right so basically you know what i'm trying to say is that we need to connect to the plugable database not the container database cdb we need to connect to the pdb so now you can write any queries like select sys date from dual now if you run it so you know it will give the today's day okay and also if you run something like you know the all tables run the query so it gives you know all the queries right so now you can create your own custom user here because you should not use the system uh one so let's try to see how you can create your own custom user and password and then we'll be connecting to using that particular user and user to to all your development right because system is not a good idea to you know use for your development so to create a user you know we need to uh write this command that create user this is my username it it can be anything that you can give identified by this is the password so always you need to you know when you connect to this user you have to give welcome one two three as a password so next run it so this is created so now we'll go and do one thing that you know now here again will be creating the connection right so again service name will be xc pdb1 test it okay let me save it so basically okay one thing that i i forgot to give the create session privilege so that's why the login is denied i need to give that privilege to this particular user okay so save it and then cancel it so we'll give the privilege okay so to give the grant you know i need to write these two comments that grant connect to my 18 and then grant create session to my mo18 let's run this grants command so the grant has been given so now let's open this particular connection which we create saved earlier go to properties and now test it so it's got success so mo 18 so now let's connect so now i am now i am connected using the moe18 now if i run any you know sql queries it will run over here now i am connected using my custom user and i i should you know try to develop you know whatever i want to in this custom user and you need to give the proper grants and privileges you know based on that but that is not the context of this video so i hope that this video is helpful and if you think that this video is helpful please click the like button subscribe to our youtube channel for to get the future such videos and then and also i'll request you to share this video with your friends so that it can be helpful for them too thank you for watching thank you very much

Channel: MyOnlineEdu.com

Views: 49,055

Rating: 4.9328537 out of 5

Keywords:

Id: gaelhF2us28

Length: 18min 37sec (1117 seconds)

Published: Mon Sep 14 2020