Chapter 2. Building a 3scale API Management system image with the Oracle Database relational database management system

Create a new database

The following settings are required for the Oracle Database to work with 3scale:

ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

ALTER SYSTEM SET compatible='12.2.0.1' SCOPE=SPFILE;

Collect the database details.

Get the following information that will be needed for 3scale configuration:

run the oc new-app command with the -f option and specify the build.yml OpenShift template

$ oc new-app -f build.yml

run the oc new-app command with the -f option, specifying the amp.yml OpenShift template, and the -p option, specifying the WILDCARD_DOMAIN parameter with the domain of your OpenShift cluster

$ oc new-app -f amp.yml -p WILDCARD_DOMAIN=example.com

enter the following shell for loop command, specifying the following information you collected in the Preparing Oracle Database section previously:

enter the following oc patch command, specifying the same USER, PASSWORD, ORACLE_DB_URL, PORT, and DATABASE values that you provided in the previous step above:

$ oc patch dc/system-app -p '[{"op": "replace", "path": "/spec/strategy/rollingParams/pre/execNewPod/env/1/value", "value": "oracle-enhanced://{USER}:{PASSWORD}@{ORACLE_DB_URL}:{PORT}/{DATABASE}"}]' --type=json

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 '[{"op": "add", "path": "/spec/strategy/rollingParams/pre/execNewPod/env/-", "value": {"name": "ORACLE_SYSTEM_PASSWORD", "value": "SYSTEM_PASSWORD"}}]' --type=json

enter the oc start-build command to build the new system image:

oc start-build 3scale-amp-system-oracle --from-dir=.