My Oracle Support Banner

Database Test connection failed. Connection.isValid() returned false. (Doc ID 2018739.1)

Last updated on OCTOBER 09, 2018

Applies to:

Oracle WebLogic Server - Version 10.3.6 to 10.3.6
Information in this document applies to any platform.

Symptoms

On : 12.1.3.0.0 version

You are experiencing a database test connection failure when connectivity between WLS and EBS database is lost and that happens whenever the EBS database is restarted. When Database test connection is made from Admin console it throws error - "Database Test connection failed. Connection.isValid() returned false" in the admin console. Following error is from the log file:

<May 14, 2015 5:29:50 PM PDT> <Error> <oracle.soa.adapter.aq.inbound> <BEA-000000> <[composite_name: OracleHR2EBS] [composite_version: 3.2.0.1] [endpoint_name: OracleHRAqAdapter] DBDequeueAgent_runInbound: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'OracleEBSDS_asots02Domain': XAER_RMFAIL : Resource manager is unavailable
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1806)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:350)
at weblogic.jdbc.jta.DataSource.start(DataSource.java:830)
at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1311)
at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1244)
at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:292)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:585)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:490)
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1739)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1641)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:227)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:95)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:78)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:98)
at weblogic.jdbc.wrapper.JTAConnection.getAutoCommit(JTAConnection.java:351)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.beforeDequeue(AbstractDequeueAgent.java:338)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:325)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.runInbound(AbstractDequeueAgent.java:134)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:103)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:7205)
at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:191)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:345)
... 20 more

at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1744)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1641)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:227)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:95)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:78)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:98)
at weblogic.jdbc.wrapper.JTAConnection.getAutoCommit(JTAConnection.java:351)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.beforeDequeue(AbstractDequeueAgent.java:338)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:325)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.runInbound(AbstractDequeueAgent.java:134)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:103)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)

java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: XA error: XAResource.XAER_RMFAIL start() failed on resource 'OracleEBSDS_asots02Domain': XAER_RMFAIL : Resource manager is unavailable
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1806)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:350)
at weblogic.jdbc.jta.DataSource.start(DataSource.java:830)
at weblogic.transaction.internal.XAServerResourceInfo.start(XAServerResourceInfo.java:1311)
at weblogic.transaction.internal.XAServerResourceInfo.xaStart(XAServerResourceInfo.java:1244)
at weblogic.transaction.internal.XAServerResourceInfo.enlist(XAServerResourceInfo.java:292)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:585)
at weblogic.transaction.internal.ServerTransactionImpl.enlistResource(ServerTransactionImpl.java:490)
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1739)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1641)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:227)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:95)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:78)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:98)
at weblogic.jdbc.wrapper.JTAConnection.getAutoCommit(JTAConnection.java:351)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.beforeDequeue(AbstractDequeueAgent.java:338)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:325)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.runInbound(AbstractDequeueAgent.java:134)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:103)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
Caused by: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:7205)
at oracle.jdbc.driver.T4CXAResource.doStart(T4CXAResource.java:191)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:345)
... 20 more

at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1744)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1641)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:227)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:95)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:78)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:98)
at weblogic.jdbc.wrapper.JTAConnection.getAutoCommit(JTAConnection.java:351)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.beforeDequeue(AbstractDequeueAgent.java:338)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:325)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.runInbound(AbstractDequeueAgent.java:134)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:103)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)

at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1660)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:227)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:95)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:78)
at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:98)
at weblogic.jdbc.wrapper.JTAConnection.getAutoCommit(JTAConnection.java:351)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.beforeDequeue(AbstractDequeueAgent.java:338)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.getInputRecord(AbstractDequeueAgent.java:325)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.runInbound(AbstractDequeueAgent.java:134)
at oracle.tip.adapter.aq.v2.database.AbstractDequeueAgent.run(AbstractDequeueAgent.java:103)
at oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:184)
at weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
at weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
>

 

 

<?xml version='1.0' encoding='UTF-8'?>
<jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd">
 <name>OracleAppsDataSourceDS</name>
 <jdbc-driver-params>
   <url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test2-ebs-scan.tst.nintendo.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=aebts02)))</url>
   <driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>
   <properties>
     <property>
       <name>user</name>
       <value>apps</value>
     </property>
   </properties>
   <password-encrypted>{AES}dy6fB9+Yo89/n6P98EEehKA6qT+ZE7OTm7v+rXoQcTGLQU4EWm5J/dyZ2tNzdQRW</password-encrypted>
 </jdbc-driver-params>
 <jdbc-connection-pool-params>
   <initial-capacity>5</initial-capacity>
   <max-capacity>300</max-capacity>
   <min-capacity>5</min-capacity>
   <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
 </jdbc-connection-pool-params>
 <jdbc-data-source-params>
   <jndi-name>jdbc/OracleAppsDataSource</jndi-name>
   <global-transactions-protocol>TwoPhaseCommit</global-transactions-protocol>
 </jdbc-data-source-params>
 <jdbc-oracle-params>
   <fan-enabled>true</fan-enabled>
   <ons-node-list>test2-ebs-scan.tst.nintendo.com:6200</ons-node-list>
 </jdbc-oracle-params>
</jdbc-data-source>

 

Issue happens only when EBS DB is restarted. 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.