You can configure Oracle Data Guard
to be used with IBM® Business Process Manager. 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 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
- Set up the Oracle Data Guard environment.
- Create a database service from the primary database:
Exec DBMS_SERVICE.CREATE_SERVICE('BPM','BPM');
- 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('BPM'); END IF;END
Note: When
you start a database, your primary database always starts a BPM service.
Therefore, your client always connects to the primary database.
- Restart the primary database or start the following service
by running the following command:
EXEC DBMS_SERVICE.START_SERVICE('BPM');
- Install the IBM Business Process Manager.
- 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 that you 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:
- 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))
)