[LogsDB] [Subscription basic] [oracle] Failing test daily: system test: (elastic-agent logs - sysmetric) in oracle.sysmetric

[elastic-vault-github-plugin-prod]

• Stack version: maximum of either the version used in PR builds or 8.17.0 (GA version for LogsDB index mode)
• LogsDB: enabled
• Subscription: basic
• 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.logs4165396991: [0] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-691a8252-746c-4a96-8881-093b9a8b6dc0 (HEALTHY->DEGRADED): 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"

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

Latest failed builds:

• https://buildkite.com/elastic/integrations/builds/40064