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

Procedure

1. 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;

   Copy to Clipboard Toggle word wrap

2. Collect the database details.

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

   • Oracle Database URL
   • Oracle Database service name

   • Oracle Database system password

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

       Example

       DATABASE_URL="oracle-enhanced://user:password@my-oracle-database.com:1521/threescalepdb"

       Copy to Clipboard Toggle word wrap

Procedure

1. Clone the 3scale API Management OpenShift Templates GitHub repository. Use the following command:

   $ git clone --branch 2.7.1.GA https://github.com/3scale/3scale-amp-openshift-templates.git

   Copy to Clipboard Toggle word wrap
2. Place your Oracle Database Instant Client Package files into the 3scale-amp-openshift-templates/amp/system-oracle/oracle-client-files directory.
3. Download the 3scale 2.7 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

   Copy to Clipboard Toggle word wrap

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

   Copy to Clipboard Toggle word wrap

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"}]}}}}}}'

   Copy to Clipboard Toggle word wrap

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

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

   Copy to Clipboard Toggle word wrap

8. Link the pull secret to the builder with the following command:

   $ oc secrets link builder threescale-registry-auth

   Copy to Clipboard Toggle word wrap

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

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

   Copy to Clipboard Toggle word wrap