Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Enable XA Oracle 11g

708336Jun 23 2009 — edited Jun 24 2009
Hi,

We recently moved to Oracle 11g from MSSQL and am completely new to this. Can someone tell me how to enable XA transactions on Oracle? From what I gathered, I think I need to run initjvm.sql and initxa.sql but I am not entirely sure. Is there someway of doing this through the Enterprise manager? Also, what is the XA driver class called? Is that oracle.jdbc.xa.client.OracleXADatasource?

Comments

591186
[http://www.orafaq.com/wiki/XA_FAQ]

also. You have to execute $ORACLE_HOME/rdbms/admin/xaview.sql to have XA releated views created.

Perhaps, Metalink note : Required Grants For Retail Integration Bus Distributed XA Transaction-467466.1 Would help.


HTH
Anantha.
Timur Akhmadeev
From what I gathered, I think I need to run initjvm.sql and initxa.sql but I am not entirely sure.
Starting with JDBC driver 10g you don't have to execute initxa.sql. Basically, before 10g JDBC driver [used a PL/SQL package|http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/xadistra.htm#BGBIDIGD] named JAVA_XA to manage distributed transactions, but with 10g it doesn't require additional database configuration, since it uses native protocol (claimed to be faster) without issuing PL/SQL.
Also, what is the XA driver class called? Is that oracle.jdbc.xa.client.OracleXADatasource?
Yes.
708336
Hi,

Thanks for the response.
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
Timur Akhmadeev
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
According to documentation - no.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 22 2009
Added on Jun 23 2009
4 comments
11,706 views