How to Install Oracle 19c Database on OEL 7.9

In this post, I am going to share the steps to install a 19c database on OEL 7.9

I have already created a VM for this setup.

OS version: OEL 7.9

Add the hostname and IP in /etc/hosts if not using DNS as per your server setup

[root@fundb ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.56.21 fundb.training fundb

Download the latest oel 7 public repositories on the server to do the setup. I will use the same to install all the prereqs for the 19c database.

[root@fundb yum.repos.d]# cd /etc/yum.repos.d

[root@fundb yum.repos.d]# wget http://yum.oracle.com/public-yum-ol7.repo

--2021-02-09 17:15:53-- http://yum.oracle.com/public-yum-ol7.repo

Resolving yum.oracle.com (yum.oracle.com)... 23.54.89.140

Connecting to yum.oracle.com (yum.oracle.com)|23.54.89.140|:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 16402 (16K) [text/plain]

Saving to: ‘public-yum-ol7.repo’

100%[======================================>] 16,402 --.-K/s in 0.005s

2021-02-09 17:15:54 (3.16 MB/s) - ‘public-yum-ol7.repo’ saved [16402/16402]

[root@fundb yum.repos.d]# ls -ltr

total 20

-rw-r--r--. 1 root root 16402 Aug 26 2019 public-yum-ol7.repo

Enable(update from 0 to 1) the addons in repo file.

[ol7_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=https://yum.oracle.com/repo/OracleLinux/OL7/addons/$basearch/

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

gpgcheck=1

enabled=1

Install prereqs for 19c now.

yum install -y oracle-database-preinstall-19c

ol7_UEKR5 | 2.5 kB 00:00

ol7_addons | 2.5 kB 00:00

ol7_latest | 2.7 kB 00:00

(1/4): ol7_UEKR5/x86_64/updateinfo | 53 kB 00:01

(2/4): ol7_addons/x86_64/primary_db | 169 kB 00:01

(3/4): ol7_addons/x86_64/updateinfo | 95 kB 00:02

(4/4): ol7_UEKR5/x86_64/primary_db | 11 MB 00:12

Resolving Dependencies

--> Running transaction check

---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed

If we are using RHEL7 or CentOS7, we can pick up the RPM from the OL7 repository and install it. It will pull the dependencies from your normal repositories.

# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

yum update -y

Verify file /etc/sysctl.conf to see all kernel-level parameters are updated by the previous commands.

Oracle user would be created. Please change the password.

[root@fundb yum.repos.d]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password contains the user name in some form
Retype new password: 
passwd: all authentication tokens updated successfully.

Verify file "/etc/security/limits.d/oracle-database-preinstall-19c.conf" to see all required changes are updated.

Set secure Linux to permissive by editing the "/etc/selinux/config" file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server or run the following command.

# setenforce Permissive

If you have the Linux firewall enabled, you will need to disable or configure it.

To disable it, do the following.

# systemctl stop firewalld
# systemctl disable firewalld

Create directory from oracle user

[oracle@fundb ~]$ mkdir -p /u01/19cDB

Download the 19c(19.3) software from Oracle. Please note there are 2 types of files available to be downloaded. One is RPM-based and the other is a zip file.

I have downloaded the 19c zip file.

Unzip the 19c software at the home location and execute runInstaller.

Go to the directory where the zip file is placed and unzip

[oracle@fundb ~]$ cd /media/sf_Downloads/
[oracle@fundb sf_Downloads]$ unzip -d /u01/19cDB  LINUX.X64_193000_db_home.zip

[oracle@fundb 19cDB]$ pwd
/u01/19cDB
[oracle@fundb 19cDB]$ ls
addnode     css     deinstall    env.ora        javavm  md       OPatch   oui      R            root.sh.old.1  sqlj      usm
apex        ctx     demo         has            jdbc    mgw      opmn     owm      racg         runInstaller   sqlpatch  utl
assistants  cv      diagnostics  hs             jdk     network  oracore  perl     rdbms        schagent.conf  sqlplus   wwg
bin         data    dmu          install        jlib    nls      ord      plsql    relnotes     sdk            srvm      xdk
clone       dbjava  drdaas       instantclient  ldap    odbc     ords     precomp  root.sh      slax           suptools
crs         dbs     dv           inventory      lib     olap     oss      QOpatch  root.sh.old  sqldeveloper   ucp

Open GUI and run the installer from oracle user

[oracle@fundb 19cDB]$ export DISPLAY=:0

./runInstaller

Follow the screenshot below and start the installation.

Select the installer and create a database option

Select server class

Select Enterprise edition

Select base location

I am creating a non-container database in this post.

I know the root password so have given, else after installation it will ask to run a script via root.

I have ignored the swap space error but please increase the swap are to a minimum of 4 Gb.

Once completed you might need to run root.sh if earlier root password was not given via root user.

Let's verify the database now

[oracle@fundb ~]$ . oraenv
ORACLE_SID = [oracle] ? GOLD19
The Oracle base has been set to /u01/app/oracle
[oracle@fundb ~]$ echo $ORACLE_HOME
/u01/19cDB
[oracle@fundb ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 10 15:37:12 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
GOLD19	  READ WRITE

If you like please follow and comment

How to Install Oracle 19c Database on OEL 7.9