IBM portal 数据库迁移过程遇到的问题

 

源数据库是oracle，目标数据库DB2，备份完成后，开发环境连接oracle无法正常工作：异常如下，

 

WTRN0037W: The transaction service encountered an error on an xa_recover operation. 
The resource was com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl@1114a62. 
The error code was XAER_RMERR. The exception stack trace follows: 
javax.transaction.xa.XAException
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:726)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.recover(WSRdbXaResourceImpl.java:954)
at com.ibm.ws.Transaction.JTA.XARminst.recover(XARminst.java:137)
at com.ibm.ws.Transaction.JTA.XARecoveryData.recover(XARecoveryData.java:609)
at com.ibm.ws.Transaction.JTA.PartnerLogTable.recover(PartnerLogTable.java:511)
at com.ibm.ws.Transaction.JTA.RecoveryManager.resync(RecoveryManager.java:1784)
at com.ibm.ws.Transaction.JTA.RecoveryManager.run(RecoveryManager.java:2241)

 

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


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

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

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


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

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

 

最后怕不保险
grant select on pending_trans$ to public;
grant select on dba_2pc_pending to public;
grant select on dba_pending_transactions to public;