This error comes when WebSphere Application Server (WAS) and/or Oracle servers were not shut down properly, then you might see XAException with (xa_recover) in the description of the error then it is very possible that the user which is being used to connect to the Oracle database by the WebSphere Application Server (WAS) does not have select permission on DBA_PENDING_TRANSACTIONS.
Run the following command SQL Plus as SYSOPER or SYSDBA
grant select on DBA_PENDING_TRANSACTIONS to PUBLIC
OR
grant select on DBA_PENDING_TRANSACTIONS to username
This should resolve the issue.
No comments:
Post a Comment