Troubleshooting
Problem
When the WebSphere Adapter for JDBC is used to perform an XA transaction using Oracle database, the following error is generated: WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR.
Cause
For the Oracle database server to support XA transactions, some commands need to be run.
Resolving The Problem
Two scripts that are included in the Oracle directory should be run. This activity will likely need to be performed by your Oracle DBA, because you must be logged into Oracle as SYSOPER or SYSDBA in order to have the necessary permissions for these scripts to work. The scripts are:
<ORACLE_HOME>\javavm\install
file: initxa.sql
file: initjvm.sql
The initxa.sql script configures the database for XA. Once it runs successfully, your database is configured for XA. The script might run successfully the first time you try. Unfortunately, it probably will not run successfully because some of the database's memory spaces are too small.
To fix this, run the initjvm.sql script. It will probably fail too, but in doing so, it will indicate which parameters need to be adjusted. The parameters are stored in this file:
<ORACLE_HOME>\database
file: init<DATABASE_SID>.ora
The following table shows two parameters that typically need to be increased. Your particular database configuration might require adjustment of different parameters.
Parameter Name | Minimum Value |
java_pool_size | 12000000 |
shared_pool_size | 24000000 |
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21240695