Oracle

A distinct database schema is required.

Follow the same steps as for creating the ConSol CM database (see section Oracle). Use as database name cmrfdatabase and user cmrf.

Transactions recovery

The following settings must be applied for the user accessing an Oracle XA data source in order for XA recovery to operate correctly. The value cmrf is user-defined to connect from JBoss to Oracle:

GRANT SELECT ON sys.dba_pending_transactions TO cmrf;

GRANT SELECT ON sys.pending_trans$ TO cmrf;

GRANT SELECT ON sys.dba_2pc_pending TO cmrf;

GRANT EXECUTE ON sys.dbms_xa TO cmrf; --If using Oracle 10g R2 (patched) or later

--OR

GRANT EXECUTE ON sys.dbms_system TO cmrf; --If using an unpatched Oracle version prior to 11g