Oracle Database 19c RPM Installation On Oracle Linux 7

Oracle Database 19c RPM Installation On Oracle Linux 7


Oracle Database 19c can now be installed on Linux OS using an RPM.
This post describes the steps for RPM based installation of Oracle Database 19c 64-bit on OEL 7 64-bit.


Step 1. Prerequisite for Installation: Two most important things for rpm based installation is
(1) You should have root privileges.
(2) Internet enable access from Server.
(3) Make sure SELINUX configuration set to PERMISSIVE.
(4) The /etc/hosts file must contain a fully qualified server/hostname.
(5) Set the correct hostname in the /etc/hostname file

[root@test-machine01 ~]# cat /etc/oracle-release
Oracle Linux Server release 7.7
[root@test-machine01 ~]#

[root@test-machine01 ~]# uname -a
Linux test-machine01  4.14.35-1902.3.2.el7uek.x86_64 #2 SMP Tue Jul 30 03:59:02 GMT 2019 x86_64 x86_64 x86_64 GNU/Linux
[root@test-machine01 ~]#

[root@test-machine01 ~]# cat /etc/selinux/config |grep SELINUX
# SELINUX= can take one of these three values:
SELINUX=permissive
# SELINUXTYPE= can take one of three values:
SELINUXTYPE=targeted
[root@test-machine01 ~]#

[root@test-machine01 ~]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.95.105  test-machine01.domain-name.local  test-machine01
[root@test-machine01 ~]#

[root@test-machine01 ~]# cat /etc/hostname
test-machine01.domain-name.local
[root@test-machine01 ~]#


Step 2. Install Oracle Database 19c Preinstallation RPM: Below yum system command oracle-database-preinstall-19c will take care of all pre-steps require to install Oracle Database 19c from installing required RPMs to creating user and groupids.

[root@test-machine01 ~]# yum install -y oracle-database-preinstall-19c
Loaded plugins: ulninfo
ol7_UEKR5                                                                                                                                                              | 2.5 kB  00:00:00
ol7_latest                                                                                                                                                             | 2.7 kB  00:00:00
(1/5): ol7_UEKR5/x86_64/updateinfo                                                                                                                                     |  74 kB  00:00:00
(2/5): ol7_latest/x86_64/group                                                                                                                                         | 660 kB  00:00:02
(3/5): ol7_latest/x86_64/updateinfo                                                                                                                                    | 3.2 MB  00:00:13
(4/5): ol7_UEKR5/x86_64/primary_db                                                                                                                                     |  14 MB  00:00:39
(5/5): ol7_latest/x86_64/primary_db                                                                                                                                    |  34 MB  00:01:05
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-19c.x86_64 0:1.0-2.el7 will be installed
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: nfs-utils for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: glibc-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: xorg-x11-xauth for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: net-tools for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: unzip for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: sysstat for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: bind-utils for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: psmisc for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: smartmontools for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Processing Dependency: bc for package: oracle-database-preinstall-19c-1.0-2.el7.x86_64
--> Running transaction check
---> Package bc.x86_64 0:1.06.95-13.el7 will be installed
---> Package bind-utils.x86_64 32:9.11.4-26.P2.el7_9.4 will be installed
--> Processing Dependency: bind-libs-lite(x86-64) = 32:9.11.4-26.P2.el7_9.4 for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: bind-libs(x86-64) = 32:9.11.4-26.P2.el7_9.4 for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libirs.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libbind9.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: liblwres.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libGeoIP.so.1()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libisc.so.169()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libisccfg.so.160()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64
--> Processing Dependency: libdns.so.1102()(64bit) for package: 32:bind-utils-9.11.4-26.P2.el7_9.4.x86_64

<<<<<<<<<<<<<<<<<<<<<        Output Trimmed   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<<<<<<        Output Trimmed   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
<<<<<<<<<<<<<<<<<<<<<        Output Trimmed   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>


  Verifying  : 32:bind-libs-9.11.4-26.P2.el7_9.4.x86_64                                                                                                                                 62/65
  Verifying  : glibc-2.17-292.0.1.el7.x86_64                                                                                                                                            63/65
  Verifying  : glibc-common-2.17-292.0.1.el7.x86_64                                                                                                                                     64/65
  Verifying  : libstdc++-4.8.5-39.0.1.el7.x86_64                                                                                                                                        65/65

Installed:
  oracle-database-preinstall-19c.x86_64 0:1.0-2.el7

Dependency Installed:
  GeoIP.x86_64 0:1.5.0-14.el7                             bc.x86_64 0:1.06.95-13.el7                bind-libs.x86_64 32:9.11.4-26.P2.el7_9.4    bind-libs-lite.x86_64 32:9.11.4-26.P2.el7_9.4
  bind-license.noarch 32:9.11.4-26.P2.el7_9.4             bind-utils.x86_64 32:9.11.4-26.P2.el7_9.4 compat-libcap1.x86_64 0:1.10-7.el7          geoipupdate.x86_64 0:2.5.0-1.el7
  glibc-devel.x86_64 0:2.17-323.0.1.el7_9                 glibc-headers.x86_64 0:2.17-323.0.1.el7_9 gssproxy.x86_64 0:0.7.0-29.el7              kernel-headers.x86_64 0:3.10.0-1160.21.1.el7
  keyutils.x86_64 0:1.5.8-3.el7                           ksh.x86_64 0:20120801-142.0.1.el7         libICE.x86_64 0:1.0.9-9.el7                 libSM.x86_64 0:1.2.2-2.el7
  libX11.x86_64 0:1.6.7-3.el7_9                           libX11-common.noarch 0:1.6.7-3.el7_9      libXau.x86_64 0:1.0.8-2.1.el7               libXext.x86_64 0:1.3.3-3.el7
  libXi.x86_64 0:1.7.9-1.el7                              libXinerama.x86_64 0:1.1.3-2.1.el7        libXmu.x86_64 0:1.1.2-2.el7                 libXrandr.x86_64 0:1.5.1-2.el7
  libXrender.x86_64 0:0.9.10-1.el7                        libXt.x86_64 0:1.1.5-3.el7                libXtst.x86_64 0:1.2.3-1.el7                libXv.x86_64 0:1.0.11-1.el7
  libXxf86dga.x86_64 0:1.1.4-2.1.el7                      libXxf86misc.x86_64 0:1.0.3-7.1.el7       libXxf86vm.x86_64 0:1.1.4-1.el7             libaio-devel.x86_64 0:0.3.109-13.el7
  libbasicobjects.x86_64 0:0.1.1-32.el7                   libcollection.x86_64 0:0.7.0-32.el7       libdmx.x86_64 0:1.1.3-3.el7                 libevent.x86_64 0:2.0.21-4.el7
  libini_config.x86_64 0:1.3.1-32.el7                     libnfsidmap.x86_64 0:0.25-19.el7          libpath_utils.x86_64 0:0.2.1-32.el7         libref_array.x86_64 0:0.1.5-32.el7
  libstdc++-devel.x86_64 0:4.8.5-44.0.3.el7               libtirpc.x86_64 0:0.2.4-0.16.el7          libverto-libevent.x86_64 0:0.2.5-4.el7      libxcb.x86_64 0:1.13-1.el7
  lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7 mailx.x86_64 0:12.5-19.el7                net-tools.x86_64 0:2.0-0.25.20131004git.el7 nfs-utils.x86_64 1:1.3.0-0.68.0.1.el7
  psmisc.x86_64 0:22.20-17.el7                            quota.x86_64 1:4.01-19.el7                quota-nls.noarch 1:4.01-19.el7              rpcbind.x86_64 0:0.2.0-49.el7
  smartmontools.x86_64 1:7.0-2.el7                        sysstat.x86_64 0:10.1.5-19.el7            tcp_wrappers.x86_64 0:7.6-77.el7            unzip.x86_64 0:6.0-21.el7
  xorg-x11-utils.x86_64 0:7.5-23.el7                      xorg-x11-xauth.x86_64 1:1.0.9-1.el7

Dependency Updated:
  glibc.x86_64 0:2.17-323.0.1.el7_9                           glibc-common.x86_64 0:2.17-323.0.1.el7_9                           libstdc++.x86_64 0:4.8.5-44.0.3.el7

Complete!
[root@test-machine01 ~]#
[root@test-machine01 ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@test-machine01 ~]#


Step 3. Download Oracle 19c DB RPM: Access URL: https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html and download Oracle Database 19c (19.3) for Linux x86-64 (RPM), refer to below image. Once the download is finished transfer Oracle DB rpm file to the database server.


Step 4. Install the database software: Install the database software using the yum localinstall command. Once the command is finished. The ORACLE_HOME for the software installation is “/opt/oracle/product/19c/dbhome_1“.

[root@test-machine01 tmp]# ls -ltr
total 2631536
-rw-------. 1 root root          0 Mar 18 15:37 yum.log
-rwx------. 1 root root        836 Mar 18 15:44 ks-script-DzdxPw
-rw-r--r--. 1 root root 2694664264 Mar 21 11:14 oracle-database-ee-19c-1.0-1.x86_64.rpm
[root@test-machine01 tmp]#
[root@test-machine01 tmp]# yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
Loaded plugins: ulninfo
Examining oracle-database-ee-19c-1.0-1.x86_64.rpm: oracle-database-ee-19c-1.0-1.x86_64
Marking oracle-database-ee-19c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-ee-19c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================
 Package                                           Arch                              Version                            Repository                                                       Size
==============================================================================================================================================================================================
Installing:
 oracle-database-ee-19c                            x86_64                            1.0-1                              /oracle-database-ee-19c-1.0-1.x86_64                            6.9 G

Transaction Summary
==============================================================================================================================================================================================
Install  1 Package

Total size: 6.9 G
Installed size: 6.9 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : oracle-database-ee-19c-1.0-1.x86_64                                                                                                                                        1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
  Verifying  : oracle-database-ee-19c-1.0-1.x86_64                                                                                                                                        1/1

Installed:
  oracle-database-ee-19c.x86_64 0:1.0-1

Complete!
[root@test-machine01 tmp]#


Step 5: Creating and Configuring an Oracle Database: In addition to the software installation, the RPM creates a script that allows you to create a demo database called “ORCLCDB“, with a pluggable database (PDB) called “ORCLPDB1“.

[root@test-machine01 ~]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files

31% complete
Creating and starting Oracle instance
32% complete
36% complete

40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.

Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
[root@test-machine01 ~]#


Step 6. Login to Database: All steps are done now you can login to your database and start using it along with validate services in listener.

[root@test-machine01 ~]# su - oracle
Last login: Sun Mar 21 12:34:11 +03 2021 on pts/0
[oracle@test-machine01 ~]$ cat /etc/oratab
ORCLCDB:/opt/oracle/product/19c/dbhome_1:N

[oracle@test-machine01 ~]$ . oraenv
ORACLE_SID = [oracle] ? ORCLCDB
The Oracle base has been set to /opt/oracle
[oracle@test-machine01 ~]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Mar 21 12:57:07 2021
Version 19.3.0.0.0

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

Enter password:

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

SQL>
col name for a60
set pages 999
select name from v$controlfile
union
select file_name from dba_data_files
union
select file_name from dba_temp_files
union
select member from v$logfile;SQL> SQL> SQL>   2    3    4    5    6    7

NAME
------------------------------------------------------------
/opt/oracle/oradata/ORCLCDB/control01.ctl
/opt/oracle/oradata/ORCLCDB/control02.ctl
/opt/oracle/oradata/ORCLCDB/redo01.log
/opt/oracle/oradata/ORCLCDB/redo02.log
/opt/oracle/oradata/ORCLCDB/redo03.log
/opt/oracle/oradata/ORCLCDB/sysaux01.dbf
/opt/oracle/oradata/ORCLCDB/system01.dbf
/opt/oracle/oradata/ORCLCDB/temp01.dbf
/opt/oracle/oradata/ORCLCDB/undotbs01.dbf
/opt/oracle/oradata/ORCLCDB/users01.dbf

10 rows selected.

SQL>




[oracle@test-machine01 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 26-MAR-2021 19:54:54

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test-machine01.domain-name.local)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                23-MAR-2021 15:56:12
Uptime                    3 days 3 hr. 58 min. 42 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/test-machine01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test-machine01.domain-name.local)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=test-machine01.domain-name.local)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/ORCLCDB/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ORCLCDB" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "ORCLCDBXDB" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "be09db4a10c31784e053695fa8c00a3a" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
Service "orclpdb1" has 1 instance(s).
  Instance "ORCLCDB", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@test-machine01 ~]$


Reference: Running RPM Packages to Install Oracle Database: https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/running-rpm-packages-to-install-oracle-database.html#GUID-BB7C11E3-D385-4A2F-9EAF-75F4F0AACF02

Click here for Step by Step manually creation of an Oracle 19c Database on Linux 7

 

This document is only for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.


Hope so you like this article
!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the latest update. Click here to know more about our pursuit.

Recent articles

 982 Total Views,  6 Views Today

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Spread the Knowledge!

Leave a Reply

Your email address will not be published. Required fields are marked *

five × two =

Open chat
1
Contact Us:
Hi,

Greetings of the day! How can we help you?

Thanks.
Team DBsGuru
Direct Call:+91-9310167776
Email: info@dbsguru.com

Share Learn Grow!


Click on the below technical group to join us to share expertise in PostgreSQL and MySQL on WhatsApp group. The purpose of this group is only help to the DBA community.

PostgreSQL Technical Group.

MySQL technical Group.

Technical Links Powered by DBsGuru.

Thanks.
Team DBsGuru.