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

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

Failure:
```
test case failed: one or more errors found while examining elastic-agent.logs3201010025: [0] found error "Unit state changed sql/metrics-default-sql/metrics-oracle-8b5716d4-504b-4499-9ba2-042557cb91ed (HEALTHY->DEGRADED): Error fetching data for metricset sql.query: cannot open connection: testing connection: user=\"sys\" standalone params={authMode:2 connectionClass: connectionClassLength:0 purity:0 newPassword: newPasswordLength:0 appContext: numAppContext:0 externalAuth:0 externalHandle: pool: tag: tagLength:0 matchAnyTag:0 outTag: outTagLength:0 outTagFound:0 shardingKeyColumns: numShardingKeyColumns:0 superShardingKeyColumns: numSuperShardingKeyColumns:0 outNewSession:0}: ORA-12541: TNS:no listener"
```

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

Latest 5 failed builds:
- https://buildkite.com/elastic/integrations/builds/45763
- https://buildkite.com/elastic/integrations/builds/45841
- https://buildkite.com/elastic/integrations/builds/45909
- https://buildkite.com/elastic/integrations/builds/45972
- https://buildkite.com/elastic/integrations/builds/46036

Start by comparing the latest failed Buildkite runs for the oracle.tablespace system test and inspect the elastic-agent logs for the ORA-12541 error. The issue is resolved when the tablespace test can connect successfully and the listed builds no longer fail for the listener error.

Written by the indexing model from the issue text.