IBM BPM, V8.0.1, All platforms > Install and configure IBM BPM > IBM BPM Advanced: Process Server > Install and configure IBM BPM Advanced: Process Server > On Windows > Network deployment environment > Modify an existing installationConfigure Oracle Real Application Cluster (RAC) for use with IBM BPM
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 are running in separate nodes access the same data from a shared disk storage.
About this task
The configuration method is different for different Oracle RAC versions:
- If you are using Oracle 11g R2 with the SCAN feature, IBM BPM does not need additional manual configuration if you specify the service name during profile creation or topology configuration. jdbc:oracle:thin:@//[SCAN_LISTENER_HOST][:SCAN_LISTENER_PORT]/SERVICE is the format of the JDBC URL generated during configuration and will work for Oracle RAC without any manual updates.
- If you do not want to use the SCAN feature or are using an earlier version of Oracle that does not support the SCAN feature, you must use the following configuration steps to configure IBM BPM for use with Oracle RAC. There are two scenarios to consider:
- If you are using a Standalone profile you need to create the profile using SID as the value for the database name.
- If you are setting up a ND environment, the profiles and the clusters need to be configured using SID.
IBM BPM always creates the JDBC URL in the following format: jdbc:oracle:thin:@//[SCAN_LISTENER_HOST][:SCAN_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 BPM stops processing and you might need to restart all of the IBM BPM nodes.
If you experience process-recovery issues, refer to Process recovery issues in certain situations in IBM BPM V7.5.
Procedure
Parent topic: Modify an existing installation
- Specify the RAC URL as the Oracle URL when defining the relevant Oracle JDBC data sources.
Refer to Configure a data source using the administrative console.
- In the administrative console, select Resources > JDBC > Data sources.
- Edit all of the data sources using Oracle with the JDBC URL to use one of the preceding formats.
- Update the Authentication Alias Configuration page and run the administrative task to update the URL to use the Oracle RAC. See Modify authentication aliases.
- In an ND environment, you must synchronize the nodes that contain Process Center, Process Server, or Performance Data Warehouse cluster members.
- In the administrative console, click System administration > Nodes.
- Select all of the nodes and click Full Resynchronize.
- Stop and restart all of the clusters and servers.