DB Cloud Appendix

Properties File Format

The properties file is closely based on the Oracle REST Services. If you need more information than is found in this guide, please see the Oracle documentation.

The format of the properties file is as follows:

Property Name	Required	Description
version	No	Oracle Database version for the service instance
level	No	Service level for the service instance. `PAAS` or `BASIC` (Defaults to `PAAS`)
edition	No	Oracle Database edition for the service instance. (`SE, EE, EE_HP, EE_DP`)
subscription	No	A string containing the billing frequency for the service instance, either `MONTHLY` or `HOURLY`
description	No	Description of the service instance
shape	Yes	The Oracle Compute Cloud shape for the service instance, to be created. (`oc3, oc4, oc5, oc6, oc7, oc1m, oc2m, oc3m, oc4m, oc5m`)
vmPublicKeyText	Yes	The text of an SSH public key for the VM. This key is added to Oracle Compute Cloud Service as part of the instance creation operation. This should be a String starting with `ssh-rsa`.
parameter.usableStorage	No	The number of GB of usable data storage for the Oracle Database server. Include this parameter only if level is "`PAAS`"
parameter.adminPassword	No	The administration password for the service instance. Include this parameter only if level is "`PAAS`"
parameter.sid	No	The SID for the database instance. Include this parameter only if level is "`PAAS`"
parameter.pdb	No	The name for the default PDB (pluggable database). Include this parameter only if level is "`PAAS`"
parameter.backup Destination	No	The backup configuration for the service instance. Include this parameter only if level is "`PAAS`". (`BOTH, DISK, NONE`)
parameter.cloudStorage Container	No	Oracle Storage Cloud container for backups. Include this parameter only if level is "`PAAS`". Defaults to `FDDB_CLOUD_INSTANCE_NAME + "BK"` . The container is automatically created if it doesn't already exist in the Storage Cloud.
parameter.cloudStorage User	No	The user name of an Oracle Cloud user with read/write access to the specified parameter.cloudStorageContainer. Include this parameter only if level is "`PAAS`" and the parameter.backupDestination is "`BOTH`"
parameter.cloudStoragePwd	No	The password for parameter.cloudStorageUser. Include this parameter only if level is "`PAAS`"

This plugin is designed to accommodate changes in Oracle’s REST API. It will pass all properties that don’t start with parameter. as top-level data in the JSON request, and pass each parameter. data as data inside the parameters section. Any properties that Oracle supports can be used even if not listed in the table above. If there is a validation error, the error message can be used to troubleshoot.

Here is an example error message from leaving a field blank:

SEVERE - flexagon.ff.common.core.exceptions.FlexCheckedException.init() - FDDBCloud-00201: The value of the [shape] parameter cannot be empty.

This means that you need to send in shape={something}

If you set it to an invalid value, you will receive an error like this:

SEVERE - flexagon.ff.common.core.exceptions.FlexCheckedException.init() - FDSC-00051: Unexpected status code 503 - Service Unavailable

See https://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/GUID-9ECC81E2-7356-4E2C-91A9-315D7E42C203.htm#CSDBI-GUID-9ECC81E2-7356-4E2C-91A9-315D7E42C203 for more information about Oracle’s API.