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!

How to check if XA transactions are enabled?

769379Apr 27 2010
Hi. I have some problems with Oracle 10 and Websphere AS 6.1. I think I enabled XA transactions doing the following:

sql>create spfile from pfile
sql>shutdown immediate
sql>startup
sql>ALTER SYSTEM SET JAVA_POOL_SIZE=120M scope=spfile;
sql>ALTER SYSTEM SET SHARED_POOL_SIZE=240M scope=spfile;
sql>create pfile from spfile;
sql>shutdown immediate;
sql>startup;
sql>@C:\oracle\ora10g\javavm\install\initjvm.sql;
sql>@C:\oracle\ora10g\javavm\install\initxa.sql;
sql>grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to icmadmin;
sql>grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to system;
sql>shutdown immediate;
sql>startup;
sql>exit;

(found here: http://publib.boulder.ibm.com/infocenter/irm/v8r5m0/index.jsp?topic=/com.ibm.installingirm.doc/rminst0134.htm)

I am not sure if my current problem occurs because XA transactions are still not enabled, or if there is another problem too. So, how can I check whether XA transactions are enabled in the oracle db or not?

Thank you a lot for help...

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 25 2010
Added on Apr 27 2010
0 comments
2,092 views