How to enable Oracle 11g XA
We recently migrated to Oracle 11g from MSSQL and quite completely to that. Can anyone tell me how to enable XA transactions in Oracle? From what I've put together, I think I need to run initjvm.sql and initxa.sql, but I'm not entirely sure. Is there a way to do this through Enterprise Manager? Also, what is the XA driver class called? Is it oracle.jdbc.xa.client.OracleXADatasource?
+1
source to share
1 answer
Read this official Oracle article:
https://community.oracle.com/thread/920935
And this:
http://www.orafaq.com/wiki/XA_FAQ
And . You must execute $ ORACLE_HOME / rdbms / admin / xaview.sql as sysdba in order to create the generated XA views.
Possibly a Metalink comment: Required Grants for Retail Integration Bus Distributed XA Transaction-467466.1 Would Help.
0
source to share