Configuring Oracle Data Guard for IBM Business Process Manager
When IBM Business Process Manager 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
What to do next
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:
- Log in to the IBM Business Process Manager administrative console.
- Go to .
- 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)) )