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 laterEnterprise 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:
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 |