Oracle Database 18c Express Edition Tutorial

Hello everyone! This material provides detailed instructions for installing Oracle Database 18c Express Edition (XE) on the Windows 10 operating system.

However, before proceeding directly to the installation process, you must first familiarize yourself with the requirements that Oracle Database XE imposes on the equipment and environment where this system will be installed, since certain resources and software are required for its correct operation.



Table of contents
[Show]

    • Oracle Database 18c Express Edition (XE) System Requirements
    • Step-by-step installation of Oracle Database 18c Express Edition (XE) on Windows 10
      • Step 1 – Downloading the installation distribution
      • Step 2 – Extract the ZIP archive and run the installer
      • Step 3 – Accepting the terms of the license agreement
      • Step 4 – Selecting an Installation Directory
      • Step 5 – Administrator Password
      • Step 6 – Starting the Installation Process
      • Step 7 – Completing the Installation Process
      • Step 8 – Checking the connection to the server
    • How to Oracle 18c Express Edition (XE) install on Windows 10 Video instruction
    • Вас заинтересует / Intresting for you:

Oracle Database 18c Express Edition (XE) System Requirements

Oracle Database XE is supported on the following versions of Windows operating systems (x64 only):

  • Windows 7
  • Windows 8.1
  • Windows 10
  • Windows Server 2022
  • Windows Peladen 2022 R2
  • Windows Server 2022

In addition, you need:

  • Minimum 8.5 gigabytes for system installation and 2 gigabytes or more for temporary storage;
  • RAM at least 2 gigabytes;
  • Computer administrator rights.

Step-by-step installation of Oracle Database 18c Express Edition (XE) on Windows 10

We will now walk through all the steps you need to follow to install Oracle Database 18c Express Edition (XE) on Windows 10.

Step 1 – Downloading the installation distribution

The first thing to do is download the installation distribution of Oracle Database 18c Express Edition.

As you probably already know, this edition is distributed free of charge, so it can be downloaded absolutely freely from the official Oracle website, the only thing is that you will need to register on the site, but there is nothing complicated in this, regular registration.

So, let’s go to the Oracle Database XE download page on the official website, here it is

Oracle Database Express Edition (XE) Download Page

Next, click on the link“Oracle Database 18c Express Edition for Windows x64” .

Screenshot 1

After that, we agree to the terms by checking the appropriate checkbox and click on the button
Download OracleXE184_Win64.
zip” file , if you are titinada yet authorized on the site, you will be redirected to the authorization page (where you can register ), and if you are already authorized, the download process will immediately begin.

Screenshot 2

As a result, you should download the ZIP archive“OracleXE184_Win64.
zip” with a size of about 2 gigabytes, this archive contains all the necessary files for installing Oracle Database 18c Express Edition.

Step 2 – Extract the ZIP archive and run the installer

After the archive is downloaded, you need to unpack it and run the “setup.exe” file, as a result, the installation acara should berangkat.

In the welcome window , clickNext .

Screenshot 3

Step 3 – Accepting the terms of the license agreement

Next, we need to read and agree to the terms of the license agreement, check the box“I accept the terms in the license agreement” and click “Next”.

Screenshot 4

Step 4 – Selecting an Installation Directory

Then you will need to specify the directory in which Oracle Database 18c Express Edition (XE) will be installed, although you can leave it by default, for example, I chose the OracleDatabaseXE folder on drive D.

Note!Do not select a directory that has spaces in its name.

Click “Next” to go to the next step.

Screenshot 5

Step 5 – Administrator Password

At this step, we need to come up with and enter a password for the system accounts: SYS, SYSTEM and PDBADMIN, remember this password, since it is with the help of these accounts that we will make our first connection to the server.

Enter and click “Next”.

Note!Oracle recommends that the password be at least 12 characters long, contain at least 1 uppercase character, 1 lowercase character, and 1 number [0-9].

Screenshot 6

Step 6 – Starting the Installation Process

Everything is ready for installation,click
Install .

Screenshot 7

The installation will take a certain amount of time, the process took berpenyakitan probably 30 minutes.

Screenshot 8

In the process, a window may appear “Windows
Security Alert ” , in this case nothing terrible happens, the system simply requests permission to access networks from the Java platform.

Click“Allow access” .

Screenshot 9

Step 7 – Completing the Installation Process

The installation will be completed when the following window appears, which will provide connection information.

We remember this information, in particular the default database (Pluggable Database – PDB), in Oracle Database 18c Express Edition (XE) the default database is called – XEPDB1

We press “Finish”.

Screenshot 10

Step 8 – Checking the connection to the server

Oracle Database 18c Express Edition (XE) is installed, now to test the operation, let’s connect to the server using the standard SQL Bersisa console utility.

 Many different shortcuts will appear on the Menginjak menu for launching Oracle Database XE programs, including the SQL Sesak shortcut.

We launch this utility.

Screenshot 11

Then we enter the username, for example, SYSTEM and password (this is exactly the password that you came up with during the installation process, it will not be displayed when you enter it ).

Screenshot 12

If no errors popped up during the connection process, then everything is fine.

Thus, we have installed Oracle Database 18c Express Edition (XE) on the Windows 10 operating system.

How to Oracle 18c Express Edition (XE) install on Windows 10 Video instruction

That’s all for today. In the next article, we will perona pipi about how to connect to an Oracle Database XE database using the Oracle SQL Developer tool, as well as how to write and execute SQL queries using this acara, so stay tuned for new articles!

Good luck for now!

Вас заинтересует / Intresting for you:

Source: https://oracle-patches.com/en/databases/oracle/installing-oracle-database-18c-express-edition-xe-on-windows-10