Chapter 9. Setting up your 3scale system image with an Oracle Database

Procedure

1. Create a new database.

   To configure 3scale with Oracle Database, use the following settings:

   ALTER SYSTEM SET max_string_size=extended SCOPE=SPFILE;

2. Collect the database details.

   You need the following information for 3scale configuration:

   • The Oracle Database URL address.
   • The Oracle Database. service name

   • The Oracle Database system password.

     The DATABASE_URL parameter must follow this format: oracle-enhanced://${user}:${password}@${host}:${port}/${database}

Procedure

1. Download 3scale OpenShift templates from the GitHub repository and extract the archive:

   tar -xzf 3scale-amp-openshift-templates-3scale-2.11.1-GA.tar.gz

2. Place your Oracle Database Instant Client Package files into the 3scale-amp-openshift-templates-3scale-2.11.1-GA/amp/system-oracle/oracle-client-files directory.
3. Download the 3scale 2.11 amp.yml template.

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

   $ oc new-app -f build.yml

5. Run the oc new-app command with the -f option to indicate the amp.yml OpenShift template, and the -p option to specify the WILDCARD_DOMAIN parameter with the domain of your OpenShift cluster:

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

6. Enter the following oc patch commands, replacing SYSTEM_PASSWORD with the Oracle Database system password you set up in Preparing the Oracle Database:

   $ 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
   
   $ oc patch dc/system-app -p '{"spec": {"strategy": {"rollingParams": {"post":{"execNewPod": {"env": [{"name": "ORACLE_SYSTEM_PASSWORD", "value": "SYSTEM_PASSWORD"}]}}}}}}'

7. Enter the following command, replacing DATABASE_URL to point to your Oracle Database, specified in Preparing the Oracle Database:

   $ oc patch secret/system-database -p '{"stringData": {"URL": "DATABASE_URL"}}'

8. Enter the oc start-build command to build the new system image:

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

9. Wait until the build completes. To see the state of the build, run the following command:

   $ oc get build <build-name> -o jsonpath="{.status.phase}"

   1. Wait until the build is in a Complete state.