Oracle Database - OpenShift(4.3)

This section describes how to configure for Oracle as a platform database instead of the default Derby database.

Note!

This section is optional and can be omitted if you are doing the default installation with the Derby database or are planning to use a PostgreSQL database.

will not provide the Oracle docker images or Oracle helm chart for this installation, so you will have to create them, see below.

Prerequisites

If you choose to use Oracle as your platform database, you must install your own instance prior to platform deployment.

Get or create an Oracle docker image and upload it to your Docker container. For supported Oracle versions, see Platform Databases[hide]3.0[/hide].
To create Oracle images, see https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance
Be aware that both disk space and memory is normally quite demanding for an Oracle image, typically 40 GB disk-space and 8 GB ram.

Oracle 3PPs

Using Oracle as a platform database requires some Oracle 3PPs that are not bundled. Therefore these 3PPs need to be made available via persistent storage.

Instructions on how to configure persistent storage for can be found here: Persistent Storage (3.0).

Once the persistent storage configuration has been made, please make the required 3PPs available on the persistent storage using the following steps:

Download Oracle 3PPs

Download the following 3PPs locally:

JDBC driver	https://www.oracle.com/se/database/technologies/appdev/jdbc-downloads.html
Instant Client Basic Lite	https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-basiclite-19.9.0.0.0-1.x86_64.rpm
SQL*Plus Package	https://download.oracle.com/otn_software/linux/instantclient/199000/oracle-instantclient19.9-sqlplus-19.9.0.0.0-1.x86_64.rpm

Upload 3PPs to persistent storage

Create a 3pp folder in the persistent storage root folder:

$ ssh <persistent storage host>
$ mkdir <persistent storage root>/3pp
$ exit

Transfer the 3pp files:

Example, in this case ojdbc8 is used.

$ scp oracle-instantclient19.9-basiclite-19.9.0.0.0-1.x86_64.rpm <persistent storage host>:<persistent storage root>/3pp
$ scp oracle-instantclient19.9-sqlplus-19.9.0.0.0-1.x86_64.rpm <persistent storage host>:<persistent storage root>/3pp
$ scp ojdbc8.jar <persistent storage host>:<persistent storage root>/3pp

Configure Helm Chart for Oracle Database

Edit the oracle section in the values.yaml file of the helm chart to match the Oracle installation where the platform database shall be created.

Create platform tables for the Oracle database

The subsections describe the installation of the database tables that are necessary when using Oracle as a platform database.