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.XAExceptionat 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;
页:
[1]