IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced > Prepare to install the software

Configure Oracle Data Guard for IBM BPM

You can configure Oracle Data Guard to be used with IBM BPM. Oracle Data Guard provides high availability, disaster recovery, and data protection and is used to create, manage, and monitor one or more standby databases so that production Oracle databases can survive disasters and data corruptions.

When IBM BPM is configured to use Oracle Data Guard, you typically have one production database, which is your primary database, and several standby databases. Then Oracle Data Guard automatically maintains each standby database by transmitting redo data from the primary database and applying the redo data to the standby database. If your production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard enables you to switch any standby database to the production role, minimizing the downtime that is associated with the outage.

Oracle Data Guard automatically maintains each standby database by transmitting redo data from the primary database and then applying the redo to the standby database.

A Typical Data Guard Configuration

Procedure

1. Set up the Oracle Data Guard environment.

2. Create a database service from the primary database:

   Exec DBMS_SERVICE.CREATE_SERVICE('BPM','BPM');

3. Create a trigger from the primary database by running the following command:

   CREATE OR REPLACE TRIGGER START_SERVICES AFTER STARTUP ON DATABASE 
   DECLARE
    ROLE VARCHAR(30);
   BEGIN 
    SELECT DATABASE_ROLE INTO ROLE FROM V$DATABASE;
    IF ROLE = 'PRIMARY' THEN
     DBMS_SERVICE.START_SERVICE('ORCL');  END IF;
   END; 
   /

   When you start a database, your primary database always starts a BPM service. Therefore, your client always connects to the primary database.

4. Restart the primary database or start the following service by running the following command:

   EXEC DBMS_SERVICE.START_SERVICE('BPM');

5. Install the IBM BPM.

6. Create profiles or a deployment environment that is similar to that of an Oracle instance database. While creating the profile, select Oracle database and connect to the database service created in step 2.

What to do next

If all your primary and the standby databases are installed on the same server, the databases share the same IP address and Oracle listening port. No further configuration is required.

However, if your primary and standby databases are installed on different servers, they will have different IP addresses and the same Oracle listening port. If your primary and standby databases are on separate servers, you must modify all data sources, after which you will have a JDBC URL that resembles the following URL:

To modify the JDBC URL:

1. Log in to the IBM BPM administrative console.

2. Go to Resources > JDBC > Data sources.
3. Modify all data sources that connect to the Oracle database with the URLs that resemble the following URL:

   jdbc:oracle:thin:@(DESCRIPTION=
   	(ADDRESS_LIST=
   	(ADDRESS=(PROTOCOL=TCP)(HOST=<host A>)(PORT=1521))
     (ADDRESS=(PROTOCOL=TCP)(HOST=<host B>)(PORT=1521))
     (ADDRESS=(PROTOCOL=TCP)(HOST=<host C>)(PORT=1521))
        (LOAD_BALANCE=off)
   			(FAILOVER=on)
   		)
              (CONNECT_DATA=(SERVICE_NAME=BPM))
   	)

Prepare to install the software

Related concepts:
System requirements
Considerations for HADR setup and configuration

Related tasks:
Preparing operating systems for product installation