# Oracle Database monitoring by Elasticsearch, Logstash Pipeline

**URL:** <https://discuss.elastic.co/t/oracle-database-monitoring-by-elasticsearch-logstash-pipeline/310895>\
**Category:** Logstash\
**Created:** [July 28, 2022, 3:33pm UTC](https://discuss.elastic.co/t/oracle-database-monitoring-by-elasticsearch-logstash-pipeline/310895 "2022-07-28T15:33:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aji.shinde7](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aji.shinde7/32/115498_2.png) [@aji.shinde7](https://discuss.elastic.co/u/aji.shinde7)\
**Post date:** [July 28, 2022, 3:33pm UTC](https://discuss.elastic.co/t/oracle-database-monitoring-by-elasticsearch-logstash-pipeline/310895/1 "2022-07-28T15:33:39Z")

</div>

Hello Experts,

I am trying to monitor Oracle Database (which is on a Linux Server) by Elasticsearch. I have created a Logstash Config file which I am running on my own machine.

I have few questions; Please suggest / answer, It will be a great help

1. Should I install Logstash on Database Server and run config there ?

2. In my config file ,

Config file : (Note: Ignore Output section)

```auto
input {
 			jdbc {
   				    jdbc_validate_connection => true
  			     	jdbc_connection_string => "jdbc:oracle:thin:@111.111.1.1:2222/XYZ"
      				jdbc_user => "user_details"
      				jdbc_password => "user_password"
      				jdbc_driver_library => "C:logstash-7.16.3-windows-x86_64\ojdbc7-12.1.0.2.jar"
      				jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
                    statement => "select * from search"
  			       }
        }
 
output {
 elasticsearch {
   					hosts => ["http://localhost:9200"]
   					index => "Ora_Elastic"
   					#user => "elastic"
  					#password => "changeme"
                }
         }

```

Regards,  
Ajit Shinde 🙏  
India

---

<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:** [August 25, 2022, 3:34pm UTC](https://discuss.elastic.co/t/oracle-database-monitoring-by-elasticsearch-logstash-pipeline/310895/2 "2022-08-25T15:34:35Z")

</div>

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