Software-only Installation of oracle Database 19c for Upgrade

Overview

Oracle Database 19c is a multi-model database that provides full support for relational and non-relational data, such as JSON, XML, text, spatial and graph data. There are lots of new features available in this new release like partitioned hybrid tables, encryption capabilities in the built-in data dictionary, statistics-only queries and many more. It also enables Oracle’s Autonomous Database Cloud Services. This article describes the installation of Oracle Database 19c (19.3) 64-bit on Red Hat 8 64-bit.

When you plan to upgrade from 12c to 19c that means, you have already some configuration when you install 12c. So, this software-only installation will be minimal.

Lab Environment

	Server Machine	Work Station or Client Machine
OS Release	Red Hat Enterprise Linux release 8.4 (Ootpa)	Red Hat Enterprise Linux release 8.4 (Ootpa)
Kernel	4.18.0-305.3.1.el8_4.x86_64	4.18.0-305.7.1.el8_4.x86_64
Oracle Release	19.3	Oracle SQL Developer Version 19.2.1.247
IP Address	192.168.1.10	192.168.1.20
Host Name	Server	Client
User Name	Admin, oracle	User

Table 01: Lab Environment

Step 1: Download Software

Go to the below office site.

https://www.oracle.com/bd/database/technologies/oracle19c-linux-downloads.html

And Download the following version. As of date Tue Aug 3 13:01:35 +06 2023, the latest version of Oracle Database for Red Hat is:

Oracle Database 19c (19.3) for Linux x86-64

Step 2: Install Dependent Package

At first, manually install some basic prerequisite rpm that will suppress future conflicts:

[Admin@Server ~]$ sudo dnf install -y unixODBC unixODBC-devel libnsl libnsl.i686 libnsl2 libnsl2.i686

May you not find the following RPM packages in the local repository.

compat-libcap1
compat-libstdc++-33

So, download these RPMs from the rpm finder:

[Admin@Server ~]$ sudo wget https://rpmfind.net/linux/centos/7.9.2009/os/x86_64/Packages/compat-libcap1-1.10-7.el7.x86_64.rpm
[Admin@Server ~]$ sudo wget https://rpmfind.net/linux/centos/7.9.2009/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

And then install:

[Admin@Server ~]$ sudo dnf -y localinstall compat-libcap1-1.10-7.el7.x86_64.rpm
[Admin@Server ~]$ sudo dnf -y localinstall compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm

Step 3: Install Oracle 19c Prerequisite Package

To perform all our prerequisite setup automatically, we need to install the oracle-provided “oracle-database-preinstall-19c” package. By default, this package is not present in the Red Hat repository list.
To download this rpm, run the following command:

[Admin@Server ~]$ curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

And then install as follows:

[Admin@Server ~]$ sudo dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

Step 4: Create Database Installation Directory

In this tutorial, we will use different directories for each type of database file.

Note:Do not put the oraInventory directory under the Oracle base directory for a new installation, because that can result in user permission errors for other installations.

[oracle@Server ~]$ sudo mkdir -p /u01/app/oracle/product/19c/db_1

Step 5: Unzip and Suppress the OS Version Error

[oracle@Server ~]$ unzip /tmp/LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19c/db_1

We may receive the following error when installing Oracle database 19c Installer on Red Hat 8 (64-bit) platform:

[INS-13001] Oracle Database is not supported on this operating system. The installer will not perform prerequisite checks on the system.

To suppress this error change the distribution id to OLE8 in “cvu_config” file as:

[oracle@Server ~]$ sed -i 's/#CV_ASSUME_DISTID=OEL5/CV_ASSUME_DISTID=OEL8/' /u01/app/oracle/product/19c/db_1/cv/admin/cvu_config

Step 6: Installation Oracle Database

For 19c Database:

[oracle@Server ~]$ source /u01/app/oracle/env/scripts/Oracle19cEnvVar.sh

[oracle@Server ~]$ echo $ORACLE_BASE

[oracle@Server ~]$ echo $ORACLE_HOME

Go to the ORACLE_HOME directory and start the Oracle Universal Install (OUI) interactively by issuing the following command. If you want to run this installer silently then check this link.

[oracle@Server ~]$ bash /u01/app/oracle/product/19c/db_1/runInstaller

In this installation process, we will create and configure an Oracle Database Enterprise Edition Server. For RAC and Upgrade installation choose ‘Set UP Software Only’. The Server Class option for a production data center allows for more advanced configuration options such as Oracle RAC, ASM, RMAN, integration with OEM, etc.

Choose the following option for this installation process:

Response File:

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_BASE=/u01/app/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=oper

oracle.install.db.OSBACKUPDBA_GROUP=backupdba

oracle.install.db.OSDGDBA_GROUP=dgdba

oracle.install.db.OSKMDBA_GROUP=kmdba

oracle.install.db.OSRACDBA_GROUP=racdba

oracle.install.db.rootconfig.executeRootScript=false

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

oracle.install.db.config.starterdb.memoryOption=false

oracle.install.db.config.starterdb.installExampleSchemas=false

oracle.install.db.config.starterdb.omsPort=0

oracle.install.db.config.starterdb.enableRecovery=false

Execution of root.sh:

[Admin@Server ~]$ sudo /u01/app/oracle/product/19c/db_1/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/19c/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

The contents of "dbhome" have not changed. No need to overwrite.

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 

[n]: y

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :

    /u01/app/oracle/product/19c/db_1/bin/tfactl

Note :

1. tfactl will use TFA Service if that service is running and user has been granted access

2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed

ok -> Exit.

References

This tutorial follows the official docs as reference Database Installation Guide for Linux.