RAD 8 Exception RAD 8 Exception oracle oracle

RAD 8 Exception


Could it be your Oracle or Java process was shutdown without completing a transaction? which is it trying to recover but can't, see IBM - WebSphere Application Server fails to start with XAException: XAER_RMERR (xa_recover)

snippet

This means that the transaction manager could not perform an XA recover operation, and Oracle returned an XAER_RMERR error to indicate that WebSphere did not close its connection with Oracle properly. When WebSphere Application Server attempts to reestablish the connection, Oracle must rollback any transactions that were in progress, but the Oracle user that WebSphere uses to log into the database (scott, in this example) cannot perform the recovery.

The solution is to give the Oracle user permission to perform the recovery, specifically to access the internal Oracle tables used to manage recovery.

To do this:

  • Login in to SQL Plus as SYSOPER or SYSDBA. Run the following command:

grant select on DBA_PENDING_TRANSACTIONS to PUBLIC

Note:If you don't want to grant this permission to all users, specify only the user listed in the error (in this example, scott).

  • Restart the database. Restart the
  • WebSphere server.


Just delete the two log files from this path:

[your_project]/.metadata/.plugins/com.ibm.etools.server.core/tmp0/tranlog/server1/transaction

There are two folders there: partnerlog and tranlog. Inside, there are two log files, log1 and log2. Delete them both. Then restart your websphere.


A solution as well as the work around mentioned above for the javax.transaction.xa.XAException are described in this article from IBM's product support:http://www-01.ibm.com/support/docview.wss?uid=swg21196663