Configuring Oracle for XA
- Oracle 10.2.0.3 and lower
- Oracle 10.2.0.4, 11g and higher
Oracle 10.2.0.3 and lower
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:
- logon to SQLPlus (or use another tool if you like); make sure to use the user/password that you are using for your application
- execute the query: select * from SYS.DBA_PENDING_TRANSACTIONS;
If this works then XA is configured.
If not then you should do one or all of the following:
- run the oracle scripts 'initxa.sql' and 'xaview.sql' (or ask your DBA to do this for you).
- ask your DBA to grant select rights (to your user) on SYS.DBA_PENDING_TRANSACTIONS
- for the driver ojdbc14.jar, you also need execute rights on SYS.DBMS_SYSTEM
The last step is NOT needed for the older (JDK 1.2) drivers in classes12.jar
Oracle 10.2.0.4, 11g and higher
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.