IBM Support

IBM WebSphere Adapter for JDBC's support for Oracle Data Guard

Question & Answer


Question

Does IBM WebSphere Adapter for JDBC support Oracle Data Guard?

Answer


IBM WebSphere Adapter for JDBC supports Oracle Data Guard with WebSphere Process Server (WPS) or WebSphere Enterprise Service Bus (WESB).

WebSphere Adapter for JDBC v7.0.0.4 onwards supports Oracle Data Guard in the following aspects, provided WebSphere Process Server, WebSphere Enterprise Service Bus, and Oracle Database are configured correctly and the necessary fixes are applied.

• The system and the deployed applications continue processing once the
database switchover is done (continuous availability).
• The applications executed at the time of the switchover remain consistent (for example, no message loss or no duplicate data).
• The overall system state remains in consistent state (for example, no unresolved
transactions and no stranded messages).

This claim is supported based on the following test environment:

WAS ND: v7.0.0.13
WPS/WESB: v7.0.0.3
JDBC Adapter v7.0.0.4
Oracle Data Guard: DBMS v11.1.0.7.0 (JDBC Driver v11.2.0.2.0)

The configuration is described as follows:

1) XA DataSource is configured in WPS. The sample connection string is as follows:

jdbc:oracle:thin:@
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=fmtc5220)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=fmtc5221)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=fmtc5162)(PORT=1521))
(LOAD_BALANCE=off)
(FAILOVER=on)
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=ORCL)
)
)

Note: Mutiple Oracle Database addresses are referenced in the connection string, which are used during the database switch.

2) Configure JDBC Adapter to use XA datasource and specify the datasource JNDI name to the preconfigured XA datasource JNDI name.

3) Ensure that Oracle has been configured to support XA transaction by executing the steps from following link:
http://www.ibm.com/support/docview.wss?uid=swg21215890


4) Apply the following Oracle and WPS settings/patches:

• Apply the patch for Oracle bug 11672297.

• Add the System Privilege FORCE ANY TRANSACTION, to the WPS recovery role and
to the WPS recovery user.

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0.0.4","Edition":"WebSphere","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"","label":"All Platforms"}],"Version":"7.0.0.4","Edition":"WebSphere","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21503023