Step by step Installing Oracle Database 18c on Oracle Linux 7.6

Hello everyone, it’s time to install Oracle Database 18c on Oracle Linux 7.6. This tutorial will guide you to install Oracle Database 18c Express Edition (XE) on Oracle Linux 7.6. You can also use this tutorial to install on a CentOS 7 Linux.

Installing Oracle Database on Linux is not as simple as installing MySQL or PostgreSQL database. There are a lot of things to take care of. I hope you already have a basic experiences of using Terminal in Linux because most of the installation steps are done via Terminal. So, get ready to get your hands dirty 🙂

Step 1. Download Installation Files

First, we need to download the Oracle 18c XE installation file for Linux (RPM) and also the Oracle pre-install file (RPM). You can obtain these two files from the following links:

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

Save the two files in your download directory for example /home/oracle/Downloads

Step 2. Installation

Install Oracle Database PreInstall package

Next, we need to install the Oracle Database PreInstall RPM file. In this case, my file name would be: oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm.

Logon as oracle user and then type su – to become root from Terminal.

[oracle@server Downloads]$ su -
Password:
[root@server Downloads]#

Now install it using the following command

yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

Make sure the installation is complete with no errors

Install Oracle Database 18c XE

Use this command as root to install the Oracle Database package. Make sure the installation finish completely with no errors.

su -
yum -y localinstall oracle-database-xe-18c-1.0-1.x86_64.rpm

Step 3. Create and Configure Database

Now we are going to create a new database and configure it. Logon as oracle and then run “su -” to switch to root.

[oracle@server ~]$ su -
Password:
Last login: Mon Jan 21 11:26:10 WIB 2019 on pts/1

[root@server ~]# /etc/init.d/oracle-xe-18c configure

Please monitor your Terminal because you will be asked to create a new password for sys, system and pdbadmin account. Please allow sometimes because this process can take up to 15 minutes or so. When the installation is success, you will see something like this.

At this point, we now have an Oracle Database 18c which we can connect to. But, we still have something to do to complete the Oracle Database 18c XE installation steps.

Configure the database

Let’s check the content of the tnsnames.ora file in the following folder
/opt/oracle/product/18c/dbhomeXE/network/admin

cat /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora

Content:

Now let’s edit this file and add our pluggable database into it.

 cp /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.bak 

nano
/opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora

Now add the following lines to the end of the tnsnames.ora:

XEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server.griyaku.lan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XEPDB1)
    )
  )

Don’t forget to change the domain server.griyaku.lan with your domain name. Or, you can also use the server IP address.

Now, let’s edit the ./bash_profile file.

nano ~/.bash_profile

Add the following lines:

export ORACLE_BASE=/opt/oracle/ 
export LD_LIBRARY_PATH=/opt/oracle/product/18c/dbhomeXE/lib
export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export PATH=$ORACLE_BASE/product/18c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE

Now execute this command to activate it

source ~/.bash_profile

Connect to Database using SQLPlus

Now let’s try to connect to the database using SQLPlus tool. Use the following command to connect to the database

[oracle@server ~]$ sqlplus

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Jan 22 22:41:56 2019
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0

SQL>

Restart the Database

Now it’s time to test the database restart. This ensure the database will run automatically after system restart. To enable the Oracle XE database to start automatically during system boot, use this command below

su -
systemctl daemon-reload
systemctl enable oracle-xe-18c

You can also use the Oracle SQL command to start and stop the database. Login to Oracle using SQLPlus and then use the following command.

$ sqlplus
Enter user-name: sys as sysdba
Enter password:

To stop the database use this command:

SQL> shutdown immediate

To Start the database use this command:

SQL> startup

Step 4. Configure Oracle Enterprise Manager

By default we can only open or access the Enterprise Manager from the localhost. To access the EM web interface from the network client, we need to execute this SQL command.

Login to Oracle using SQLPlus

sqlplus sys as sysdba
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
exit;

Now open a web browser and type the following address. Don’t forget to change the domain with your server domain name/ip address.

https://192.168.100.99:5500/em

Closing Word

With some efforts, finally I can install and run Oracle Database 18c XE on my Oracle Linux. Thanks for coming and I hope you enjoy this article. See you on the next tutorials.

2 Trackbacks / Pingbacks

  1. How to install Docker on CentOS 7.6 | Manjaro dot site
  2. How to Install OnlyOffice Community Server on CentOS 7 | Manjaro dot site

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.