[LogsDB] [Stack 8.19.16-SNAPSHOT] [oracle] Failing test daily: system test: (elastic-agent logs - systemstatistics) in oracle.system_statistics

[elastic-vault-github-plugin-prod]

• Stack version: 8.19.16-SNAPSHOT
• LogsDB: enabled
• Package: oracle
• Failing test: system test: (elastic-agent logs - systemstatistics)
• DataStream: system_statistics
• Owners:
  • @elastic/obs-infraobs-integrations

Failure:

test case failed: one or more errors found while examining elastic-agent.logs1176689426: [0] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-7fe3a021-10f1-497f-8709-a7d59e7dd594 (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/42594

Latest failed builds:

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