WSRdbDataSour I DSRA8203I: Database product name : Oracle WSRdbDataSour I DSRA8204I: Database product version : Personal Oracle9i Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production WSRdbDataSour I DSRA8205I: JDBC driver name : Oracle JDBC driver WSRdbDataSour I DSRA8206I: JDBC driver version : 9.2.0.1.0 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 : 65535 The Oracle Error message is: Internal XA Error The cause is : null. WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null> 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 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157) at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:295) at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927) at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267) at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164) at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:389) at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903) at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494) . . .
该错误是因为事务管理程序不能将事务转换为 XA 事务。Oracle 明确的返回错误 XAER_RMERR ,错误代码编号为 65535。 ORA-65535 不是一个有效错误代码,并且 XAER_RMERR 实质上意味着 XA 发生了某些错误。这说明您的 Oracle 数据库没有被配置为支持 XA 事务。因此,当 WebSphere Application Server 事务管理程序命令 Oracle 事务管理程序参与这个 XA 事务时,Oracle 拒绝该命令并抛出这个异常。
SecurityCompo I SECJ0243I: Security service started successfully SecurityCompo I SECJ0210I: Security enabled false WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null. 36185510 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null> XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was J2CXAResourceInfo : cfName = XA Example Data Source configProps = [Deployed Resource Adapter Properties] OptionC_authDataAlias java.lang.String scott UserName java.lang.String scott Password java.lang.String ******** TransactionResourceRegistration java.lang.String dynamic InactiveConnectionSupport java.lang.Boolean true secureMode boolean true . . . The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:626) at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:672) at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:130) at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:673) at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1369) at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1440)
ApplicationMg A WSVR0200I: Starting application: IBMUTC
该错误是由于事务管理程序无法执行 XA 恢复操作。Oracle 明确的返回错误 XAER_RMERR。作为最后一个错误, XAER_RMERR 指出了 XA 发生了一些问题。这表明 WebSphere 没有使用 Oracle 正常的关闭连接,可能是由于其中一个服务器没有正常关闭,或者是全都没有正常关闭。因为 WebSphere Application Server 试图重新建立连接,则 Oracle 需要回滚进程中的任何事务,但是使用 WebSphere 登录到数据库的 Oracle 用户(在本范例中是 scott )不能执行恢复工作。