Database Administration (MOSC)

MOSC Banner

Oracle configuration required for XA Transactions

edited Jan 24, 2009 2:00AM in Database Administration (MOSC) 1 commentAnswered
 Could someone please point me to an article or manual which details the settings (grants) required for Oracle to be used with XA Transactions in a J2EE environment. I have found numerous articals (via Google) but they are all not definitive (only theory from individuals).

Our stack is Websphere and Oracle 10.2.0.4.

In order for XA to work we require our end uses to run the following script as the SYS user:

GRANT SELECT ON pending_trans$ TO &BANKREC_USER;
GRANT SELECT ON dba_2pc_pending TO &BANKREC_USER;
GRANT SELECT ON dba_pending_transactions TO &BANKREC_USER;
GRANT EXECUTE ON dbms_system TO &BANKREC_USER;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center