Create an Oracle Database for Oracle SOA Suite on Marketplace

Note:

For production Oracle SOA Suite on Marketplace instances, Oracle recommends to not share the database with other Oracle SOA Suite on Marketplace instances. If one database is shared across multiple instances, restoring the database will revert the data for all instances.

Oracle SOA Suite on Marketplace supports the following databases:

Database	Supported Versions	Additional Information
Oracle Cloud Infrastructure database, with or without Oracle Real Application Clusters (RAC) Note: If you want to use RAC, you will need to create an Oracle Cloud Infrastructure database instance using the standard service level and Enterprise Edition Extreme Performance for the Oracle Database software edition	Oracle Database 19c Oracle Database 18c	Note: If you plan to enable SOAINFRA schema partitioning for your Oracle Cloud Infrastructure database, be sure to choose Enterprise Edition High Performance or Enterprise Edition Extreme Performance for the Oracle Database software edition when you create the database. See Oracle Cloud Infrastructure Database Limitations and Usage Notes, below.
Oracle Autonomous Transaction Processing (ATP) database	Oracle Database 19c Oracle Database 18c	See Oracle Autonomous Transaction Processing (ATP) Database Limitations and Usage Notes, below.
Oracle Exadata Database Service database	Oracle Database 19c Oracle Database 18c Oracle Database 11g Release 2	Oracle SOA Suite on Marketplace supports Exadata database as a backend database to create SOAINFRA schemas. If you are not familiar with Oracle Exadata Database Service, see Exadata Cloud Service in the Oracle Cloud Infrastructure documentation.

Database

Supported Versions

Additional Information

Oracle Cloud Infrastructure database, with or without Oracle Real Application Clusters (RAC)

Note: If you want to use RAC, you will need to create an Oracle Cloud Infrastructure database instance using the standard service level and Enterprise Edition Extreme Performance for the Oracle Database software edition

Oracle Database 19c
Oracle Database 18c

Note: If you plan to enable SOAINFRA schema partitioning for your Oracle Cloud Infrastructure database, be sure to choose Enterprise Edition High Performance or Enterprise Edition Extreme Performance for the Oracle Database software edition when you create the database.

See Oracle Cloud Infrastructure Database Limitations and Usage Notes, below.

Oracle Autonomous Transaction Processing (ATP) database

Oracle Database 19c
Oracle Database 18c

See Oracle Autonomous Transaction Processing (ATP) Database Limitations and Usage Notes, below.

Oracle Exadata Database Service database

Oracle Database 19c
Oracle Database 18c
Oracle Database 11g Release 2

Oracle SOA Suite on Marketplace supports Exadata database as a backend database to create SOAINFRA schemas. If you are not familiar with Oracle Exadata Database Service, see Exadata Cloud Service in the Oracle Cloud Infrastructure documentation.

Oracle Cloud Infrastructure Database Limitations and Usage Notes

You must have quota to provision the Oracle Cloud Infrastructure database.
Oracle SOA Suite on Marketplace provisioned with the Oracle Cloud Infrastructure database supports only Oracle Grid Infrastructure storage management software.

If you are using Oracle Real Application Clusters (RAC) with the Oracle Cloud Infrastructure database:

When you configure the compute shape during provisioning or scaling up a node, be sure to stay within the bounds of your available memory.
Note that Oracle SOA Suite on Marketplace uses the GridLink data source to point to the RAC database.

The following example shows a connect string used to connect to a RAC database:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=vgad c01jjfrac1)(PORT=1522))(ADDRESS=(PROTOCOL=TCP)(HOST=DBHostRAC1)(PORT=1522))(LOAD_BALANCE=ON)(FAILOVER=ON))(CONNECT_DATA=(SERVICE_NAME=PDB1.sbcs.cloud.internal)))

Name	Type	JNDI Name	Targets
`EDNDataSource`	GridLink	`jdbc/EDNDataSource`	`soaRACNo_cluster`
`EDNLocalTxDataSource`	GridLink	`jdbc/EDNLocalTxDataSource`	`soaRACNo_cluster`
`LocalSvcTblDataSource`	GridLink	`jdbc/LocalSvcTblDataSource`	`soaRACNo_adminserver`
`mds-owsm`	GridLink	`jdbc/mds/owsm`	`soaRACNo_cluster`, `soaRACNo_adminserver`
`mds-soa`	GridLink	`jdbc/mds/MDS_LocalTxDataSource`	`soaRACNo_cluster`, `soaRACNo_adminserver`
`opss-audit-DBDS`	GridLink	`jdbc/AuditAppendDataSource`	`soaRACNo_cluster`, `soaRACNo_adminserver`
`opss-audit-viewDS`	GridLink	`jdbc/AuditViewDataSource`	`soaRACNo_cluster`, `soaRACNo_adminserver`
`opss-data-source`	GridLink	`jdbc/OpssDataSource`	`soaRACNo_cluster`, `soaRACNo_adminserver`
`OraSDPMDataSource`	GridLink	`jdbc/OraSDPMDataSource`	`soaRACNo_cluster`
`SOADataSource`	GridLink	`jdbc/SOADataSource`	`soaRACNo_cluster`

Oracle Autonomous Transaction Processing (ATP) Database Limitations and Usage Notes

Oracle SOA Suite on Marketplace supports both serverless deployments and dedicated deployments (ATP-D) of the ATP database.
DBFS is not configured when using the ATP database.
Oracle SOA Suite on Marketplace supports the Database Adapter for the ATP database. See Oracle JCA Adapter for Database in Understanding Technology Adapters.
A two-node Oracle SOA Suite on Marketplace cluster consumes the maximum connections supported by one OCPU ATP database. An increase in cluster size requires a proportional increase in the OCPU count of ATP database. That is, a four-node cluster needs at least two OCPU ATP databases.
The ATP database is not supported with the Business Activity Monitoring service type.
Oracle SOA Suite on Marketplace does not support the Always Free Autonomous database. Instead, use the paid ATP database with Oracle SOA Suite on Marketplace.

Topics: