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
- Oracle Critical Database Patch ID for October 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for July 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for April 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for January 2024 along with enabled Download Link
- Oracle Critical Database Patch ID for October 2023 along with enabled Download Link
