This chapter describes procedures for preparing your database for an Oracle Service-Oriented Architecture (SOA) enterprise deployment.
This chapter includes the following topics:
Overview of Preparing the Database for an Enterprise Deployment
Using SecureFiles for Large Objects (LOBs) in an Oracle Database
Implementing a Database Growth Management Strategy for Oracle SOA Suite
This chapter provides information about how to configure a supported database as part of an Oracle Fusion Middleware enterprise deployment.
Most Oracle Fusion Middleware products require a specific set of schemas that must be installed in a supported database. The schemas are installed using the Oracle Fusion Middleware Repository Creation Utility (RCU).
In an enterprise deployment, Oracle recommends a highly available Real Application Clusters (Oracle RAC) database for the Oracle Fusion Middleware product schemas.
Check that the database meets the requirements described in these subsections:
Use the following information to verify what databases are supported by each Oracle Fusion Middleware release and which version of the Oracle database you are currently running:
For a list of all certified databases, refer to Oracle Fusion Middleware Supported System Configurations.
To check the release of your database, query the PRODUCT_COMPONENT_VERSION
view:
SQL> SELECT VERSION FROM SYS.PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle%';
Oracle Fusion Middleware requires that the database supports the AL32UTF8 character set. Check the database documentation for information on choosing a character set for the database.
For enterprise deployments, Oracle recommends using GridLink data sources to connect to Oracle RAC databases. To use the Oracle Single Client Access Name (SCAN) feature with GridLink, the Oracle RAC database version must be Oracle Database 11g Release 2 (11.2) or later, Enterprise Edition.
Note:
For more information about using GridLink data sources and SCAN, see "Using Active GridLink Data Sources" in Administering JDBC Data Sources for Oracle WebLogic Server.In the enterprise topology, there are two database host computers in the data tier that host the two instances of the RAC database. We refer to these hosts as DBHOST1 and DBHOST2.
Before you install or configure the enterprise topology, you must be sure the following software is installed and available on DBHOST1 and DBHOST2:
Oracle Clusterware
For more information, see the Oracle Grid Infrastructure Installation Guide for Linux.
Oracle Real Application Clusters
For more information, see the Oracle Real Application Clusters Installation Guide for Linux and UNIX.
Time synchronization between Oracle RAC database instances
The clocks of the database instances being used by servers in a Fusion Middleware cluster that is configured with server migration must be in sync.
Automatic Storage Management (optional)
For more information, see the Oracle Automatic Storage Management Administrator's Guide.
Table 9-1 lists some of the typical Oracle SOA Suite enterprise topologies and the value you should use when setting the PROCESSES initialization parameter for each topology.
Use this information as a guide when configuring the Oracle RAC database for an enterprise deployment.
Table 9-1 Required Initialization Parameters
Configuration | Parameter | Required Value | Parameter Class |
---|---|---|---|
SOA |
300 or greater |
Static |
|
BAM |
|
100 or greater |
Static |
SOA and BAM |
|
400 or greater |
Static |
SOA and OSB |
|
800 or greater |
Static |
To check the value of the initialization parameter using SQL*Plus, you can use the SHOW PARAMETER command.
As the SYS user, issue the SHOW PARAMETER command as follows:
SQL> SHOW PARAMETER processes;
Set the initialization parameter using the following command:
SQL> ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
Restart the database.
The method that you use to change a parameter's value depends on whether the parameter is static or dynamic, and on whether your database uses a parameter file or a server parameter file.
Note:
See the Oracle Database Administrator's Guide for details on parameter files, server parameter files, and how to change parameter values.When multiple Oracle Fusion Middleware products are sharing the same database, each product should be configured to connect to a separate, dedicated database service.
For more information about connecting to Oracle databases using services, see "Overview of Connecting to Oracle Database Using Services and VIP Addresses" in the Oracle Real Application Clusters Administration and Deployment Guide.
In addition, the database service should be different from the default database service. For complete instructions on creating and managing database services, see "Introduction to Automatic Workload Management" in the Oracle Real Application Clusters Administration and Deployment Guide.
Run-time connection load balancing requires configuring Oracle RAC Load Balancing Advisory with service-level goals for each service for which load balancing is enabled.
You can configure the Oracle RAC Load Balancing Advisory for SERVICE_TIME
or THROUGHPUT
. Set the connection load balancing goal to SHORT. For 11g Release 1 databases, use the DBMS_SERVICE
package for this modification. For 11g Release 2, use the srvctl
command utility instead.
You can create and modify database services using the srvctl
utility.
Note:
The instructions in this section are for the Oracle Database 11g Release 2 (11.2) release. If you are using another supported database, refer to the appropriate documentation library for more up-to-date and release-specific information.To create and modify the database services:
Logon to SQL*Plus and create the service:
sqlplus "sys/password as sysdba" SQL> EXECUTE DBMS_SERVICE.CREATE_SERVICE (SERVICE_NAME => 'soaedg.example.com', NETWORK_NAME => 'soaedg.example.com' );
Note:
For the Service Name of the Oracle RAC database, use lowercase letters, followed by the domain name. For example:soaedg.example.com
Note:
Enter theEXECUTE DBMS_SERVICE
command shown on a single line.
For more information about the DBMS_SERVICE
package, see Oracle Database PL/SQL Packages and Types Reference.
Add the service to the database and assign it to the instances using srvctl
:
srvctl add service -d soadb -s soaedg.example.com -r soadb1,soadb2
Start the service:
srvctl start service -d soadb -s soaedg.example.com
Note:
For complete instructions on creating and managing database services with SRVCTL, see "Administering Services with SRVCTL" in the Oracle Real Application Clusters Administration and Deployment Guide.Modify the service for the appropriate service goals:
srvctl modify service -d soadb -s soaedg.example.com -B SERVICE_TIME -j SHORT
Or
srvctl modify service -d soadb -s soaedg.example.com -B THROUGHPUT -j SHORT
For more information about the different service definitions, see "Load Balancing Advisory" in the Oracle Real Application Clusters Administration and Deployment Guide.
Beginning with Oracle Database 11g Release 1, Oracle introduced SecureFiles, a new LOB storage architecture. Oracle recommends using SecureFiles for the Oracle Fusion Middleware schemas, in particular for the Oracle SOA Suite schemas.
For more information, see "Using Oracle SecureFiles LOBs" in the Oracle Database SecureFiles and Large Objects Developer's Guide.
In Oracle 12c Databases, the default setting for using SecureFiles is PREFERRED . This means that the database attempts to create a SecureFiles LOB unless BasicFiles LOB is explicitly specified for the LOB or the parent LOB (if the LOB is in a partition or sub-partition). The Oracle Fusion Middleware schemas do not explicitely specify BasicFiles, which means that Oracle Fusion Middleware LOBs will default to SecureFiles when installed in an Oracle 12c database.
For Oracle 11g databases, the db_securefile
system parameter controls the SecureFiles usage policy. This parameter can be modified dynamically. The following options can be used for using SecureFiles:
"PERMITTED: allows SecureFiles to be created (This is the default setting for db_securefile. The default storage method uses BasicFiles)
"FORCE: create all (new) LOBs as SecureFiles
"ALWAYS: try to create LOBs as SecureFiles, but fall back to BasicFiles if not possible (if ASSM is disabled)
Other values for the db_securefile parameter are:
"IGNORE: ignore attempts to create SecureFiles
"NEVER: disallow new SecureFiles creations
For Oracle 11g Databases, Oracle recommends that you set db_securefile parameter to FORCE before creating the Oracle Fusion Middleware schemas with the Repository Creation Utility (RCU).
Note that the SecureFiles segments require tablespaces managed with automatic segment space management (ASSM). This means that LOB creation on SecureFiles will fail if ASSM is not enabled. However the Oracle Fusion Middleware tablespaces are created by default with ASSM enabled. As a result, with the default configuration, nothing needs to be changed in order to enable SecureFiles for the Oracle Fusion Middleware schemas.
At key points in the installation and configuration of an enterprise deployment, this guide recommends that you back up your current environment. For example, after you install the product software and create the schemas for a particular Oracle Fusion Middleware product, you should perform a database backup. Performing a backup allows you to perform a quick recovery from any issue that may occur in the later configuration steps.
You can choose to use your own backup strategy for the database, or you can simply make a backup using operating system tools or RMAN for this purpose.
Oracle recommends using Oracle Recovery Manager for the database, particularly if the database was created using Oracle Automatic Storage Management. If possible, you can also perform a cold backup using operating system tools such as tar.
An Oracle SOA Suite enterprise deployment presents several challenges for database administrators, including managing the growth of the Oracle SOA Suite database. Underestimating the importance of managing the database can lead to issues when the database is moved to a production environment.
For information about determining an appropriate strategy and planning for capacity, testing, and monitoring, see "Introduction to Planning for Database Growth" in the Administering Oracle SOA Suite and Oracle Business Process Management Suite.