Install Oracle 19c – RPM Package Mode

Simple and easy, as it should always be.

For years I wanted to witness this moment, install oracle database in a single, simple and fast method.

With the current CI-CD paradigm, continuous deployments, continuous delivery and continuous integration, Oracle really had to provide such a solution.

Through this methodology, which involves performing the installation and configuration of the database, in a simple and agile way, it can be part of a Jenkins process or TeamCity job.

We are going to review the steps that we are going to execute:

• Configuration of the Operating System and Download Packages.
• Installation of the database Software.
• Install a Database, Oracle 19, Container and a PDB.
• Install Listener and OS Services.

Hands On

Obtain the RPM file and configure the Operating System

On my case , I use Oracle Linux.

Oracle Linux Server release 7.2

I’m login as root , execute the yum commands.

Obviosly, I have configurated and our OS, have access to internet.

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

If you run the Red Hat Operating system, you can download the RPM necessary to start with configuration from here:

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

We are ready to start with our RPM installation.

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

Installation of Oracle Database

Here we begin with the download of the package to be able to install.
This installation, when executed deploy:

• A ORACLE_HOME.
• A container database (CDB).
• A Puglable Database. (PDB)
• Leave a listener and operating system service configured to manage restarts.
• All of this is configurable to perform custom installations.

Lets go and download the packages from oracle official site :

After finished the dowloand, please, choise a path on your operating system as /tmp and start with installation, with the command at below:

yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm

Here I shared my installation experience:

And the installation of oracle database software is now complete to start the next step, create a container, pdbs and services.

Creating and Configuring an Oracle Database 19c

In this step, we are going to install our database, in a simple and clear way.
Please verify, in our /etc/ hosts file, that the assigned IP corresponds to the name of our hostname.
If it is not found correctly, it can cause the installation to fail.

By default, the oracle script will create an container ORCLCDB and ORCLPDB1.

But , if you prefer you can will change this option in the future to automatization the Deployed as part of the CI CD process.

This configuration file have the necesary information:

/etc/sysconfig/oracledb_ORCLCDB-19c.conf

And the script that we run in some minutes, its configurable too.

/etc/init.d/oracledb_ORCLCDB-19c

Now, we start with the oracle database installation of software and database, as root we need execute this sentence:

# /etc/init.d/oracledb_ORCLCDB-19c configure

Finally, our database oracle installation is finished.

Now, with the following query, I will check the containers and PDB’s created.

COLUMN NAME FORMAT A8
SELECT NAME, CON_ID, DBID, CON_UID, GUID 
FROM V$CONTAINERS ORDER BY CON_ID;

Simple and easy, as it should always be.