Are you planning to install Oracle 19c on Windows Server or Windows 10? Then this step by step guide is for you.
The installation of Oracle Software is not always an obvious operation, as it is the case for many DBMS (SQL Server, MySQL, etc.). The steps are however simple, but If you read Oracle documentation, more than 190 pages, you can get lost pretty quickly. There is a lot of information.
In this guide, I’ll simplify theses processes for you. I’ll show you the key steps to successfully install Oracle 19c on Windows, from the first attempt. Upon completion of this installation, all of the components required to create and administer a database in Oracle Database 19c will be available. You can also download my ebook which details the whole installation process.
So I assume that you already have your Windows server set up and running. To avoid issues during the installation process, make sure your environment meets Oracle 19c installation requirements.
Related: Install Oracle Database 19c Client on Windows Step by Step.
Install Oracle Database 19c on Windows step by step
1. Download Oracle Database 19c software for Windows
Our first step is to get the Oracle 19c software for Windows from the official Oracle download page. On this page you will find many packages. In this guide, we will focus on the Oracle Database 19c (19.3) for Microsoft Windows x64 (64-bit) package. If you want to access your future Oracle database remotely, you can also download the Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit) or Oracle Database 19c Client (19.3) for Microsoft Windows (32- bit) according to the architecture of the client computer.
Downloading Oracle 19c software is free, however to use it in the production environment requires a license. Note also that downloading requires an Oracle account.
2. Launch the setup wizard
Once the download is complete
- unzip the package then copy it to the root of your disk;
- rename the folder, choose a shorter name (eg. db_home);
- then launch the setup.
Note: the installation wizard may take several minutes to open. So be patient.
3. Choose database installation options
This step is very important. It allows you to choose the database installation options. You can install Oracle software and create a database at the same time (Create and configure a single instance database).Since we only want to install the Oracle 19c software and its components, we will opt for “Set up Software Only”. This option installs the essential components for creating and administering a database. You can also use it to upgrade an older version of Oracle (example: 12c or 18c) or install RAC.
4. Select database installation type
The first option allows you to install a single instance database on your server. Oracle Database with the Oracle Real Application Clusters (RAC) option allows multiple instances running on different servers to access the same physical database stored on shared storage.As we want to install Oracle 19c on a single server, we select option 1.
You can create a database after installation by using Oracle Database Configuration Assistant (Oracle DBCA).
5. Choose database edition
The version of the database to install depends on your needs. For an application developer or and medium-size companies, the standard version covers practically all needs.To take full advantage of Oracle 19c, you can install the Enterprise version. Obviously, the Enterprise version requires more resources (storage, RAM, CPU).
6. Specify Oracle home user
During Oracle Database installation, you can specify an optional Oracle home user associated with the Oracle home. Oracle home user can be a Windows built-in account (LocalSystem for Server and LocalService for Client), virtual account, or a regular (not an administrator) Windows account. If you specify an existing user as the Oracle home user, then the Windows user account you specify can either be a Windows domain user or a Windows local user.
A Windows user account need not be created by the administrator if a virtual account or a Windows built-in account is used during installation. If you specify a non-existing user as the Oracle home user, then the Windows user account you specify must be a Windows local user. The installer creates this account automatically to run the Windows services for the Oracle home. Do not log in using this account to perform administrative tasks.
7. Specify the location of Oracle software
In a default Windows installation, the Oracle base directory appears as follows: DRIVE_LETTER:\app\username where username is the Oracle installation user if you choose Windows built-in account, else it is the Oracle Home user (standard Windows user account). You can change this directory at your convenience or leave it as default.
8. Minimum requirements checks, summary and end of the installation
After these initial phases of configuration, let’s check the installation prerequisites. If, however, there are errors, try to readjust the minimum installation requirements and start again.
Click install if no error occurs.
That’s it. You can close the installation wizard now.
You can take a look at the different components of your installation from the Windows start menu.
Still having trouble installing Oracle 19c on Windows? Download the compete guide!
Next step : Create a Database in Oracle 19c on Windows
How do we connect to this server with Sql Developer?
Please, find the complete guide here : Configure & Connect SQL Developer to Oracle Database
Sir. Whenever i open sql plus it get open for a milliseconds and suddenly getting closed
Soo what is tha issue with it
Hi Ashwin,
Some OS packages might be missing. Try to update your OS or open a terminal and run “sqlplus” to see if that works.
Is there any sign in is needed. How to install we don’t understand.
Hi S. Baba, could you tell me what part you didn’t understand?
Good One
Happy you find it useful. Thanks!
Is it possible to install 19c 32 bit to Windows 10 64 bit?
When I tried it, the setup opens a black screen and closes it in a split second and nothing happens.
Hi Madhan,
Make sure your operating system is updated. Also, rename the installation folder to something simple, with no special character (ie. dbhome)
how To connect my Oracle Database remotely?
Hi Lutvi,
You need to install and configure Oracle Database Client. You’ll find the necessary steps in this guide.
Regards,
Hi Alekciss,
Do i have to install “Install Oracle Database 19c on Windows: Complete Guide” first then install “install and configure Oracle Database Client.”?
Hi Lutvi,
It is recommended to install and configure the database first before installing the client. So, you can start with Oracle software installation and database creation. Once your database is running smoothly on the server, you can install and configure the client to manage it remotely.
Hi AlekCiss,
Thanks for your advice
My pleasure!
First one is “Desktop Class” – You choose this option when you are installing Oracle Database on your desktop or laptop. Because this option will perform the basic installation of Oracle on your system.
There must be spaces in the path of your installation folder. Choose a path without any space.
You can select “Desktop Class” option if you are installing the Oracle Software on a laptop or desktop class system. Server Class option will let you install Oracle on a server class system, such as when deploying Oracle in a production data center.
in microsoft settings go to devolopers setting there u give allow access then run setup
I had followed these steps and installed/configured Oracle 19c Database in my system as of Dec, 2021. I have Windows 10 Enterprise Version which got updated to : Windows Feature Experience Pack 120.2212.4170.0 in Feb, 22 1st week. The Oracle 19c server and client installed in my system with this database configured was working fine before the Windows upgrade. I had all registry entries and the Oracle Windows services were visible under services.msc. I have an application installed which was configured using this same database. Suddenly I am seeing that the Oracle services are not showing under Windows Services, I don’t see any registry entries which were there. Please can anyone help if similar issue has been observed and resolved.
thanks!
After the installation, when I’m opening SQL*PLUS It’s asking for username and password, is there any default user? Please let me know, thanks
Hi Anshul, you need to create a database first. Please, refer to this guide.
I do not understand this user account creation part. Why is this step required? Will it be of any use later on? If so, then for what? If I choose the Virtual User’ option, are there any scenarios where I might face any issues?
how to solve error INS 20802 ( database configuration assistant failure)
Please, check if the Oracle Home environment variable is set correctly.
Did you try with another browser?