Oracle Database Discussions

Hi, we encounter following error everytime we bring down the application servers, even after we deleted the tranlog and temp file. Application server is running webspear and DB is Oracle9i 9.2.0.7.


[10/30/08 10:04:15:593 CST] 5010bad6 InternalGener I DSRA8203I: Database product name : Oracle
[10/30/08 10:04:15:594 CST] 5010bad6 InternalGener I DSRA8204I: Database product version : Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
[10/30/08 10:04:15:594 CST] 5010bad6 InternalGener I DSRA8205I: JDBC driver name : Oracle JDBC driver
[10/30/08 10:04:15:594 CST] 5010bad6 InternalGener I DSRA8206I: JDBC driver version : 10.2.0.1.0
[10/30/08 10:04:15:600 CST] 5010bad6 WSRdbXaResour E DSRA0304E: XAException occurred. XAException contents and details are: The cause is : null.
[10/30/08 10:04:15:614 CST] 5010bad6 WSRdbXaResour E DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is: <null>
[10/30/08 10:04:15:699 CST] 5010bad6 XARminst E WTRN0037W: The transaction service encountered an error on an xa_recover operation. The resource was J2CXAResourceInfo :
cfName = OperationalTX
configProps = [Deployed Resource Adapter Properties]
OptionC_authDataAlias java.lang.String kjrm01/cnos
TransactionResourceRegistration java.lang.String dynamic
InactiveConnectionSupport java.lang.Boolean true
secureMode boolean true

dd = [Resource Adapter DD]
ManagedConnectionFactory Class Name: com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl
Transaction Support: 2
Reauthentication Support: false

mcfProps = com.ibm.ejs.j2c.ManagedConnectionFactoryProps@17583a81
mmProps = {authDataAlias=kjrm01/cnos, BasicPassword=javax.resource.spi.security.PasswordCredential, mappingConfigAlias=DefaultPrincipalMapping, authMechanismPreference=BASIC_PASSWORD}
mbeanProps = null
secureMode = true
cmConfig = [Resource-ref settings]

res-auth: 0 (CONTAINER)
res-isolation-level: 0 (TRANSACTION_NONE)
res-sharing-scope: true (SHAREABLE)
res-resolution-control: 999 (undefined)
[Other attributes]

isCMP1_x: false (not CMP1.x)
isJMS: false (not JMS)

recoveryClasspath = /usr/WebSphere/AppServer/lib/rsadapter.rar
Component Alias = kjrm01/cnos
baseCfName = OperationalTX
. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java(Compiled Code))
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.ResyncThread.run(RecoveryManager.java:1449)