Configuring Transaction Recovery (Oracle only)

Ensure that the BPM database user has sufficient privileges to enable the ActiveMatrix BPM runtime to perform transaction recovery. (If a separate BDS user has been created, that user must also be given privileges to perform transaction recovery.)

Note: ActiveMatrix shared resources that are XA-enabled participate in global transactions (coordinated by the transaction manager within a TIBCO host instance). If the TIBCO host instance fails, the shared resources can update themselves to the decided state of the global transaction when they recover. For more information, see "Transaction Recovery" in TIBCO ActiveMatrix BPM - SOA Administration.

Procedure

  1. Connect to the Oracle database server as a user that has SYSDBA system privilege. For example:

    SQL > connect sys/password as sysdba

  2. Execute the following SQL statements:

    GRANT SELECT ON sys.dba_pending_transactions TO user

    GRANT EXECUTE ON sys.dbms_xa TO user

    GRANT SELECT ON sys.dba_2pc_pending TO user

    where user is the name of the BPM database user (as defined by the Username field in the ActiveMatrix BPM: Runtime Database Configuration screen of the Create TIBCO ActiveMatrix BPM Server Wizard - for example, bpmuser).