Monitoring Database to see if it's running and send an alert?

[blbr123]

Hi All,

I have a requirement to Monitor whether the Database is running or down and send an alert

and this should be monitored at OS level and the Database is running in the Linux OS

Can anyone help me please how to achieve this?

[gcusello]

Hi @blbr123,

there are more methods to do DB monitoring:

you can identify the process and search is the process is running, e.g. for Splunk if you run;

ps -eafd | grep splunkd

you can check that Splunk is up;

or you could run a command from your database in a script to understand if it's up, e.g. to monitor Splunk you could run:

/opt/splunk/bin/splunk status

and check the condition.

Ciao.

Giuseppe

[blbr123]

How to run the script from database?

[gcusello]

Hi @blbr123,

you have to create a shell script containing the command and execute it by the inputs.conf of Splunk.

For more infos see at https://docs.splunk.com/Documentation/Splunk/9.0.4/AdvancedDev/ScriptSetup

Ciao.

Giuseppe