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

[elastic-vault-github-plugin-prod]

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

Failure:

test case failed: one or more errors found while examining elastic-agent.logs1689873192: [0] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-d1ac6e90-92b2-45dd-8d45-7b38ee4a7548 (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/49027