Support for Oracle Database using non-CDB architecture

Solution Verified - Updated -

Environment

  • Red Hat 3scale API Management Platform 2.4
  • Red Hat 3scale API Management Platform 2.5

Issue

  • 3scale 2.4 and 3scale 2.5 do not support Oracle DB using a non-CDB architecture.

Resolution

3scale 2.4 can be deployed using 3scale 2.4 System Image built with Oracle Database support . 3scale 2.5 can be deployed using 3scale 2.5 System Image built with Oracle Database support . The System images work with Oracle DB using a containerized database architecture. When Oracle DB is setup using a non containerized database (non-CDB) architecture, a workaround is needed. The workaround modifies the steps described in 3scale 2.4 Building the system image or 3scale 2.5 Building the system image . The workaround was added to the released versions 3scale 2.4.0.GA and 3scale 2.5.0.GA and the releases were re tagged.

3scale 2.4 Building the system image Modifications

1) Perform the steps 1-7 in Building the system image
2) Enter the following oc patch command, specifying your own Oracle Database system user password in the SYSTEM_PASSWORD field:

   $ oc patch dc/system-app -p '{"spec": {"strategy": {"rollingParams": {"post":{"execNewPod": {"env": [{"name": "ORACLE_SYSTEM_PASSWORD", "value": "SYSTEM_PASSWORD"}]}}}}}}'

3) Apply the patch in workaround-non-cdb-2.4-upgrade as shown below:

   patch -p1 < workaround-non-cdb-2.4-upgrade/dockerfile.patch

4) Perform Step 8 in Building the system image

3scale 2.5 Building the system image Modifications

1) Perform the steps 1-7 in Building the system image
2) Enter the following oc patch command, specifying your own Oracle Database system user password in the SYSTEM_PASSWORD field:

   $ oc patch dc/system-app -p '{"spec": {"strategy": {"rollingParams": {"post":{"execNewPod": {"env": [{"name": "ORACLE_SYSTEM_PASSWORD", "value": "SYSTEM_PASSWORD"}]}}}}}}'

3) Apply the patch in workaround-non-cdb-2.5-upgrade as shown below:

   patch -p1 < workaround-non-cdb-2.5-upgrade/dockerfile.patch

4) Perform Step 8 in Building the system image

Root Cause

3scale 2.4 and 3scale 2.5 without workaround only work with Oracle DB using a CDB architecture.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments