My Oracle Support Banner

OCI Stack Monitoring: EBS Refresh Fails After a Node Failure In DBaaS/RAC (Doc ID 3041819.1)

Last updated on AUGUST 29, 2024

Applies to:

OCI Stack Monitoring - Version N/A and later
Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

A problem with DBaaS Node 2 occurred,
But Stack monitoring EBS Refresh continued to try to reach DB Node 2 instead of using the SCAN to successfully query against DB Node 1

Discovery Job output:

INFO Time taken to execute DiscoveryJob: 340885 ms Tue, 30 Jul 2024 15:20:13 UTC
ERROR [ebs_instance] Discovery failure: ExecutionException: FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection due to FetchletException: Failed to connect: java.sql.SQLRecoverableExcept...; Tue, 30 Jul 2024 15:19:52 UTC
INFO Time taken for discovery call and to populate result : 319893 ms Tue, 30 Jul 2024 15:19:52 UTC
ERROR [ebs_instance] Discovery failure: ExecutionException: FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection due to FetchletException: Failed to connect: java.sql.SQLRecoverableExcept...; Tue, 30 Jul 2024 15:19:47 UTC
ERROR Discovery failed for ebs_instance; work item, wi-xxxxxx; ExecutionException: FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection due to FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection due to SQLRecoverableException: IO Error: The Network Adapter could not establish the connection due to NetException: The Network Adapter could not establish the connection due to IOException: Connection refused, socket connect lapse 0 ms. <hostname>/<IP ADDRESS> <DB PORT> 300000 1 true due to ConnectException: Connection refused Tue, 30 Jul 2024 15:19:47 UTC

/agent_inst/log/mgmt_agent.log

 [SysExecutor.9 (ebs_instance.<EBS_INSTANCE_NAME>) (ebs_instance.<EBS_INSTANCE_NAME>:EBSDiscovery)-33] WARN - ebs_instance.<EBS_INSTANCE_NAME>:EBSDiscovery
oracle.polaris.core.services.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.polaris.core.services.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:975) ~[agent-core-1.0.3590.jar:?]
at oracle.polaris.core.source.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:252) ~[agent-core-1.0.3590.jar:?]

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.