XAException occurred. Error code is: XAER_RMERR

---

问题提出：ibm portal默认使用内置db2数据库，执行迁移操作到oracle后，无法正常停止portal进程，报如下错误信息：

[12/18/09 19:18:39:289 CST] 00000028 InternalOracl I DSRA8203I: Database product name : Oracle
[12/18/09 19:18:39:289 CST] 00000028 InternalOracl I DSRA8204I: Database product version : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
[12/18/09 19:18:39:289 CST] 00000028 InternalOracl I DSRA8205I: JDBC driver name : Oracle JDBC driver
[12/18/09 19:18:39:290 CST] 00000028 InternalOracl I DSRA8206I: JDBC driver version : 10.2.0.1.0
[12/18/09 19:18:39:290 CST] 00000028 InternalOracl I DATA_STORE_HELPER_NAME
[12/18/09 19:18:39:290 CST] 00000028 WSRdbDataSour I DSRA8208I: JDBC driver type : ""
[12/18/09 19:18:39:294 CST] 00000028 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
[12/18/09 19:18:39:294 CST] 00000028 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR (-3). Exception is:
[12/18/09 19:18:39:295 CST] 00000028 XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@15d2dc71. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:992)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:690)
at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:514)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1896)
at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2608)
at java.lang.Thread.run(Thread.java:571)

解决办法：

方法一：grant select on dba_pending_transactions to ; --------------------USER为你要连接oracle db 的用户名

方法二：更新jdbc驱动到10.2.0.4

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10537377/viewspace-623219/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10537377/viewspace-623219/