Enabling XA in the Database
You must perform some special steps to enable crash recovery of Oracle resources following a reboot after a crash. Although the database will handle XA database transactions fine, you must perform these steps to enable the WebLogic Server transaction manager to perform a crash recovery of an XA resource. Here are the steps:
1. Log in to the Oracle database as the user sys:
SQL> connect sys/<password> as sysdba
2. Execute the following script:
SQL> @$ORACLE_HOME/rdbms/admin/xaview.sql
3. The xaview.sql script creates the necessary views to perform a recovery scan of prepared statements. Execute the following commands to grant various permissions on the views:
SQL> grant select on v$xatrans$ to public; SQL> grant ...
Get Oracle WebLogic Server 11g Administration Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
