2 Replies Latest reply on Jul 8, 2020 1:53 PM by 3688552

    ODI 12c Agent cannot connect to database

    3688552

      Hi,

       

      We had a network outage and the next day I noticed that my odi packages were failing. On investigation we cannot query a database (edmerpr1) with my agent, I can query other databases with the agent but for edmerpr1 database I cannot. If I use no agent, I can connect to the database(edmerpr1) when I test my connection in Topology but if I use the agent, I get the following error;

       

      ODI-26039: Connection failed.

       

      oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:472)

      at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)

      at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1152)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:915)

      at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$11.doInBackground(SnpsDialogTestConnet.java:873)

      at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

      at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)

      at java.lang.Thread.run(Thread.java:748)

       

       

      I have restarted the agent, I have shutdown the odi managed server and admin and started them again.

       

      ODI Agent Logs

       

      [2020-07-07T20:56:33.093+02:00] [prod_dmz_odi_ms1] [ERROR] [ODI-1131] [oracle.odi.agent] [tid: 131] [userId: <anonymous>] [ecid: 0000NCecmfw6MQw5wFXBiW1V19EL00000M,0:5] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1562312442849] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: KB0810] [oracle.odi.runtime.EntityGuid: 4e1cdaf9-d701-4610-9f82-010441e606cd] Agent OracleDIAgent encountered an error: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

      [2020-07-07T20:56:33.094+02:00] [prod_dmz_odi_ms1] [ERROR] [] [oracle.odi.agent] [tid: 131] [userId: <anonymous>] [ecid: 0000NCecmfw6MQw5wFXBiW1V19EL00000M,0:5] [APP: oraclediagent] [partition-name: DOMAIN] [tenant-name: GLOBAL] [oracle.odi.runtime.MrepExtId: 1562312442849] [oracle.odi.runtime.AgentName: OracleDIAgent] [oracle.odi.runtime.ExecPhase: ProcessRequest] [oracle.odi.runtime.Command: OdiTestDataServer] [oracle.odi.runtime.OdiUser: KB0810] [oracle.odi.runtime.EntityGuid: 4e1cdaf9-d701-4610-9f82-010441e606cd] oracle.odi.runtime.agent.ExecutionException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection[[

      at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:323)

      at oracle.odi.runtime.agent.processor.SimpleAgentRequestProcessor.process(SimpleAgentRequestProcessor.java:49)

      at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

      at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:855)

      at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:773)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)

      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)

      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)

      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)

      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:172)

      at java.security.AccessController.doPrivileged(Native Method)

      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)

      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:110)

      at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:273)

      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:147)

      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:172)

      at java.security.AccessController.doPrivileged(Native Method)

      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)

      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:110)

      at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:273)

      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:147)

      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)

      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3706)

      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3672)

      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:328)

      at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)

      at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)

      at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)

      at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)

      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)

      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)

      at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1705)

      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1665)

      at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)

      at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)

      at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)

      at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)

      at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)

      at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:652)

      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

      at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

      Caused by: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

      at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:294)

      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)

      at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor.doProcessRequest(TestDataServerProcessor.java:131)

      ... 51 more

      Caused by: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.doGetConnection(LoginTimeoutDatasourceAdapter.java:144)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter.getConnection(LoginTimeoutDatasourceAdapter.java:73)

      at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter.getConnection(OnConnectOnDisconnectDataSourceAdapter.java:87)

      at oracle.odi.runtime.agent.processor.impl.TestDataServerProcessor$1.doAction(TestDataServerProcessor.java:288)

      ... 53 more

      Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:775)

      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.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:419)

      at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:392)

      at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:355)

      at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:334)

      at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:228)

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

      at java.lang.Thread.run(Thread.java:748)

      Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

      at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:528)

      at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:528)

      at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:683)

      at oracle.net.ns.NSProtocol.connect(NSProtocol.java:295)

      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1439)

      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:519)

      ... 13 more

      Caused by: java.net.UnknownHostException: edmerpr1

      at java.net.InetAddress.getAllByName0(InetAddress.java:1280)

      at java.net.InetAddress.getAllByName(InetAddress.java:1192)

      at java.net.InetAddress.getAllByName(InetAddress.java:1126)

      at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:138)

      at oracle.net.nt.ConnOption.connect(ConnOption.java:164)

      at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:473)

      ... 18 more

       

       

      ]]

       

      Any ideas ?