RHQ Tip of the day: XA issues with oracle ?

Are you running Jopr, RHQ or JBoss ON 2 with Oracle and see the following warnings in the servers logfiles:

 

 

14:05:51,406 WARN [loggerI18N] [com.arjuna.ats.internal.jta.recovery.xarecovery1] Local XARecoveryModule.xaRecovery got XA exception javax.transaction.xa.XAException, XAException.XAER_RMERR

Then you need to set up your Oracle user for XA mode:

GRANT SELECT ON sys.dba_pending_transactions TO rhqadmin;

GRANT SELECT ON sys.pending_trans$ TO rhqadmin;

GRANT SELECT ON sys.dba_2pc_pending TO rhqadmin;

GRANT EXECUTE ON sys.dbms_system TO rhqadmin;



This is also described in the Jopr installation page on the JBoss.org Wiki (and of course in the JBoss ON manual)