For information on how to configure WebLogic Server for use with the Oracle Thin/XA Driver, see Using API Extensions in JDBC Drivers in Developing JDBC Applications for Oracle WebLogic Server.

1. Log on to sqlplus as system user, for example, sqlplus sys/password@<DATABASE ALIAS NAME>
2. Execute the following command: @xaview.sql

   The xaview.sql script resides in the $ORACLE_HOME/rdbms/admin directory

3. All database users for which XA data sources are defined need to be granted the following permissions individually or through one or more roles:

   • grant select on v$xatrans$ to <user/role>;

   • grant select on pending_trans$ to <user/role>;

   • grant select on dba_2pc_pending to <user/role>;

   • grant select on dba_pending_transactions to <user/role>;

   • grant execute on dbms_xa to <user/role>;

   • grant force any transaction to <user/role>;

   Where <user/role> is either a data base user or a role.

   Note:

   The Force Any Transaction permission, allows multiple users to rollback pending Oracle transaction branches. In absense of this permission, if a user attempts to rollback a recovered transaction branch created by a different user, the XAResource.rollback() operation fails with the errors:

   ORA-24774: cannot switch to specified transaction
   ORA-01031: insufficient privileges