Hi Team,
We observed this issue while publishing messages, and it occurred exactly twice. Could you please help us understand the reason behind the “End of TNS data channel” error? The log clearly indicates that the connection was closed by peer.
We are using the OJDBC11 jar upgraded to version 23.26, along with the updated UCP jar. The database also appears to be upgraded to 26ai. Our setup uses an Autonomous AI ATP DB, and AQ is connected to this cloud database through an agent installed on the local system.
After some time, everything started working fine. However, at the specific times of 11:59 AM and 2:11 PM on Monday, we faced this issue. We suspect that the behavior is intermittent. Integrations executed successfully at 11:21 AM, and again around 3–4 PM, so the issue was isolated to only those two occurrences. From the DB side, we did not receive much information since it is serverless.
Below is the log snapshot.
Please let us know if the log indicates anything specific or helps in identifying the reason.
Caused by: java.sql.SQLRecoverableException: ORA-03113: database connection closed by peer (connection_type=client, source=connection from agent server, target=DB location with port, protocol=tcps, service=low service used, detecting_end=client, server_type=unknown, client_program=JDBC Thin Client, server_process=null, session=null.null, user=AQ, last_rpc=Get the session key, connection_id=hUgUNAC3T+SuWnRreXAR6A==, nne_encryption=null, nne_checksumming=null, authentication=O5LOGON) (CONNECTION_ID=hUgUNAC3T+SuWnRreXAR6A==)
https://docs.oracle.com/error-help/db/ora-03113/
at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:1897)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:1201)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1210)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:106)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:909)
at oracle.jdbc.datasource.impl.OracleDataSource.getPhysicalConnection(OracleDataSource.java:716)
at oracle.jdbc.datasource.impl.OracleDataSource.getConnection(OracleDataSource.java:384)
at oracle.jdbc.datasource.impl.OracleDataSource.getConnectionInternal(OracleDataSource.java:2224)
at oracle.jdbc.datasource.impl.OracleDataSource.getConnection(OracleDataSource.java:357)
at oracle.jdbc.datasource.impl.OracleDataSource.getConnection(OracleDataSource.java:318)
at oracle.tip.adapter.aq.v2.jca.AQManagedConnectionFactory.createWalletDBConnection(AQManagedConnectionFactory.java:635)
at oracle.tip.adapter.aq.v2.jca.AQManagedConnectionFactory.createManagedConnection(AQManagedConnectionFactory.java:124)
... 11 more
Caused by: oracle.net.ns.NetException: ORA-03113: database connection closed by peer (connection_type=client, source=connection from agent server, target=DB location with port, protocol=tcps, service=low service used, detecting_end=client, server_type=unknown, client_program=JDBC Thin Client, server_process=null, session=null.null, user=AQ, last_rpc=Get the session key, connection_id=hUgUNAC3T+SuWnRreXAR6A==, nne_encryption=null, nne_checksumming=null, authentication=O5LOGON) (CONNECTION_ID=hUgUNAC3T+SuWnRreXAR6A==)
https://docs.oracle.com/error-help/db/ora-03113/
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:1004)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:466)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:820)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:237)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:859)
at oracle.jdbc.driver.T4CConnection.authenticateWithPassword(T4CConnection.java:2387)
at oracle.jdbc.driver.T4CConnection.authenticateUserForLogon(T4CConnection.java:2341)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:1154)
... 21 more
Caused by: oracle.net.ns.NetException: ORA-17902: End of TNS data channel. (CONNECTION_ID=hUgUNAC3T+SuWnRreXAR6A==)
https://docs.oracle.com/error-help/db/ora-17902/
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:124)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:932)
... 28 more
latest 26 wallet is not used , 23ai wallet is used for publish flow.
more, we want to understand what all reason of this error. category selected as database software, please redirect if needed