Resource manager is unavailable. ORA-17002 SQLErr (0) Weblogic

Data source issue in Oracle Weblogic/SOA

Error:

 

Internal Exception: java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource ‘dsname_doamain’: XAER_RMFAIL : Resource manager is unavailable

oracle.jdbc.xa.OracleXAException: XAErr (-7): Resource manager is unavailable. ORA-17002 SQLErr (0)

          at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1113)

 

Solution:

 

Go to data source–> Connection Pool and Advanced

 

Set the following:

 

Test Connections On Reserve: true

Test Frequency: 60

Connection Creation Retry Frequency: 10

 

Save, activate the changes and restart the servers.


Check below site for the best hiking gears for your next hiking adventure.


Hiking Insights



Best Camping Tables


Posted

in

, ,

by

Tags: