Problem: IBM Portal USES the built-in DB2 database by default. After performing the migration operation to Oracle, the portal process cannot be stopped normally. The following error message is reported:
[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)
Solutions:
Grant select on dba_pending_transactions to; –USER is the name of the USER you want to connect to Oracle DB
Method 2: Update the JDBC driver to 10.2.0.4
 
 
 

From “ITPUB blog” link: http://blog.itpub.net/10537377/viewspace-623219/, if you want to reprint, please indicate the source, otherwise will be investigated for legal responsibility.

Reproduced in: http://blog.itpub.net/10537377/viewspace-623219/