Technote (troubleshooting)
Problem(Abstract)
WebSphere® Application Server logs several messages in SystemOut.log when this problem is encountered,
1. The first will likely be
[4/12/05 12:12:40:227 EDT] 701d7c1b XATransaction E J2CA0030E:
Method enlist caught javax.transaction.SystemException: Failed to start the transaction association.
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1986)
...
Caused by: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:318)
2. The next is the DSRA0304E. The Oracle Error code means this is Oracle error message,
ORA-00600 due to an XAER_RMERR (a resource manager error).
[4/12/05 12:12:41:479 EDT] 701d7c1b WSRdbXaResour E DSRA0304E:
XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occurred in the transaction branch.
The Oracle Error code is : 600
The Oracle Error message is: Internal XA Error
The cause is : null.
3. Then this indicating that an error with XAER_RMERR occurred.
[4/12/05 12:12:41:479 EDT] 701d7c1b WSRdbXaResour E DSRA0302E:
XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
4. [4/12/05 12:12:41:479 EDT] 701d7c1b XATransaction E J2CA0027E:
An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/wpsdbDS,
within transaction ID {XID: formatId(57415344), gtrid_length(48), bqual_length(28), data(000000000000000500000003cc2eb9169d44e55406fa3ed0929193cda15d9d
665765625370686572655f506f7274616ccc2eb9169d44e55406fa3ed0929193cda15
d9d66000000030dfc5e73)}: oracle.jdbc.xa.OracleXAException
1. The first will likely be
[4/12/05 12:12:40:227 EDT] 701d7c1b XATransaction E J2CA0030E:
Method enlist caught javax.transaction.SystemException: Failed to start the transaction association.
at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1986)
...
Caused by: oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:318)
2. The next is the DSRA0304E. The Oracle Error code means this is Oracle error message,
ORA-00600 due to an XAER_RMERR (a resource manager error).
[4/12/05 12:12:41:479 EDT] 701d7c1b WSRdbXaResour E DSRA0304E:
XAException occurred. XAException contents and details are:
The XA Error is : -3
The XA Error message is : A resource manager error has occurred in the transaction branch.
The Oracle Error code is : 600
The Oracle Error message is: Internal XA Error
The cause is : null.
3. Then this indicating that an error with XAER_RMERR occurred.
[4/12/05 12:12:41:479 EDT] 701d7c1b WSRdbXaResour E DSRA0302E:
XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
4. [4/12/05 12:12:41:479 EDT] 701d7c1b XATransaction E J2CA0027E:
An exception occurred while invoking start on an XA Resource Adapter from dataSource jdbc/wpsdbDS,
within transaction ID {XID: formatId(57415344), gtrid_length(48), bqual_length(28), data(000000000000000500000003cc2eb9169d44e55406fa3ed0929193cda15d9d
665765625370686572655f506f7274616ccc2eb9169d44e55406fa3ed0929193cda15
d9d66000000030dfc5e73)}: oracle.jdbc.xa.OracleXAException
Cause
There are some commands that need to be run on the Oracle DB Server in order for it to support XA transactions.
Resolving the problem
The solution is to run two scripts that are included in the Oracle directory. This will likely need to be performed by your Oracle DBA, since 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:
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:
Note, one may also see the following messages logged as well, [4/12/05 12:12:41:479 EDT] 701d7c1b RegisteredRes E 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. The exception stack trace follows: oracle.jdbc.xa.OracleXAException [4/12/05 12:16:55:534 EDT] 73693c1a XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was J2CXAResourceInfo : cfName = wpsdbDS |
댓글 없음:
댓글 쓰기