Error occurs during recovery of Oracle database transactions

The WTRN0037: The transaction service encountered an error on an xa_recover operation error occurs during automatic generation of ISIM accounts. Application server attempted to recover Oracle database transactions. Oracle requires special permissions for recovery. We can correct this problem by running the following command to grant permissions:

1. Log in as the user SYS.
2. Run the following commands:
   • grant select on pending_trans$ to public;
   • grant select on dba_2pc_pending to public;
   • grant select on dba_pending_transactions to public;
   • grant execute on dbms_system to <user>;

The default ISIM database user is itimuser.

Parent topic: Troubleshooting database problems