My Oracle Support Banner

Standalone Agent Fails to Start With Error "oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset by peer" (Doc ID 2568545.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After rebooting the system, starting the standalone Oracle Data Integrator (ODI) agent will not start and results in the following error in the odiagent.log:

 

[2019-07-11T13:27:17.230+05:00] [odi] [ERROR] [ODI-1131] [oracle.odi.agent] [tid: 1] [ecid: .] Agent <STANDALONE_AGENT_NAME> encountered an error: ODI-1400: Agent <STANDALONE_AGENT_NAME> start failure: JDBC connection error occurs while connecting to the master repository. Caused by: ODI-1579: Agent <STANDALONE_AGENT_NAME> start failure: data source for master repository did not contain a master repository using JDBC URL=jdbc:oracle:thin:@//<DB_HOST>:<DB_PORT>/<DB_SERVICE> with <ODI_REPO_SCHEMA>.
[2019-07-11T13:27:17.232+05:00] [odi] [ERROR] [] [oracle.odi.agent] [tid: 1] [ecid: .] ODI-1579: Agent <STANDALONE_AGENT_NAME> start failure: data source for master repository did not contain a master repository using JDBC URL=jdbc:oracle:thin:@//<DB_HOST>:<DB_PORT>/<DB_SERVICE> with <ODI_REPO_SCHEMA>.[[
ODI-1579: Agent <STANDALONE_AGENT_NAME> start failure: data source for master repository did not contain a master repository using JDBC URL=jdbc:oracle:thin:@//<DB_HOST>:<DB_PORT>/<DB_SERVICE> with USER=<ODI_REPO_SCHEMA>.
Caused By: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 109264 ms.
   at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)
   at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)
   at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:942)
   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1971)
   at oracle.ucp.jdbc.PoolDataSourceImpl.access$500(PoolDataSourceImpl.java:198)
   at oracle.ucp.jdbc.PoolDataSourceImpl$30.build(PoolDataSourceImpl.java:4355)
   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1926)
   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1889)
   at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:1874)
   at oracle.odi.Agent.validateConnectionProperties(Agent.java:688)
   at oracle.odi.Agent.doGetDataSource(Agent.java:637)
   at oracle.odi.Agent.main(Agent.java:754)
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 109264 ms.
   at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:336)
   at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:59)
   at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:129)
   at oracle.ucp.jdbc.oracle.OracleDriverConnectionFactoryAdapter.createConnection(OracleDriverConnectionFactoryAdapter.java:85)
   at oracle.ucp.common.Database.createPooledConnection(Database.java:256)
   at oracle.ucp.common.Topology.start(Topology.java:236)
   at oracle.ucp.common.Core.start(Core.java:1800)
   at oracle.ucp.common.UniversalConnectionPoolBase.start(UniversalConnectionPoolBase.java:709)
   at oracle.ucp.jdbc.oracle.OracleJDBCConnectionPool.start(OracleJDBCConnectionPool.java:129)
   at oracle.ucp.jdbc.PoolDataSourceImpl.startPool(PoolDataSourceImpl.java:938)
... 9 more
Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset by peer, Authentication lapse 109264 ms.
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:795)
   at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:833)
   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:40)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:704)
   at oracle.ucp.jdbc.DriverConnectionFactoryAdapter.createConnection(DriverConnectionFactoryAdapter.java:125)
... 16 more
Caused by: java.io.IOException: Connection reset by peer, Authentication lapse 109264 ms.
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:791)
... 20 more
Caused by: java.io.IOException: Connection reset by peer
   at sun.nio.ch.FileDispatcherImpl.write0(Native Method)
   at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
   at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
   at sun.nio.ch.IOUtil.write(IOUtil.java:65)
   at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)
   at oracle.net.nt.TimeoutSocketChannel.write(TimeoutSocketChannel.java:216)
   at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:212)
   at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:182)
   at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:133)
   at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:97)
   at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:535)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:486)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
   at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:500)
   at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1323)
   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:664)
... 20 more

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
References


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