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:
- 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?