Saturday, July 14, 2018
Sending oracle logs - plsql to elasticsearch - elk
To send logs, error or any other information from Oracle databese you have to create POST request to your elasticsearch server (http://your_elasticsearch_server:9200).
You can create your own request using package utl_http or you can download created package from https://tomeuwork.wordpress.com/2016/06/13/indexing-into-elasticsearch-from-oracle-with-plsql/
The url consists of:
http://your_elasticsearch_server:port/index/type
port: default is 9200
index: logstash-your_text
type: logs
The content for logging can be:
You can create your own request using package utl_http or you can download created package from https://tomeuwork.wordpress.com/2016/06/13/indexing-into-elasticsearch-from-oracle-with-plsql/
The url consists of:
http://your_elasticsearch_server:port/index/type
port: default is 9200
index: logstash-your_text
type: logs
The content for logging can be:
{
"loggerFqcn": "my_oracle_logger",
"level": "DEBUG",
"endOfBatch": false,
"thread": "main",
"message": "my massage from DB",
"threadPriority": 5,
"threadId": 1,
"@timestamp": "2017-08-22T13:21:31.344Z",
"port":2222,
"@version": "1",
"host": "172.21.223.217",
"loggerName": "oracle",
"contextMap": {},
"timeMillis": 1503408077762
}
