源数据库是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;