原文出处

 

http://publib.boulder.ibm.com/infocenter/tivihelp/v3r1/index.jsp?topic=/com.ibm.itcamrtt.doc/itcamftt_installcluster20.htmhttp://www-01.ibm.com/support/docview.wss?rs=0&q1=3979190&uid=swg21196663&loc=en_US&cs=utf-8&cc=us&lang=enhttp://www.atomikos.com/Documentation/ConfiguringOraclehttp://forums.oracle.com/forums/thread.jspa?threadID=376954

现象

WebSphere在发生一些异常情况下(比如WebSphere服务异常推出），出现如下错误信息

 

日志跟踪 [09-5-24 10:45:03:168 CST] 00000012 InternalOracl I DSRA8203I: Database 产品名：Oracle [09-5-24 10:45:03:176 CST] 00000012 InternalOracl I DSRA8204I: Database 产品版本：Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [09-5-24 10:45:03:180 CST] 00000012 InternalOracl I DSRA8205I: JDBC driver 名：Oracle JDBC driver [09-5-24 10:45:03:184 CST] 00000012 InternalOracl I DSRA8206I: JDBC driver 版本：10.2.0.1.0 [09-5-24 10:45:03:187 CST] 00000012 InternalOracl I DSRA8212I: DataStoreHelper 名称为：com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper@44aa44aa。 [09-5-24 10:45:03:191 CST] 00000012 WSRdbDataSour I DSRA8208I: JDBC driver 类型："" [09-5-24 10:45:03:205 CST] 00000012 WSRdbXaResour E DSRA0304E: 发生 XAException。XAException 内容和详细信息是：The cause is : null。 [09-5-24 10:45:03:209 CST] 00000012 WSRdbXaResour E DSRA0302E: 发生 XAException。错误代码为：XAER_RMERR (-3)。异常为：<null> [09-5-24 10:45:03:213 CST] 00000012 XARminst E WTRN0037W: xa_recover 操作时事务服务遇到错误。资源是 com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@1e681e68。错误代码为 XAER_RMERR。异常堆栈跟踪遵循：javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:526) at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:1038) at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:138) at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:687) at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:524) at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1859) at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2580) at java.lang.Thread.run(Thread.java:810)

 

 解决办法

 

以SYSDBA登录SQL Plus

执行如下代码

grant select on sys.dba_pending_transactions to username; grant select on sys.pending_trans$ to username; grant select on sys.dba_2pc_pending to username; grant execute on sys.dbms_system to username;

 username ==> 获取oracle XA数据库连接的用户

相关资源：敏捷开发V1.0.pptx