How to Install Oracle Database 18c on Windows 10 by Manish Sharma

How to Install Oracle Database 18c on Windows 10 by Manish Sharma

What’s up Internet? I am Manish from and I
am back with another awesome Oracle Database tutorial. In this video we will learn how to install
Oracle Database 18c on Windows 10 64bit version. Before we start installing, I would suggest
you to watch this video till the end as Oracle has introduced many changes in the installation
process and I don’t want you to get stuck anywhere. Now let’s quickly see the minimum hardware
and operating system requirements for the installation of Oracle Database 18c. The installation of Oracle database 18c will
require a minimum 2 GB of RAM, 10GB empty space on your hard disk drive, a processor
based on either Intel EM64T or AMD64 Architecture and a minimum screen resolution of 1024×768
pixels. Also, similar to Oracle 12c, Oracle Database
18c is only available for 64 bit windows system, therefore you cannot install oracle 18c on
your machine if it is running a 32 bit Windows OS. Moreover, Oracle Database 18c is only available
for Windows 10 Professional, Enterprises and Education edition. Which means you cannot install Oracle 18c
if you are using Windows 10 Home edition. I’ll be installing Oracle Database 18c on
Windows 10 professional 64 bit version, but if you want to install it on Windows 7 or
8 then you can still follow these steps as the installation process is the same, but
first please check the compatibility. For your convenience I have listed down all
the Oracle 18c compatible operating systems in the corresponding blog. You can find its link in the description. That being said let’s jump straight to the
tutorial and learn how to install oracle database 18c on windows 10 pro 64 bit. To install Oracle 18c we have to download
the software which we can do by visiting the Oracle’s Website. So, go to now scroll down a little
bit and click this download button, after that you will be here on the download page. Here again scroll down a little bit and this
time click this database button. Now you will be presented with the database
section. Here click this Database 18c link. This will take you to another page from where
you can download the Oracle 18c. Oracle keeps on changing its website so I
will leave this direct download link for Oracle Database 18c in the description. Please check, anyways
Here first accept the license agreement and come to this Oracle Database 18c section. Here you can see that Oracle 18c is available
for Microsoft Windows, Linux and Oracle Solaris operating systems. But today we are installing it on Windows
10 thus will concentrate on the first link which is for Windows operating system. Unlike Oracle 11g or 12c this time we only
have to download one file for installing 18c. We can download it either by clicking this
“File 1” link or this “See All” link. I will go with the former option and click
this File 1 link to download the 18c on my Windows 10. Let’s click on this link “File 1”. To download the files you will need to sign
in to the oracle website. If you have a valid account on this site then
it’s well & good otherwise you can register yourself here and create an account which
is completely free of cost. After filling the username and password, as
soon as you hit the sign in the files will start downloading automatically. To save the time I have already downloaded
them. Here it is. As you can see the file is compressed and
zipped. To proceed ahead we need to extract its content. But wait. Do not extract now. There is a catch here. With Oracle 11g or 12c we were allowed to
set the location of our db_home directory. But starting with Oracle Database 18c we are
introduced to a new concept which is Image Based Installation. In image based installation the Oracle Universal
Installer of 18c takes the location of its setup.exe file and assigns it as its db_home
location. That is why before you start extracting the
content of this file, first decide where you want to create your db_home directory? I don’t want to create my db_home in the
download folder. No, Never. Rather I want my db_home directory to be in
my D drive, thus I will first create a folder inside D drive and name it DB_HOME. Let me quickly do it. Here I am in my D drive. Let’s create the folder. OK done. Here I have my db_home folder. Make sure the name of this folder must not
contain any spaces in between. Now I will extract the content of the file
which we just downloaded into this folder. Let’s do that. Here
I am going to fast forward the video as the content
which we are extracting here is about 10GB in size and this extraction process will take
some time. Here we are, we have successfully extracted
all the files and folders into our db_home and with that we are all set to start the
Oracle Database 18c installation. Let’s do that. Before we start the Oracle Database 18c installation
just check if you are logged into your windows with an Administrative user or not. If not then sign in to your windows with an
administrative user. It is a mandatory clause which you have to
follow, not doing so will cause mid installation error and crash the entire process. For your information, I am already logged
into my windows with the administrative user. Now let’s start the installation of Oracle
18c. First get into your db_home directory. I am already inside my db home. Here locate the setup.exe file. Here it is
right click on setup.exe and choose run as administrator. Screen 1: Configuration Options
Here we are presented with two installation options. The first one is to create and configure a
single instance database. Choosing this option will not only configure
an Oracle Database Server on your machine but also create a starter database for you. You can choose this database for learning
and practice purposes. The second option is “Setup software only”. As the name suggests, it will only configure
the Oracle Server software on your machine. No database will be created. You need to create the database manually using
DBCA utility. You choose this option, when you are configuring
a RAC or Planning to perform upgradation. I will choose the first option which will
configure the software as well as create a database for me. Let’s do that and press next to move ahead. Screen 2: System Classes
In this step you have to choose between Server Class and Desktop class. If you are installing this oracle database
18c on your laptop or desktop then go with the first option which is desktop class. If you are installing it on a server which
is capable of handling the load of all the server components and processes then choose
the 2nd option which is Server class. In my case I am installing Oracle database
18c on a windows 10 professional which is installed on my laptop thus I will choose
the first option which is desktop class and hit next. Screen 3: Oracle Home User
Oracle Server creates 13 Windows user groups for doing various tasks such as handling security,
taking care of user privileges and running Windows services for Oracle Database. To handle these groups Oracle server needs
a dedicated Windows User. That’s exactly what we will be configuring
in this step. As you can see, here we are provided with
four options. We can either use a Virtual Account, an Existing
windows user or Windows Built-In account. If none of these options suit you then you
can create a fresh Windows user right from this installer. In case you neither want to create a new user
nor want to use any built-in or existing user then you go for the first option which is
“Use Virtual Account”. For enhanced security Oracle recommends either
using Virtual Account or Standard Windows user instead of windows built-in account. Here I am going to create a new user which
will be completely dedicated to my Oracle Database 18c. To do so I have to choose the third option
which is “Create New Windows User”. I will name this user RebellionRider and the
password will be Oracle. Ok Done. Before we hit Next and move ahead, I just
want to share One More thing. There will be no Log on privileges for this
newly created user thus do not login to windows using this account. However you can manage this user like any
other windows user you have. Also, you cannot change this Oracle Home user
once the installation is done thus be careful while creating it. That being said let’s hit the button and
move ahead. Screen 4: Typical Installation. This step is very important as here we will
be configuring the installation settings. Let’s see what we have here. First, we have a drop down input field for
Oracle Base. Here we have to assign the location for Oracle
base directory. This will be the location where all your Oracle
software’s configuration files and directory like Oracle Home will be stored. Let’s see what options we have in this drop
down input field for us. Let’s set it to the one which says “D:appAdministrator”. If you want you can change this directory
location here. Let say I want change the directory name from
administrator to RebellionRider. See You can set whatever location you want
as your Oracle Base. Second we have software location. This is your DB_Home or say Oracle Home directory. It will hold all the necessary installation
files. Prior to 18c we were allowed to set this Oracle
Home location but now as you can see the location is already set and we cannot modify it. The installer took the location of the Setup
files and assigned it as the Oracle Home location. That’s the reason why we extracted our installation
files in a separate directory. As you can see here the installer has assigned
the location of that separate directory as Oracle Home for this installation. Third we have Database file location. Again, this directory will be located inside
the Oracle Base Directory. This folder will be storing your database
files such as Data files, redo log files, control files, server parameter files and
the password file. These are the most important files of Oracle
Database so never mess with them. I am good with this default location so I
will not change it. Fourth we have database edition drop down
list. There are two options here. First is Enterprise Edition and the second
is standard 2 edition. I will set this to Enterprise Edition. Fifth we have a drop down list for Character
Set. I am good with this default UNICOD standard
so I will not change it. Now, coming three fields, global database
name, password and Pluggable Database Name are the most important settings. You will be needing them in the future to
connect with your database. Thus I suggest you to write them down somewhere. Let’s see what these fields are. The Global Database Name will be the name
of your database as well as serve as your database SID. You will need this while making connection
with your database using tools such as SQL Developer. By default it is set as ORCL. If you want, you can change and give it any
other name, but make sure to remember it. I suggest you to write it down somewhere as
your Database SID. In the next two fields you have to give the
password. This will be the password of your administrative
user such as sys or system. Ok be careful here, write it down somewhere
or remember it. Let’s fill it up and move ahead. I will set Oracle as my password for this
demonstration. I may get a warning as my password is not
up to the Oracle standards which says a password must contain an uppercase, a lower case, a
numeric digit and a special character. Anyways, next Make sure to check the “create
as container database” checkbox. This option creates our database as container
database. In Oracle Database 12c a container database
can support maximum up to 252 pluggable databases. But, so far I am not able to find any such
numeric figure for Oracle database 18c. As soon as I’ll get any assuring figure
I will update you guys on my Facebook. Next is Pluggable database name. Here you have to specify a unique name for
your pluggable database. For this demonstration I am good with the
default name. With this we are done here now let’s hit
next and move ahead. As I said here we get the warning –You can
read this warning, if you want. Click yes and move ahead. Now OUI will check for the prerequisites such
as hardware compatibility. If everything goes well then we will be good
to install it. If there is any error then OUI will show you
here. Fortunately no errors! Now, hit this Install button and let the installation
of Oracle 18c begin. As Oracle Database 18c is a very hefty software
thus this installation will take some time depending on your hardware. Don’t go anywhere, there is one more thing
left in the end of this installation. But right now I will fast forward this installation,
just to save your time. Great, Installation is done, in this installation
we don’t get DBCA for database creation, like we used to with Oracle 12c or 11g. This new Oracle 18c Universal Installer has
simplified the process. The last thing which is left is to copy this
link. This is the link for the Enterprise manager
of Oracle Database 18c. Copy and save it. Now hit close and you have your Oracle Database
18c Installed on your machine. So that’s how we install Oracle Database
18c on Windows 10 64 bit. Please do read the corresponding blog. Link is in the description. If you like this video then please give it
a thumbs up and share it with your friends. Most importantly subscribe to the channel
if you haven’t already. This is how to install Oracle Database 18c
on windows 10 tutorial. Thanks for watching this is Manish from

Danny Hutson

54 thoughts on “How to Install Oracle Database 18c on Windows 10 by Manish Sharma

  1. Video timestamps
    00:26 – Minimum Hardware & Software Requirements
    02:04 – How to Download Oracle 18c
    04:14 – Pre-Installation Setup
    06:28 – Installing Oracle 18c
    16:35 – Enterprise Manager Link

  2. very good information for Oracle, but Problem is that old version Queries it will change Oracle forms and Oracle forms how to connected oracle 18C

  3. Bro make a video on mongo db and postgres db….. I m java programer i want to learn how to connect java program to these 2 db

  4. Hi,
    I was installing the database on my windows 10 pc and it stopped after 52% so i closed the installation and tried starting over again and this is the error i get. Any suggestions?

    [INS-35955] The Database software home (C:UsersDocumentsWINDOWS.X64_180000_db_home) is already registered in the central inventory. This tool can only be used in a non-registered Database home.

  5. I have a problem with my installation
    Fail to add useruser to %2% group
    and the installation stuck on creating and starting oracle instance
    wish answering fast

  6. Bro Its not getting installed: In " Typical Installation " It shows and error – ' [INS-30014] Unable to check whether the location specified is on CFS ' Bro please help me hot to fix this error and install the software please its a request. Hope you will reply soon. Thanks You!

  7. how to upgrade oracle 12c to oracle 18c can you make a video of that please
    and in that how can we unlock hr database for practice…

  8. HI Manish Sharma i have this problem
    INS-13001] Oracle Database is not supported on this operating system. Installer will not perform prerequisite checks on the system.
    although my laptop's:
    processor:Intel(R) core(TM) i5-7200 CPU @ 2.50GHz 2.71GHz
    ram: 8GB
    64 bit os,x64 based processor
    If i simply neglect this error then in typical Install configuration step i get
    '[INS-35180] Unable to check for available memory' this error and can't install
    can you please tell me the solution to fix the problem???
    thanks in advance

  9. Confused. Just been told by Oracle that 18c does work on Windows 10 Home. Can you confirm? In your vid you say it does not.

  10. I have a problem hardware requirements it shows Physical Memory is not enough. My system ram 4GB. what can I do sir. Please reply me

  11. Hi, Sir i am unable to run 18c set up file in windows 7 64 bit, after running set up file it is disappearing the command prompt, and no any error or log file is generated, even i checked the regedit , firewall and antivirus as well can you please help me

  12. Hi Manish, thanks for your support, my oracle 18c installation went flawless. Have you tried installing oracle apex 18.2 if so please share with us the same. Thanks.

  13. Sir,ihave installed db and 10.3.6 weblogic and 11gr2 Oracle forms and builders ,I used jdk everything thing is working fine but suddenly forms builder stops and show popup Oracle form designers has stopped working so to remove this should I have to use any patch or pls suggest appropriate step I am stucked last 4 weeks pls help me out sir ,Google didn't suggest any answer for 11gr2 .pls help me to resolve this sir

  14. Hi Manish

    I am getting the below error

    TNS:listener does not currently know of service requested in connect

    I checked the ora file and there also entries are added correctly.Not sure what is happening.

    Can you please help

  15. thank you very much, i was about to install this on my windows home computer, hopefully i found your video

  16. Hello Manish. I am getting this error "Failed to add WINNIEWinnie install user to %2% group" Can you please guide me on how I can resolve this issue and install the database on my pc?

  17. [INS-35179] Current available memory is less than the required available memory (1,597MB) for creating the database.

  18. yeah "fortunately no errors" but what if there are errors you ever think about that?? If it installed correctly i wouldnt be on youtube trying to look at installation videos. Its saying i need 8 gb ram which is obsurd considering their website states 2 and i only have 3.8 so now i cant install oracle. this is some bs all i wanna do is run queries jesus christ

  19. Hello Manish Sharma, I follow faithfully your videos and channel and I love them. I have a doubt: after having installed Oracle database 12c, I realize that my use of RAM increased in 3GB RAM. My RAM is 8GB of maximum capacity. Easily takes 6GB RAM of total use (+Operative System). Is this normal? Regards

  20. While installing the software, I missed the last step which is "finish". I don't know what to do now? Please help me out!

  21. this help me to install 18c; I used XE 18c for practice purpose. I want to configure mail service in XEPDB1. Pl explain.

  22. Hi there, first thnx 4 d video, second, i've seen some comment with my same problem and no answer… might be silly: It asks for 8gb physical memory and says actual is 3.9491GB, this would be RAM? otherwise i don't get why that number, i have a lot of free space in my HDsk.

Leave a Reply

Your email address will not be published. Required fields are marked *