Как установить oracle database 18c на windows 10

Картинка с сайта: www.rebellionrider.com

Since the launch of Oracle 18c we were wondering, will we ever be able to download & use it on our local machine or will it just remain a cloud-only software? Well, ladies and gentleman, there is good news for you – Oracle has finally released an on-premises version of Oracle Database 18c for Linux as well as Microsoft Windows Operating systems. In this blog, we will learn how to install Oracle Database 18c on the Windows 10 operating system.

Just to make the installation easy to understand and less complex I have divided this tutorial into three small sections. These are:

1. Minimum Hardware and Software requirements
2. Download and acquisition of the Oracle Database 18c software, and
3. Installation of Oracle Database 18c on Windows 10

Also, at the end of this blog, we will see what the default URL for Oracle database 18c enterprise manager is, thus I suggest you read it till the end.

Minimum Hardware and Software Requirements for Installing Oracle Database 18c

The minimum hardware requirement for installing Oracle Database 18c on Windows 10 is:

• 2 GB of RAM
• 10 GB of empty space on your hard disk drive
• 16 GB SWAP (virtual memory) space if RAM is more than 16 GB. If RAM is less than or equal to 16 GB then 1 times the size of the RAM
• A processor based on either Intel EM64T or AMD64 Architecture
• Minimum screen resolution of 1024 x 768 pixels.

I guess you’ll agree with me when I say that having more space than the suggested minimum is always beneficial.

Can we install Oracle Database 18c on x32 bit Microsoft Windows operating system?

Unfortunately no.  Just like Oracle Database 12c, Oracle 18c in only available for x64 bit Microsoft Windows operating system.

Are all Microsoft Windows compatible with Oracle Database 18c?

Again the answer is no. Not all Windows are compatible with Oracle Database 18c. You can read this short note on my Facebook for the list of all the Oracle 18c compatible Windows operating systems.  

In order to install any software we first need to acquire all its necessary files. Currently, Oracle Database 18c is available for Microsoft Windows x64, Linux x86-64 and for Oracle Solaris. You can download your copy of Oracle 18c from here. Unlike previous versions like Oracle 11g, Oracle 18c has only 1 file which is around 4.4 GB in size.

Oracle Database 18c Download Link
http://www.Oracle.com/Download

Currently, there are only two versions of Oracle Database 18c that are available –

1. Oracle Database 18c Enterprise edition and
2. Oracle Database 18c Standard 2 edition

Luckily you will get both these versions bundled within that single file that I mentioned before. No need to download them separately. Ahh! What a relief.

In case if there is still any confusion about the downloading of Oracle 18c then I suggest you watch my Video on YouTube, here is the link. Pro tip: check the description for the timestamps.

How to Install Oracle Database 18c on your Windows 10?

Before we commence the installation of Oracle Database 18c make sure you are logged in to your windows using an “Administrative User”. It is highly advisable.

Step 1: Extract the files.

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 an image-based installation, the Oracle Universal Installer of 18c takes the location of its setup file and assigns it as its db_home location. That is why before you start extracting the content of this file, you need to first decide where to create your db_home directory.

So first create a directory either in your C:\ drive or D:\ drive and give it a relevant name. I created the directory in my D:\ drive and named it “db_home”. 

Step 2: Initiate the Installation

Installation requires administrative privileges thus first locate the “setup.exe” file inside your “db_home” directory. Once you locate the file right click on it and select Run as Administrator. Doing so will launch the Oracle Universal Installer.  

Pro tip:
If Oracle Universal Installer (OUI) doesn’t come up on clicking on setup.exe file then there may be a problem with the extraction of the files. Manual extraction could solve the problem. Double click and open the oracle 18c *.zip file that you downloaded à Press “control + A” and select all the files from there à drag them into the “db_home” folder that you created.

Manual extraction could solve the problem. Double click and open the oracle 18c *.zip file that you downloaded à Press “control + A” and select all the files from there à drag them into the “db_home” folder that you created.

Screen 1: Configuration Options

On this screen, we are presented with two installation options.

Option 1: 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 practicing purposes.

Option 2: “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 an upgradation.

I will choose the first option which will configure the software as well as create a database for me.

Картинка с сайта: www.rebellionrider.com

 Screen 2: System Classes

In this step, you have to choose between Server Class and Desktop class.

Desktop class: If you are installing this oracle database 18c on your laptop or desktop then go with this option.

Server 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 this option.

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.

Картинка с сайта: www.rebellionrider.com

Screen 3: Oracle Home User

Oracle Installer 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.

In this step, we are provided with four options. These are:

1. Virtual user: Use this option if you neither want to create a new user nor want to use any built-in or existing user.
2. Use Existing Windows User: Choose this if you want to use an existing standard or administrative windows user which is already created.
3. Create New Windows User: Oracle universal installer gives you an option for creating a dedicated user for your Oracle Database 18c. Using this you can create a Standard Windows User which is completely dedicated for your Oracle requirements. This user will not be allotted with logon privileges thus logging in to your system with this user won’t be possible but you can modify it like any other standard windows user.
4. Use Windows Built-in account: Choose this if you want to use one of those user accounts which Windows 10 has created for you during its installation.

For enhanced security, Oracle recommends either using Virtual Account or Standard Windows user instead of Windows built-in account. Also, you cannot change this Oracle Home user once the installation is done thus be careful while creating it.

I will suggest creating a new and completely dedicated Oracle Database 18c user. To do that you have to select the third option which is “Create Windows User”.

Картинка с сайта: www.rebellionrider.com

Screen 4: Typical Installation.

This is a very important step in Oracle Database 18c Installation as here we will be configuring the installation settings. Let’s understand what these settings are:

1. Oracle base: Oracle Base is the base location for all the necessary files and directory for Oracle Database 18c. Here you will get a drop-down input field with one or two options already filled. Choose from any of these if you want to, but if you want to assign a location of your choice then hit the “Browse” button and select the desired location.
2. Software Location: Famously known as Oracle Home or DB_HOME. This will be the directory where your Oracle Database 18c will get installed. Also, the location of this directory will be the one pointed by the environment variable.

Prior to 18c, we were allowed to modify the Oracle Home location but now as you can see the location is already set and we can’t modify it. The installer took the location of the Setup files and assigned it as the Oracle Home location. Hence the reason why we extracted our files into a separate directory. You can read more about Oracle Home here.

1. Database file locations: This will be a subdirectory of the Oracle Base. 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.
2. Database Edition: Here you will get a drop-down menu with the list of all the database versions available with your download. As mentioned above, our download comes with both the version of Oracle Database 18c which are, Enterprise Edition and Standard 2 Edition. Choose either of them accordingly. I suggest you to go with Enterprise Edition.
3. Character Set: Let it be on its default value.
4. Global Database Name (S.I.D.): The Global Database Name will be the name of your database and will serve as your database SID. You will need it while making a connection with your database using tools such as SQL Developer. By default, it is set as ORCL. If you want, you can change it to any other name, but make sure to remember it. I suggest you write it down somewhere as your Database SID.
5. Password: This will be the password of your administrative users such as sys or system.
6. Create as Container Database: Here you will get a checkbox. If you check this box then OUI will create a container database for you.
7. 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.

Картинка с сайта: www.rebellionrider.com

Screen 5: Prerequisite Checks

In this step, the OUI will check the prerequisites. If everything goes well then we will be good to install it. If there is any error then the OUI will show you here.

Картинка с сайта: www.rebellionrider.com

Screen 6: Summary

On this screen, OUI will show the summary of the configuration which you just did for your Oracle Database 18c installation. Here go ahead and press the Install button.

Картинка с сайта: www.rebellionrider.com

Unlike 11g and 12c in Oracle 18c, you will not get a DBCA separately for your database configuration. This new Oracle 18c Universal Installer has simplified the process.

As Oracle Database 18c is a very hefty software thus this installation will take some time depending on your hardware thus have patience and let the OUI do its work.

Картинка с сайта: www.rebellionrider.com

Once the installation is done the installer will show you the URL for your Oracle Database 18c Enterprise Manager. Enterprise Manager is a web-based tool for managing Oracle Database 18c. Copy and save that link. I suggest you to book mark that link.

Картинка с сайта: www.rebellionrider.com

If you learn faster by watching Videos then here I have created one for you–

So that is the tutorial on how to install Oracle Database 18c on Windows 10 x64. Hope you enjoyed reading. If you still have any confusions then you can watch me install the Oracle Database 18c in the video embedded above or you can reach out to me directly on my Facebook.

Thanks and have a great day.

In this article we will learn how to install Oracle Database 18c on Windows 10 Enterprise for research and education.

Before we start installing, we need to know the minimum requirements for Oracle Database 18c.

Windows x64 Minimum Hardware Requirements

System Architecture: Processor: AMD64 and Intel EM64T

Physical memory (RAM): 2 GB minimum

Virtual memory (swap):

• If physical memory is between 2 GB and 16 GB, then set virtual memory to 1 times the size of the RAM
• If physical memory is more than 16 GB, then set virtual memory to 16 GB

Disk space:

• Typical Install Type total: 10 GB
• Advanced Install Types total: 10 GB

Video adapter: 256 colors

Screen Resolution: 1024 X 768 minimum

It’s important to know that Oracle Database 18c is only available for 64 bit Windows systems, just as for Oracle 12c. Therefore, we can’t install Oracle Database 18c in our PC if it’s running a 32 bit Windows OS.

Moreover, Oracle Database 18c is only available for Windows 10 Professional, Enterprise and Education Editions. This means we can’t install Oracle Database 18c if we are using Windows 10 Home Edition.

As we mentioned before, we will be installing Oracle Database 18c on Windows 10 Enterprise 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.

Картинка с сайта: prelive-blog.toadworld.com

Download Software from OTN

To install Oracle Database 18c we have to download the software, which we can do by visiting the OTN page: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

We accept the license agreement and choose the Windows version to download ->Click on File 1

Картинка с сайта: prelive-blog.toadworld.com

To download the files, we must login to the Oracle website. If we have a valid account on this site, we can download the software; otherwise we can register on the page and create an account, which is completely free. 

Картинка с сайта: prelive-blog.toadworld.com

After we fill in the username and password and click on the Sign In button, the files will start downloading automatically. 

Картинка с сайта: prelive-blog.toadworld.com

As we can see the file is compressed and zipped. 

Картинка с сайта: prelive-blog.toadworld.com

Extracting the Files

To proceed to the next step, we need to extract the content of file, but before doing that it’s very important to know that 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: Image Based Installation.

In Image Based Installation the Oracle Universal Installer of 18c takes the location of our setup.exe file and assigns it as its db_home location. That’s why before we start extracting the content of this file, we first need to decide where we want to create our db_home directory.

We don’t want to create our db_home in the downloads folder. That’s why we will first create a folder inside the C drive and name it Oracle18c. 

Картинка с сайта: prelive-blog.toadworld.com

The name for this folder cannot contain any spaces.

Now we are going to extract the contents of the file that we just downloaded into this folder. As the file is approximately 10 GB in size, this extraction process will take some time.

Before beginning the installation of Oracle Database 18c, we need to verify that we are connected to our Windows as an administration user. If we are not, we must log in to our Windows as an administrative user. Not doing so will cause an installation error and crash the entire process.

Oracle Database 18c Installation

To begin the installation of the Oracle Database 18c, we must first go to the Oracle18c folder; for example, in my case, C:\Oracle18c. and then locate the setup.exe file. 

Картинка с сайта: prelive-blog.toadworld.com

Right click on setup.exe file and choose run as administrator. 

Картинка с сайта: prelive-blog.toadworld.com

We see Screen 1: “Configuration Option”

Here we are presented with two installation options:

The first is to “Create and configure a single instance database”. Choosing this option will not only configure an Oracle Database Server on our machine but also create a starter database for us. We can choose this database for learning and practice purposes.

The second option is “Set Up Software Only”. As the name suggests, it will only configure the Oracle Server software on our machine. No database will be created. We need to create the database manually using the DBCA utility. We choose this option when we are configuring a RAC or planning to perform an upgrade.

For our demo, we will choose the first option, which will configure the software as well as create a database for us. 

Картинка с сайта: prelive-blog.toadworld.com

Click on Next button to move next screen.

We see Screen 2: “System Class”.

Here we are presented with two class options:

Desktop class: We choose this option if we are installing on a laptop- or desktop-class system. This option includes a starter database and allows minimal configuration.

Server class: We choose this option if we are installing on a server-class system, which Oracle defines as a system used in a production data center. This option allows us for more advanced configurations options.

We select the first option, Desktop class, because we will be installing the Oracle Database 18c on Windows 10 Enterprise 64bit. 

Картинка с сайта: prelive-blog.toadworld.com

Click on the Next button to move to the next screen.

We see Screen 3: “Oracle Home User”. The Oracle server creates four Windows User Groups:

User Virtual Account: This type of account is the Oracle Home User for Oracle Database Single Instance installation. The account allows us to install Oracle Database, and create and manage database services without passwords.

Use Existing Windows User: This type of account can be a Windows Local User, a Windows Domain User or a Windows Managed Services Account (MSA). We must provide a username and password for a Windows Local or Domain User. For the MSA account, which is a managed domain account, we only need to provide the username. For an Oracle RAC Database or an Oracle Grid Infrastructure installation, we can only use a Windows Domain User Account.

Create New Windows User: Here we need to provide the username and password for the Windows Local User that we want Oracle Universal Installer to create, and then confirm the password. The new user that is created is denied interactive logon privileges to the Windows computer. However, a Windows administrator can manage this account like other Windows accounts.

Use Windows Built-in Account: In this case, no username or password is required. Oracle creates Windows Services using Windows Built-in Accounts (LocalSystem or LocalService).

For Database Server installations, Oracle recommends that we use a standard Windows User Account (instead of a Windows Built-in Account) as the Oracle Home User for enhanced security.

In this step, we will to create a new user which will be completely dedicated to our Oracle Database 18c. We select the third option, “Create a New Windows User”.

Username: Oracle

Password: <mypassword> 

Картинка с сайта: prelive-blog.toadworld.com

As we mentioned before, the newly created user is denied Windows logon privileges, so we don’t login to Windows using this account. We will name this user as Oracle. However, we can manage this user like any other Windows user we have.

Note that we can’t change this Oracle Home user once the installation is done, so be careful when creating it.

Click on the Next button.

Screen 4: “Typical Installation”.

This step is very important because here we will be configuring the installation settings.

The Oracle Base directory is a top-level directory for Oracle software installations. We can set whatever location we want as our Oracle Base.

The Software Location is the Oracle home path where the Oracle Database binaries for this installation are placed. Prior to 18c we were allowed to set this Oracle Home location, but now, as we can see, the location is already set and we can’t modify it.

The installer takes the location of the Setup files and assigns it as the Oracle Home location. That’s why we extracted our installation files in a separate directory.

Database File Location is the location where Oracle Database files such as data files, redo log files, control files, server parameter files and password file are stored. These are the most important files of Oracle Database. The default data file location is $ORACLE_BASE/oradata for a single node Oracle Real Application Clusters (Oracle RAC), single instance, and desktop-class installations. For multi-node Oracle RAC installations, the default location is under any shared mount point discovered across the selected set of nodes.

We will use the default location.

Database Edition: There are two options here. Enterprise Edition and Standard Edition 2. We will select the Enterprise Edition.

Character set: we will use the default Unicode standard.

Starting with Oracle Database 12c Release 2 (12.2), the default database character set of a database created from the General Purpose/Transaction Processing or the Data Warehousing template is Unicode AL32UTF8.

Unicode is the universal character set that supports most of the currently spoken languages of the world. It also supports many historical scripts (alphabets). Unicode is the native encoding of many technologies, including Java, XML, XHTML, ECMAScript, and LDAP. Unicode is ideally suited for databases supporting the Internet and the global economy.

Below, we have three fields: Global Database Name, Password and Pluggable Database Name; these fields are the most import settings. We will need them in the future to connect with our database. Therefore, it’s very important that write them down somewhere.

Global Database Name is the name that identifies the database. It must be unique to distinguish the database from all other databases in a network.

The Global Database Name will be the name of our database as well as serve as our database SID. We will need this while making connection with our database using tools such as Toad for Oracle. By default, it’s set as ORCL.

If we want, we can change and give it any other name, but make sure to remember it. It’s a good practice to write it down somewhere as our Database SID.

Global Database Name is composed of a database unique name (db_unique_name), a delimiter (a period), and a database domain name (db_domain). The name has the following format: db_unique_name.db_domain.

Where:

• db_unique_name is the name of the database. It can contain a maximum of 30 characters, as long as the first eight characters are unique. The characters can be alphanumeric (a-z, 0-9), underscore (_), dollar ($), and pound (#).
• db_domain is the computer environment used for the database. It should contain no more than 128 characters; alphanumeric (a-z, 0-9), underscore (_), pound (#), and periods (.).

Now we need to enter the passwords. This password is for the SYS and SYSTEM database privilege, write it down somewhere to remember it.

Minimum Password Requirements

We must provide usernames and passwords that comply with the following requirements:

• Password cannot exceed 30 characters.
• No empty password fields.
• Username cannot be the same character string as a password.
• The SYS account password cannot be change_on_install. (case-insensitive)

Password Recommendations

Oracle recommends the following guidelines when prompted for a password.

• Contains at least one lowercase letter.
• Contains at least one uppercase letter.
• Contains at least one digit.
• Is at least 8 characters in length.
• Uses the database character set, which can include the underscore (_), dollar ($), and pound sign (#) characters.
• Should not be an actual word.

Next, we need to make sure to check “Create as Container database” to create our database as a container database.

Pluggable Database Name: Here we have to specify a unique name for a pluggable database, in this case, we use the default name, orclpdb. 

Картинка с сайта: prelive-blog.toadworld.com

Click on the Next button.

In the next step, Oracle Universal Installer (OUI) will check the prerequisites, such as hardware compatibility. If everything goes well, we can install it, but if there are any errors, the OUI will show us the errors in this screen. As we can see, we don’t have errors!

Картинка с сайта: prelive-blog.toadworld.com

Now, click on the Install button and the installation of Oracle Database 18c will start. 

Картинка с сайта: prelive-blog.toadworld.com

As Oracle Database 18c is very robust software, this installation will take some time depending on our hardware.

The installation is done.

In this installation we don’t get DBCA for database creation as we did with Oracle 12c or 11g. The new Oracle Database 18c Universal Installer has simplified the process.

Картинка с сайта: prelive-blog.toadworld.com

The last thing that we need to do is to copy and save the link: https://localhost:5500/em

This is the link for Oracle Database 18c Enterprise Manager.

Now we have Oracle Database 18c installed on our machine.

Connect to Oracle Database 18c using Toad for Oracle

We open the Toad for Oracle tool and the Login window appears.

User / Schema: SYS or SYSTEM

Password: <my_password>

Select the TNS tab:

Database: ORACLR_CONNECTION_DATA

Or you can select the Direct tab:

            Host: localhost

            Port: 1521

            SID: orcl 

Картинка с сайта: prelive-blog.toadworld.com

Now, we can see the objects in our new Oracle Database 18c.

Картинка с сайта: prelive-blog.toadworld.com

Conclusion

We have reached the end of this tutorial, where we have learned how to install the Oracle Database 18c in a Windows environment.

Sources: https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinw/

Download s/w: 2Gb in size so will take some time depending on download speed, took me 15 minutes

If you don’t already have an account you
will need to create one to download the s/w:

https://profile.oracle.com/myprofile/account/create-account.jspx

https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Картинка с сайта: www.snowdba.com

Картинка с сайта: www.snowdba.com

Will get prompted to allow app to make changes to PC, accept this.

Картинка с сайта: www.snowdba.com

Click Next >:

Картинка с сайта: www.snowdba.com

Read Agreement and select ‘I accept the terms in the license
agreement’ if you agree

Then : click Next >:

Картинка с сайта: www.snowdba.com

Choose location to install the
s/w, it will default to C: drive and window account in path

Картинка с сайта: www.snowdba.com

I will change to D: as I have more space there on my PC,
also update the account path to be ‘oracle’

So: C:\app\oracle\product\18.0.0\ OR D:\app\oracle\product\18.0.0

Картинка с сайта: www.snowdba.com

Click Next >:

Enter Password to be used for system accounts, as this is
just a test install I will choose ‘oracle123’ for this, you can change
afterwards if you need: (alter user <username> identified by
<password>;)

Картинка с сайта: www.snowdba.com

Click Next >:

Review Summary Screen and click Install:

Картинка с сайта: www.snowdba.com

During the install, Windows defender will alert for java
firewall rule, I’ve changed this to

‘Private networks, such as my home or work network’,

I suspect other Virus/Security s/w may also need to have
options changed or alert as well.

Картинка с сайта: www.snowdba.com

This will take 30 Minutes

Картинка с сайта: www.snowdba.com

Картинка с сайта: www.snowdba.com

Картинка с сайта: www.snowdba.com

Once install is complete we are presented with final screen:

Картинка с сайта: www.snowdba.com

Note the details for our XE DB:

Port: 1521

Server: localhost

Pluggable DB: XEPDB1

Enterprise Express: https://localhost:5500/em

The container DB will be called XE.

Click Finish, to close installer

Check DB in GUI Enterprise Manager Express

Картинка с сайта: www.snowdba.com

User Name: sys

Password: oracle123

Container name: <Leave blank>

as sysdba: tick box

Картинка с сайта: www.snowdba.com

Click Login

Картинка с сайта: www.snowdba.com

Optional Install SQL Developer

Download SQL Developer so we have a nice front end GUI to do development work using Oracle XE 18c: 400M, 3 mins to download

https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Картинка с сайта: www.snowdba.com

Right click ‘sqldeveloper.exe’ -> create
short cut

Then copy/move new shortcut to desktop for easy access.

Картинка с сайта: www.snowdba.com

If prompted you can copy preferences from a
previous version of sqldeveloper

Картинка с сайта: www.snowdba.com

Click new connection:

Name: XEPDB1_sys

Username: sys

Password: oracle123

Save Password: check box

Role: SYSDBA

Hostname: localhost

Port: 1521

Service name: xepdb1

Then click test, should see :
Status Success

Click Save -> Click Connect

You are now connected to 18c XE
db.

Картинка с сайта: www.snowdba.com

Картинка с сайта: www.snowdba.com

Can optionally update tnsnames.ora file in <s/w base dir>/network/admin/tnsnames.ora file to add an connection alias for xepdb1 as below, for me that directory is : D:\app\oracle\product\18.0.0\dbhomeXE\network\admin

XEPDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ACER-HOME-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XEPDB1)
)
)

Optional, Uninstall Oracle 18c XE and delete database (destructive) – CAUTION

(Will need a reboot at the end to
complete, but can reboot later if needed)

As per documentation:
https://docs.oracle.com/en/database/oracle/oracle-database/18/xeinw/deinstalling-oracle-database-xe.html#GUID-DC36940C-D201-457B-A3D5-D6E2BB800120

Use Add or Remove Programs to
deinstall Oracle Database XE:

In the Windows Control Panel,
select Add or Remove Programs.

Select Oracle Database 18c
Express Edition.

Click Change/Remove or Uninstall.

Follow the prompts to deinstall
Oracle Database Express Edition. After few minutes, the window will close and
the deinstallation will be complete.

Картинка с сайта: www.snowdba.com

Right Click Oracle Database 18c
Express Edition -> Uninstall

Take 30 minutes.

Картинка с сайта: www.snowdba.com

Картинка с сайта: www.snowdba.com

  Click Yes.

Картинка с сайта: www.snowdba.com

Click OK

Once PC has rebooted uninstall is
complete.

Uninstall still leaves behind
services: (If you don’t run cmd/dos prompt as administrator you will not be
able to delete the service)

Run cmd as administrator , cmd
-> right click run as adminstrator

sc delete OracleJobSchedulerXE

sc
OracleOraDB18Home1MTSRecoveryService

sc delete
OracleOraDB18Home1TNSListener

sc delete OracleServiceXE

sc delete OracleVssWriterXE

sc delete
OracleOraDB18Home1MTSRecoveryService

Clean up folders left behind, for
me it was, check beforehand contents of folder to be sure, before deleting,
should just got to recyclebin anyway, if you needed to recover.

Remove: D:\app\oracle\product\18.0.0