September 2011
Intermediate to advanced
528 pages
19h 57m
English
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 ...
Read now
Unlock full access