Installing Oracle 12c in Windows 10

2 Hi, My name is Sam Dhanasekaran and welcome to this Oracle Database lessons video series. In this video let us take a look into installing Oracle 12 in Windows 10. So go to Oracle.com. And go to downloads. Click Oracle, download Oracle Database 12c now. 8 Ok. I'm going to download this one which is Microsoft Windows 64 bit, Release 12.1.0.2 10 Accept the license agreement and then click this one again accept the license agreement and 16 click this 18 If you haven't registered you would like to register here. 21 and that would download the zip file 23 Ok. Since it has been downloaded let me go and download the next file. 25 It is downloading the next one. 27 OK. I have downloaded both the files. They are of compressed format. So we need to uncompress them. So just do a right click on the file 1 of 2 and choose "Extract All" and it will prompt you a location where you need to extract those files. Ok. And I am going to..this is very important. I am going to extract both the files into same location. So I don't want this 1 of 2 or those things. I am just going to extract them to Winx64_12102. 37 So the extraction of first file is complete. So let me extract the second one. Right Click. Extract All Important thing is, it has to be extracted in the same location as the first one. Ok. It's extracting. 45 So we have extracted both the files in this location, which is Winx64_12102. Let's go to that location and go to..go inside. There will be a folder called database and let's open that and there is a file called Setup.exe. Let's run it. This is.. this will invoke the installer. 50 Ok. It is starting Oracle Universal Installer. You will briefly see this command window.The first option is to configure Security updates. This is the screen where you will give your email address or if you have already subscribed Oracle Support, you would give the username and password so that you will receive information about security patches and updates. Ok. So I am going to skip this. Click Next. And it is going to complain about that. This is basically for educational purpose, right?. So we can skip it. 59 In the next screen we are presented with three options. One is 'Create and configure a database', the next one is 'Install database software only', the third one is ' Upgrade an existing database'. Let me begin with the second one. 'Install database software only'. What this means is it will install just the database software and it will do nothing after that. Meaning that if you want to install just the software and create the database later, we can choose this option. 66 Even if we do this at some point of time, when we are ready to create a database, we can do that by invoking DBCA, which is Database Configuration Assistant, which will be part this database software. And this first option, which is 'Create and configure a database' is nothing but the second option plus the DBCA which I just mentioned. Basically it will install the software and invoke DBCA for us to create a database. The third one is to upgrade an existing database. If we already have a database and if we want to upgrade that then we use this option. click next Ok. Let me go back and I have chosen Create and Configure a Database, meaning that I want to install the database software as well as I want to create a database. Click Next. So in this screen we are presented with two options. One is do we want to choose Desktop Class configuration parameters or Server Class configuration parameters. Since this is for educational purpose and I am installing Oracle in a Windows desktop I am going to choose Desktop Class. Ok. So in this screen it is asking, when Oracle runs, who should be the owner of that process. So in a multiuser operating system like Windows or UNIX, Linux any process that's running or any software that has been installed has to be owned by some user, first of all. And when it runs, that instance of that software, which is running the memory has, again has to be owned by some user. Ok? So here Oracle is asking, do you want to run the Oracle process as an existing windows user. Ok. If yes give the windows username and password. So whenever Oracle runs, it will run as this user. Or do you want to create a new Windows user for it? Ok. I am going to go with the old method which is just use windows built-in account as I am using this only for educational purpose but definitely Oracle is going to complain about that. Ok. I'm still going to continue with that. In this screen we need to choose various options and let me explain one by one. Oracle-base Oracle-base is a folder which serves as a base for any Oracle software installation in this machine. By default it would be c:\app\sam in this Windows box. The term Sam comes from the name of the OS User. So in this Windows box, which is my Windows Desktop, I have an OS user called sam and I logged in using that user. So by default it gives me an option c:\app\ \ the OS user, which would be sam. And that serves as a Oracle-base. Next is the software location. Remember, I am installing database. The software for the database goes into Oracle-base which is c:\app\sam\product\12.1.0\dbhome_1 The c:\app\sam is the Oracle-base. And then beneath that it creates a folder called product and then the version 12.1.0 and then database home underscore 1, the first home meaning that I can install same software in another home also. Next is the database file location. Remember, we are creating a database right? So the data files have to go somewhere. Obviously it will go into a folder called oradata under Oracle-base c:\app\sam, which is Oracle-base and then \ oradata. And choose, leave the default value for this database edition, Enterprise Edition and Character Set, I am going to change it to Unicode, you can keep it whatever you want, because this is just going to be a training system and the global database name I am going to keep it just demodb.home Ok. And I am going to give a three character password and I am sure it is going to complain about the password Disable Container Database. We don't need it for this course. 132 Click Next. It is going to complain about the password. So, right now it is doing prerequisite checks. Ok. So we are presented with this summary screen and everything looks fine. So I am going to click Install. 140 So once that completes, it will start the creation of database and you will get a screen like this. 143 So after a while, once it is done, it is going to give an output like this saying that the database has been configured and it will also give a URL where the database's Enterprise Manager Database Express location will be there. We will talk about this later. So, click Ok. And we are done. So now, let's connect to it. Go to the Run menu in Start and type cmd to get to the command prompt. 152 Now set ORACLE_SID=demodb to make sure if it has been set properly just do a echo %ORACLE_SID%. It has been set to demodb. Set the ORACLE_HOME to this one, where we installed the Oracle Database Software and let's just make sure the value has been set properly Ok. Now do this. sqlplus /nolog connect / as sysdba We are connected. select name from v$database; We are in. Ok. So that's how you installed Oracle Database in Windows 10. Thank you.