Oracle Database - OpenShift(4.0)

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. 

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:

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.