# Oracle DB monitoring - Error while running metricbeat

**URL:** https://discuss.elastic.co/t/oracle-db-monitoring-error-while-running-metricbeat/346084
**Category:** Metrics
**Created:** [October 31, 2023, 5:11am UTC](https://discuss.elastic.co/t/oracle-db-monitoring-error-while-running-metricbeat/346084 "2023-10-31T05:11:35Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![nandhini\_r](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nandhini_r/32/120073_2.png) [@nandhini\_r](https://discuss.elastic.co/u/nandhini_r)
#### Post date: [October 31, 2023, 5:11am UTC](https://discuss.elastic.co/t/oracle-db-monitoring-error-while-running-metricbeat/346084/1 "2023-10-31T05:11:36Z")

</div>

Hi,

I have been struggle on how to monitored an oracle DB instance, using the ELK stack. I have install everything Elasticsearch, Logstash, Kibana, Metricbeat but I am getting some error and I will attach the error in the below.

Oracle module yml file:

```auto
- module: oracle
  metricsets: ["tablespace", "performance"]
  enabled: true
  period: 10s
  #hosts: ["username:password@0.0.0.0:1521/ORCLPDB1.localdomain"]
  #hosts: ['user="username" password="password" connectString="0.0.0.0:1521/ORCLPDB1.localdomain"']
  hosts: ['user=username password=password connectString=0.0.0.0:1521/ORCLPDB1.localdomain sysdba=true']
  #hosts: ["username/password@0.0.0.:1521/ORCLPDB1.localdomain"]
  #hosts: ["username/password@0.0.0.0:1521/ORCLPDB1.localdomain as sysdba"] 

```

Tried the above configuration but still getting the below error

Error:

**ERROR [reload] cfgfile/list.go:99 Error creating runner from config: 2 errors: host parsing failed for oracle-tablespace: error parsing URL: parse**

**invalid character " " in host name; host parsing failed for oracle-performance: error parsing URL: parse**

Can someone help on this to solve?

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [October 31, 2023, 6:35am UTC](https://discuss.elastic.co/t/oracle-db-monitoring-error-while-running-metricbeat/346084/2 "2023-10-31T06:35:19Z")

</div>

I edited your post to format the code to make it easier to read. You should really try to do that going forward.

The `hosts` you currently have uncommented is incorrect as it does not use quotes around the values.

Please try the second one and provide as much of the error as you possibly can.

Also curious if you have special characters in the password?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 28, 2023, 6:35am UTC](https://discuss.elastic.co/t/oracle-db-monitoring-error-while-running-metricbeat/346084/3 "2023-11-28T06:35:41Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
