Oracle 19c Install On Windows Step By Step

hello all in this particular tutorial I'll be talking about how to install Oracle 19c database on Windows machine this particular tutorial is done on virtualbox 7.0 Windows Server 2022 data center Edition evaluation version and Oracle 19.3 or Oracle 19c now virtualbox 7.0 if you are doing it on your local machine like laptop or your but personal computer then you don't need to use virtualbox I am doing it in a virtual machine and hence I am using virtualbox virtualbox is a free software from Oracle the Oracle 19.3 or Oracle 19c again you can download it from the Oracle website however you need to set up your Oracle account using your existing email ID you don't need to create a new email ID for Oracle account you can use any of your existing email ID to set up your Oracle account the Windows Server 2022 data center Edition that's the Microsoft product it's an evaluation version Microsoft allows you to try the server Edition for 180 days and you you can just fill up a form and download the evaluation version the steps to get the oracles 19c running on Windows is first thing as I mentioned you'll have to download the Oracle 90c for Windows you'll have to create an oracle account if you do not have one once this software is downloaded you will be transferring that particular software to the windows Target server wherever you want to uh install the or the Oracle 19c you will transfer the software once you extract the software then you will find a utility called setup.exe in the extracted folder you will run that utility as administrator once this particular setup.exe is completed your Oracle installation is completed at this moment your Oracle installation is completed you do not have the database all that you did is you install the Oracle binaries or Oracle software next step is to create the listener using net CA then create the database using the dbca now if you do not create the Nets you if you do not create the listener using the net CA you can create the listener while running the dbca so the dbca will allow you to create the listener so the choice is yours whether you want to create the listener first and the database or while running the database creation you can create the listener once all of this is done when you run the dbca once your database is created now you you are ready to test you will use another utility cost SQL Developer it's a GUI application from Oracle it's a freely downloadable tool for the developers you will download that particular application and you will test the connectivity to your Oracle database now again you can use any of other application that works with Oracle database it's not mandatory to use SQL Developer however I'm using the SQL Developer now the net CA what is net CA I just wanted to mention net CA is Oracle net configuration assistant the way it works is npt this energy C A that's how the net CA and the dbca is for the database configuration system that's D of here B from here c and e a database configurations the net CA allows us to create listener and does the network configuration DBC allows us to create database drop database and allows us to modify the settings for the existing database so however we are going to use netca to create Lister dbca to create database we are not going to see the other functionalities now let's get on with our tutorial first thing that you need to do is download the Oracle 19c for Windows so open your favorite browser search for download Oracle 19c for Windows you'll get this particular link click on this you might if you have not already signed in you had to sign in if you have if you have sign in then you can click on this download button you you will say I reviewed and accept the Oracle license that's done and the download started now once that particular software is downloaded we need another software the SQL Developer so what we can say is we can say download SQL Developer so let's open another Tab and look for download SQL Developer click on it choose the jdk 11 if you have already the Java development kit installed you don't you can go for this particular software however if you do not have jdk installed then choose this particular software again click on this accept the license and download the software so that's the download is right now running once the software is downloaded The Next Step as I mentioned is transfer the software and extract it on the Windows Target server so let's wait for the download to complete so the downloads is completed I do not need this Firefox anymore now so let's close it and let's go to the I've already transferred the software to this particular machine so let's go to D drive and you can see I have already transfer that particular software so let's extract that particular software uh the I'm right now extracting the software so I'll give it a minute for the extract to finish where is my desktop yeah software is completely extracted now what I'm going to do is I'm I can I can delete this or if you want to keep it you can keep it I'm going to rename this to Oracle 19c home now the this becomes the Oracle home this directory becomes the Oracle home so you may make sure that you place it in the correct drive and with the correct name because this it can be changed but it's complicated to change so let's get things correct at this first place so this becomes the Oracle home under this this is the extracted file under this you will find a setup will run this particular setup as the as the administrator and this will launch this particular setup using this particular setup we can do two things we can either create the install the software and create the database so this is the first option create and it's install and create the database or we can just do the setup the software only if you choose this particular option then we have to specify multiple options we have to give multiple inputs so we will just set up the software and once the software is installed we can use the another utilities to create the database so we will in this particular now we'll just set up the software and we will create a database later so that all you if you want you can choose this there is no harm in choosing this both options are perfectly fine so click on next single stress yes we are okay with single enters Enterprise Edition based on what kind of license you have Enterprise Edition or SC2 choose the license click on next you can use the virtual account you can use the existing Windows user you can create a new windows user or you can use the windows building account I'll stick with you use Virtual account click on next the Oracle base so it has suggested that the Oracle base will be D app as you can say again it's you can change this it's not mandatory to go with Oracle recommendation whatever you want to set your Oracle base so the app Oracle base that's what I'm setting and now it's going to do the prerequisite checks and if all of the prerequisite checks are met then we are finally ready to install if we want to save the response file for next time to run it in the silent mode you can save it and click on the install and the Oracle software has started installing right now the Oracle software installation will not take much time it's going to take few seconds however I'll pause and come back once the software is installed the software as you can see the registration of Oracle database was successful so the software is completely installed so we are good with the installation so that's done we can successfully close this at this moment at this moment this software is installed you do not have any database you do not have any database remember that only thing that you have done is this software has installed now as I've mentioned in the document there are two ways now one we can create the listener again it is not mandatory to create the listener the dbca will allow us to create the listener we can use the net CA utility to create the listener we can use the dbca to create the database however there are other ways of doing that so if we launch the start menu you can here you can see that we have got something called net configuration system you can click on that and it will launch the the net CA net Oracle net configuration assistant it will launch what you can also do is you can actually launch the Windows command prompt so let me launch the Windows command prompt and type in net CA so let me clear the screen let me yeah and type net CA and it's going to exactly launch the same utility that we saw when we clicked here so either way is fine you can go here and click on this or you can launch the Windows command prompt and launch net CA so listener configuration click on next new listener add default listener name we can stick with default name that's fine protocols we can choose one or more protocols click on next default Port if you want to change it you can change it to say 1522 or whatever Port I'll stick with default Port click on next and that's it's if it's going to create the listener as you can see it has created The Listener and it's also going to start the listener so give it a minute so it's also going to start the listener so next and next and oh I wanted to say no okay so cancel this is done and okay so the listener is created now to create the database you can launch the database configuration assistant dbca dbca you can launch it from here or what you can do is the way we have done the net CA you can type dpca you can type the dbca and it's going to launch this particularly where we got where where using this particular utility we can create the database if you had existing database you can delete the database manage templates and other options are there we'll stick with create a database click on next and what is the database name so let's say rr19 and where you want to store the Deep database files where you want to store the fra what is the character code and what is the sys password sys and suspend password and whether you want to create a continent database and since I'll stick with non-container I'll give the password which is simply simple so password password so I'm giving the password is going to give us the warning saying that password does not meet the recommended standards we can change it at a later point and so that's fine I'm going to give simple password and later I'll change it not in this tutorial I so now what we are what I'm going to also do is I'm going to create I'm going to say where is my Oracle Aura data so I'll created a directory called all our data and where is my fra so I created a directory called fra now remember in production never place your FRA in the same drive as your aura data so let's not let's not do that is the production however this is the test system so this is all good so I'm going to change this to e-drive or our data and I'm going to change this to e Drive fra and that's all good and I'm going to say next and it gives us this warning admin password does not confirm and I we are aware and we can change it at a later point in time so that's fine and it gives us all of this summary and if we are okay if we are if you are fine with all of this review this one more time if you are fine with this if you want to save the response file you can save the DBC response file and if you are okay you can click the Finish now what I'm going to do is I'm not going to click the finish what I'm going to do is instead of giving for the typical configuration I'm going to choose the advanced configuration and why do I do that because Advanced configuration actually allows us to store allows us to specify more than more multiple options that we were not able to specify when we went in the typical configuration so now we can choose whether we want a DW data warehousing oltp database or custom database what kind of database so we this is not a rack so we are going with Oracle single instance database click on next the Sid and the database name so it allows us to specify the database name and Sid you can specify the Sid different than the global database name if you want to create a container database you can choose this and how many databases you pdbs you want to create you can choose that I'm going to stick with non-cdb arctic architecture here it allows us if you want to use omf you can use omf where you want to store your database files you drive other data use and it will create a folder called with a DB unique name which is order 19 so in under e Drive Aura data automatically a new folder called aura19 will get created click on next if you want fra where is the fra what is the size of fra click on next listener it and The Listener that we created the 1521 listener that we created using the net CA it has already selected that particular listener again it is not mandatory to create a listener the dbca will allow you to create a listener you can give any name here so whatever name you want to give and whatever Port you want to give you can do that or you can you can select the default list and I'm going to uh I'm going to choose this listener that we created click on next if you want to configure The Vault if you want to configure the label security if you you can do that click on next I'm not going to do that SGA and PGA so you can specify the SGS such as let's say 2048 and let's say 1024 which is basically and you can change the unit here so I'll say 2 GB and I'll say 1 GB of PGA sizing how many processes character sets you can change the character sets connection mode dedicated or share server sample schemas if you want to add sample schemas click on next all good click on next and then it asks us to whether you want to set up the EM database Express or registered em control and all of this whatever here everything can be changed like this PGA SGA it can be changed at a later point in time so it's not like this whatever you specify is not going to be the end of world you can change it at a later point in time so if you want to register your database with database Express or with the Enterprise Manager you can choose and provide those details click on next I'm not going to register it click on next this the password you can say use the same password for all accounts so sys and system it will use the same password it has it's pre-populated this is actually the one which I did in the typical configuration the password is password literally it gives us this warning again is it will give us this warning and I'm going to say oh yes and the reason why I'm going to say yes is because we can change it at a later point in time create database at this moment we are ready to create the database if you want to change some of the storage location where the control file will go what ah sorry what is the locations what is the maximum data files what is the where is the data files will go where is the redo log will go Etc if you want to change it you can change it and close and if if if you can see here everything is omf structure and if you want to if you don't want the omf structure you can could have very well said here under the storage option uh no no here I don't want to use omf that's also fine click on next next next all is good now yes and then now if I say sorry now if I say the where is my storage options so if I say custom storage options and now I can see where is my control file where is my data file etc etc it gives the name of all of this and now if I click next again the summary you if you want to review all of this summary you can review this if you are fine with this everything looks good to you then you can click on finish and once you click on the finish what would have happened here is under the RR data you can see automatically order 19 directory came and under this it will create system csox undo users and temp files it's going to create those data files and time file and that's going to take some time so what I'm going to do while it's happening because it's going to take literally it's going to take close to 10 to 12 minutes or maybe more based on how powerful your system is on my system it takes 10 to 12 minutes and I do not want to waste your time so and if you want to look at the DBC log what's currently happening you can look at the dbca logged and in few minutes the database alert log will also appear so you can look at what this particular utility is doing so if it's stuck somewhere you can look at those two logs to identify what's happening so right now the database is getting created and it's going to take some time so I'm going to pause the video and come back once the database is created as you can see the database is Crash is complete and if you want to change some passwords you can click on the password management I'm not going to do that and where is the SP file it gives the name of the database name the Oracle Sid and the location of SP file if all good if everything looks good you can close this at this moment our listener is up our database is also up so we have created The Listener we have created the database now if you want to connect to the database you will say uh you will set the variable so set Oracle Sid equals Ola 19 and let's say SQL plus adds this DBA if you want to connect a system where you'll say this and let's verify select name which should be order 19 comma open mode which should be read write from V dollar database and if everything is good then we can see that the database that we created is originated and is in the read write mode so all good now what we are going to do is we are going to do the remote connectivity test using the SQL Developer so I'm going to I'm going to launch I've already extracted the software it's it comes in this ZIP I've already extracted the software it's called SQL Developer so I'm going to launch that particular software let's wait for it to open it's a heavy software so it's it might take some time and what I'm going to do now is I am click on this plus button to set up your connection so click on the plus you can use the DNS names as well that's a different concept I'll not cover how the DNS names works if you'll give any name it can be any name whatever you want to give this is just the connection reference okay and I normally give it same as the name of the database so all our 19 again this is your choice username since we are connecting as this will give sys and it will give the password whatever is the sys password and remember if you are connecting as this try to use either sysdb or sys upper I'm going to choose DB sysdba and localhost here you can either give the IP address or the you can give the you can give the host name so I'll give the IP address 1521 is the default port and said that we had is Aura 19 that's the database that we created now what we can do is we can test in if everything is good it gives us this success and now I'm going to connect to this particular database and it opens up this particular worksheet and I'm going to run exactly same command that I run here so let me just copy it and paste it here and after I run it I'm going to get the same output all our 19 read right so that's all good now what I'll try to do is I'm going to try to create one table so let's do something let's first try to see if we have a table called m and we do not have any table called amp and if I run this particular query here as well we can see that there is no such table so now let me exit and let me clear and let me connect again and what I'll do is I'll create a table and I will do something okay so I did not give the column name so amp name yeah so let me create a table and commit ad that's done the table amp created commit completed now let's try to select and you can see that there is no record and let's insert and record called one rock so first employee in our organization is with id1 with name block let's commit it and now if I go to here if I run that particular query select star from amp table I should be able to now get the first employee called one rock now if I insert into that particular table so it doesn't matter from where we are inserting it doesn't matter because it's the same database so now if I the second employee which is tone in my organization and joined that's done I'm going to commit ad that's done I'm going to come here and now if I say select star from M I should have two employees the first employee is Rock the second Employee Store so all good now so we have successfully connect created a database we have successfully tested the connectivity using the SQL Developer and this connectivity is from my local laptop or local machine now the one I want before I end this particular tutorial I want to explain the concept of listen so if the listener is down nothing will happen to this connection this connection will work fine however no new connection can be made so I'll prove it to you so what I'm going to do is I'll launch one more command window and not the the SQL plus connections which are local they will work fine so let me launch one more command window and what I'll do is under this command window I'll just say lsnr CTL stop listener so I'm going to stop the listener and the okay I should have launched this as the as the administrator so let's run as admin CLS clear the screen series dot dot CD dot dot CLS let me put this in the middle and I'll say lsnr CTL stop listener and once this once this listener is down nothing let's say wait for this lesson to go down give it a minute the the command completed successfully so the now resistor is down now if I try to select from this particular table I can very well select that's all good if I want to insert a new record so let's say three and this time is Earth let's say Earth has joined so I'm going to insert one more record and if I now commit and if I say select then I should be able to see the third record so nothing happens to my existing connection now if I stop if I disconnect and if I now connect to this my connection will not work I won't be able to connect to my database you can see the network adapter could not establish the connection and the reason for that is the listener is stopped if the listener is stopped no new connection remote connections can be made to the database the local connection will still work so if I if I say SQL plus as 6 DBA I am still I'm I'm still connected so you can see I I can still connect and I can retrieve the record so select star from n so that's works fine so you can see my local connections are still working however my remote connections are no longer working and you can you saw that my remote connections are no longer working to fix this what we need to do is we need to start our listener so I'm going to say lsnr start listener and once that is done once listener has started so give it a minute for the listeners to start once the listener has started go back and the error that you are you are getting so the listener has started so now if I click OK and if if I say connect Now The Listener does not know currently no of the Sid so for whatever reason the listener is up but listener does not know the Sid so now what we can do is we can register our database so let's go as SQL class as sysdba and we will say alter system register let's do that that's done now if I go here and if I say connect I should be able to connect and now if I try to retrieve this record I should be able to get these three employees so the concept that I wanted to explain is if the listener is down if the listener is down the remote connections cannot be made the local connections will still work and nothing will happen to your existing connections existing connections will work fine only the new connections will not work I hope you found this particular tutorial useful in this particular tutorial we saw how to create how to install the Oracle 90c database on Windows and not only we install the software we also created the database we also tested the connectivity using the SQL Developer and we briefly understood the concept of listener I hope you found this particular tutorial useful I hope you like the content that I am uploading to my channel if you do like the content that I'm uploading my to my channel do subscribe to my channel and thank you for watching and see you in next tutorial bye bye

Channel: Database Guy

Views: 26,884

Keywords:

Id: W3r8shGn2mY

Length: 27min 36sec (1656 seconds)

Published: Tue Nov 01 2022