Configuring Oracle Real Application Cluster (RAC) for use with IBM Business Process Manager
Oracle Real Application Clusters (RAC) is an option of an Oracle database that brings together two or more computers to form a clustered database that behaves as a single system. In a RAC database, Oracle processes that run in separate nodes access the same data from a shared disk storage.
About this task
- If you use Oracle 11g R2 with the SCAN feature, no additional manual configuration is required.
- If you do not use the SCAN feature or use an earlier version of Oracle that does not support the SCAN feature, you must complete the following procedure to configure IBM® Business Process Manager for use with Oracle RAC. For more information, see Mapping IBM Business Process Manager configuration parameters to Oracle setup parameters.
IBM Business Process Manager always
creates the JDBC URL in the following format
jdbc:oracle:thin:@//[LISTENER_HOST][:LISTENER_PORT]/SERVICE
which
can be edited to the following format to use Oracle RAC:jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=rac-node1)(port=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=rac-node2)(port=1521)))
(FAILOVER=on)(LOAD_BALANCE=on)
(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME=<service_name>)))
If a Oracle RAC node failover occurs, IBM Business Process Manager stops processing and you might need to restart all of the IBM Business Process Manager nodes. If you experience process-recovery issues, refer to Process recovery issues in certain situations in IBM Business Process Manager V7.5.
Procedure
Mapping IBM Business Process Manager configuration parameters to Oracle setup parameters
About this task
The
format of the JDBC URL that is generated during configuration is
jdbc:oracle:thin:@//[LISTENER_HOST][:LISTENER_PORT]/SERVICE
where
- LISTENER_HOST represents the RAC SCAN name that is defined during the Oracle RAC setup. If you do not use Oracle RAC, LISTENER_HOST is specified in the IBM BPM profile configuration parameter Database server host name.
- LISTENER_PORT represents the RAC SCAN listener port that is defined during the Oracle RAC setup. If you do not use Oracle RAC, LISTENER_PORT is specified in the IBM BPM profile configuration parameter Server port.
- SERVICE represents the RAC service that is configured during the Oracle RAC setup. If you do not use Oracle RAC, SERVICE is specified in the IBM BPM profile configuration parameter Common database name, for example, SID.