# Error connecting agent to Oracle Database using SQL input integration

**URL:** <https://discuss.elastic.co/t/error-connecting-agent-to-oracle-database-using-sql-input-integration/366532>\
**Category:** Elastic Agent\
**Tags:** metricbeat\
**Created:** [September 13, 2024, 12:13pm UTC](https://discuss.elastic.co/t/error-connecting-agent-to-oracle-database-using-sql-input-integration/366532 "2024-09-13T12:13:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![goncalobsantos](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/goncalobsantos/32/50118_2.png) [@goncalobsantos](https://discuss.elastic.co/u/goncalobsantos)\
**Post date:** [September 13, 2024, 12:13pm UTC](https://discuss.elastic.co/t/error-connecting-agent-to-oracle-database-using-sql-input-integration/366532/1 "2024-09-13T12:13:19Z")

</div>

I'm trying to use the [sql input integration](https://www.elastic.co/docs/current/integrations/sql) to query a database, but keep getting the following error:

```auto
cannot open connection: testing connection: dpoPool_create user=METRICBEAT extAuth=0: ORA-12154: TNS:could not resolve the connect identifier specified

```

I've tried all the different patterns of connection strings:

'user="user" password="password" connectString="dns:1521/XXX.localdomain"'

'user="user" password="password" connectString="dns:1521/XXX"'

'user="user" password="password" connectString="ip:1521/XXX.localdomain"'

'user="user" password="password" connectString="ip:1521/XXX"'

"user/password@ip:1521/XXX.localdomain"

"user/password@ip:1521/XXX"

'user="user" password="password" connectString="dns:1521/XXX" sysdba=true'

'user="user" password="password" connectString="ip:1521/XXX" sysdba=true'

But keep getting the same results. Any ideas?