Resolution<\/span><\/p>\n1. Run the following commands as user SYS<\/b>:<\/p>\n
grant select on pending_trans$ to <user>;<\/tt>
\ngrant select on dba_2pc_pending to <user>;<\/tt>
\ngrant select on dba_pending_transactions to <user>;<\/tt>
\ngrant execute on dbms_system to <user>; \u00a0(If using Oracle 10.2.0.3 or lower JDBC driver)<\/tt>
\ngrant execute on dbms_xa to <user>; (If using Oracle 10.2.0.4 or higher JDBC driver)<\/tt><\/p>\n
Where <user> is the username configured in the Oracle datasource’s authentication alias.<\/p>\n
2. If the recovery of the inflight transactions is not important, then one possible workaround to this problem is to remove the transaction logs.<\/p>\n
<PROFILE_NAME>\\tranlog\\<CELL_NAME>\\<NODE_NAME>\\<SERVER_NAME>\\transaction<\/p>\n
To remove the transaction logs, do the following:
\n(1) Stop the server.
\n(2) Delete the ‘\\transaction<\/code>‘ folder and all subdirectories.
\n(3) Restart the server.
\nThe above exceptions will no longer occur.<\/p>\nThough one of the solution is to update the Oracle database privileges, but in my case, customer was not ready to do (infact the oracle database team didn’t agree to do). So as this doesn’t affect much, during any restarts they normally clean up the transactions logs (after taking a backup of portal server partition).<\/p>\n","protected":false},"excerpt":{"rendered":"
xa_recover operation XAER_RMERR error shows up in logs frequently in Websphere Portal Server v8.0 when configured with Oracle database. In Portal server system out logs, below exception is seen frequently. Customer was repeatedly asking me whats the issue and why its throwing very often. Error occurred on, Portal server v8.0.0.1 Oracle Database v12c AIX 7 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[177,176],"class_list":["post-647","post","type-post","status-publish","format-standard","hentry","category-websphere-portal-server","tag-xa_recover-operation","tag-xaer_rmerr"],"_links":{"self":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/647","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/comments?post=647"}],"version-history":[{"count":4,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/647\/revisions"}],"predecessor-version":[{"id":651,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/posts\/647\/revisions\/651"}],"wp:attachment":[{"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/media?parent=647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/categories?post=647"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.middlewareprimer.com\/blog\/wp-json\/wp\/v2\/tags?post=647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}