Splunk AppDynamics

IO error: the network adapter could not establish connection. Oracle DB to AppDynamics controller

CommunityUser
Splunk Employee
Splunk Employee

I have configured the DB collector with the Ip address, Service Name, and Listener ports along with a user with required permission. DB is displayed on the controller UI but it isn't sending any data because of an error        "IO error: the network adapter could not establish connection". 

DB is up and running, listener is configured correctly, inbound rule for firewall is allowing port 1521 from the controller but the issue still exists. I tried googling for hours but only things i found were related to Oracle database itself not in regards to DB configuration in AppDynamics. 

Thanks in advance.

Labels (3)
0 Karma

CommunityUser
Splunk Employee
Splunk Employee
Most probably you have listener configured wrongly, the hostname you specify in connection string must be the same as in the listener.

https://www.youtube.com/watch?v=pMQXVihgrrE&t=212s

https://adhoctuts.com/fix-oracle-io-error-the-network-adapter-could-not-establish-the-connection-err...
0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Here is the Diagnostics Event

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at com.singularity.ee.agent.dbagent.collector.db.relational.DriverManager.getConnection(DriverManager.java:28) at com.singularity.ee.agent.dbagent.collector.db.relational.oracle.OracleCollector.initConnection(OracleCollector.java:40) at com.singularity.ee.agent.dbagent.collector.db.relational.oracle.OracleCollector.initConnection(OracleCollector.java:49) at com.singularity.ee.agent.dbagent.collector.db.relational.ARelationalDBCollector.verifyCollector(ARelationalDBCollector.java:62) at com.singularity.ee.agent.dbagent.collector.db.ADBCollector.collect(ADBCollector.java:145) at com.singularity.ee.agent.dbagent.collector.db.ADBCollector.run(ADBCollector.java:133) at com.singularity.ee.util.javaspecific.scheduler.AgentScheduledExecutorServiceImpl$SafeRunnable.run(AgentScheduledExecutorServiceImpl.java:122) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask$Sync.innerRunAndReset(ADFutureTask.java:335) at com.singularity.ee.util.javaspecific.scheduler.ADFutureTask.runAndReset(ADFutureTask.java:152) at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.access$101(ADScheduledThreadPoolExecutor.java:119) at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.runPeriodic(ADScheduledThreadPoolExecutor.java:206) at com.singularity.ee.util.javaspecific.scheduler.ADScheduledThreadPoolExecutor$ADScheduledFutureTask.run(ADScheduledThreadPoolExecutor.java:236) at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.runTask(ADThreadPoolExecutor.java:694) at com.singularity.ee.util.javaspecific.scheduler.ADThreadPoolExecutor$Worker.run(ADThreadPoolExecutor.java:726) at java.lang.Thread.run(Thread.java:745) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:445) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486) ... 22 more Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:589) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:162) at oracle.net.nt.ConnOption.connect(ConnOption.java:133) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:411) ... 27 more

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Have you verified that you are able to reach the Oracle database host/port from the server where database agent is installed.

You can find more information about network requirements here.

https://docs.appdynamics.com/display/PRO44/Database+Visibility+System+Requirements#DatabaseVisibilit...

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Thanks for the response.

So right now I have the agent installed on the same server as DB.

Controller-info.xml is configured and port 1521 is allowed from AppDynamics Controller IP address to DB.

On the controller side, I have specified DB type, Name, DB IP address, Service Name, Listener port and UN/PW configured per AppDynamics documentation.

Is it necessary to install the agent on different server than the DB itself? or can there be other issue that's causing the connectivity issue?

Please let me know if you need more information.

Regards,

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...