NOTE: this tip was written with Oracle DBMS version 10.2.0.2.0
How can you know if your Oracle server is correctly configured for XA?
The simplest and usually the most effective way is the following:
If this works then XA is configured.
If not then you should do one or all of the following:
The last step is NOT needed for the older (JDK 1.2) drivers in classes12.jar
For Oracle 10.2.0.4 and up, you no longer need execute rights on SYS.DBMS_SYSTEM. This was fixed in Oracle 10.2.0.4 (BUG 5945463).
Make sure you are also using client driver ojdbc14 version 10.2.0.4 and up.
grant execute on dbms_xa to <user> ; grant select on pending_trans$ to <user>; grant select on dba_2pc_pending to <user>; grant select on dba_pending_transactions to <user>;