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