How to check if XA transactions are enabled?
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...