[Stack 9.4.0-SNAPSHOT] [oracle] Failing test daily: system test: (elastic-agent logs - sysmetric) in oracle.sysmetric

[elastic-vault-github-plugin-prod]

• Stack version: 9.4.0-SNAPSHOT
• Package: oracle
• Failing test: system test: (elastic-agent logs - sysmetric)
• DataStream: sysmetric
• Owners:
  • @elastic/obs-infraobs-integrations

Failure:

test case failed: one or more errors found while examining elastic-agent.logs2017798834: [0] found error "Component state changed sql/metrics-default (HEALTHY->DEGRADED): Recoverable: Error fetching data for metricset sql.query: cannot open connection: testing connection: user=\"sys\" standalone params={authMode:2 connectionClass:<nil> connectionClassLength:0 purity:0 newPassword:<nil> newPasswordLength:0 appContext:<nil> numAppContext:0 externalAuth:0 externalHandle:<nil> pool:<nil> tag:<nil> tagLength:0 matchAnyTag:0 outTag:<nil> outTagLength:0 outTagFound:0 shardingKeyColumns:<nil> numShardingKeyColumns:0 superShardingKeyColumns:<nil> numSuperShardingKeyColumns:0 outNewSession:0}: ORA-12541: TNS:no listener"
[1] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-6b8879dc-c89c-460c-b0b1-b230ef4a2422 (HEALTHY->DEGRADED): Recoverable: Error fetching data for metricset sql.query: cannot open connection: testing connection: user=\"sys\" standalone params={authMode:2

First build failed: https://buildkite.com/elastic/integrations/builds/40044

Latest failed builds:

• https://buildkite.com/elastic/integrations/builds/40062
• https://buildkite.com/elastic/integrations/builds/40072