Installing Oracle 18c XE on Windows

This blog talks about How to Install Oracle Database 18c XE on Windows OS and Connect the database using SQL Plus and SQL Developer.

It will help the developer to explore more in Oracle if the developer has their own local database. The developer can create and test new objects by using this local database. Make sure you have a medium-end desktop/Laptop. For learning purposes, developers can install XE editions of the oracle free of cost. Oracle 18c has Multitenant architecture. It has a container database and a pluggable database section. We will be creating or working in the pluggable database.

Technologies and Tools Used

The following technology has been used

Windows OS
Oracle 18c XE
SQL Developer
SQLPLUS

Steps to follow

Step1: Download the database from the official site.

Step 2: Install Database

Extract the file and open the file setup.exe as administrator. You can follow the installation wizard.

There you can mention the installation location and the database password at the end of the installation wizard.

After installing the database it will show us the database details like Multitenant Container database, Pluggable database, and EM express URL. These details are very important for going forward.

Step 3: Open SQL Plus and connect Container database

Goto Start -> Oracle – OraDB18Home1 ->SQL Plus

Let’s connect to our created container database through SQL Plus. You have to enter the username and the password to connect to the database. SYSTEM will be the default username and the password is the password we have created while installing the DB.

You can follow the below format

Eg:- SYSTEM/Bluebird

Here Bluebird is the database password.

Now we have connected to the container database. Usually, we won’t do any development here.

So we have to connect to the pluggable database separately for our development.

Step 4: TNS configuration.

For connecting our pluggable database (XEPDB1), We have to configure the TNS. For that go to start – > Oracle – OraDB18Home1 – > Net configuration Assistant

Choose Local Net Service Name configuration

Then select add

Give the service name

Opt TCP as the network protocol

Give hostname as localhost

Click next if you want to test then you can test the connection otherwise you can click next.

So you have configured TNS successfully now.

Step 5: Connect pluggable database

We know that XEPDB1 is our pluggable database. For connecting pluggable database use the below command

Connect SYSTEM/Bluebird@XEPDB1

So we have connected to our pluggable database. Here we can do the development Or we can connect through SQL developer.

You can set up the connection in SQL developer and start doing development.

You can create a new user by using the below scripts

CREATE USER MY_DEV IDENTIFIED BY Welcome123;
/
GRANT CONNECT TO MY_DEV;
/
GRANT CREATE SESSION TO MY_DEV;
/
GRANT ALL PRIVILEGES TO MY_DEV;

Jabir Muhammed