Oracle database monitoring

[sneha.irali]

Hi Team,

we need to enable the oracle database status monitoring, is there a way we can enable it from nagiosXI

[pbroste]

Hello @sneha.irali

Thanks for reaching out, we do provide a support article that includes instructions on Oracle Database Monitoring.

Please let us know if you have further questions,
Perry

[sneha.irali]

Hi,

Thanks for sharing the article, however I have setup the oracle pulgin.

I wanted to know which metric can be used to monitor the database status only.

I thought of monitoring the listener service name, but team says even if the listener is running the DB will be down in actual hence we need this monitoring.

[pbroste]

Hello @sneha.irali

Thanks for following up, and here is an example:

/usr/local/nagios/libexec/check_oracle_health --connect '192.168.xxx.xxx:1521/xe' --username 'nagios' --password 'yourpassword' --mode connection-time --warning 1 --critical 5

Thanks,
Perry

[sneha.irali]

will I find this check under the Oracle Serverspace Monitoring Wizard..?

[ssax]

Yes, you can use any one of these wizards to monitor them:
- Use the Oracle Query wizard for running specific SQL queries
- Use the Oracle Serverspace wizard to monitor the Oracle server
- Use the Oracle Tablespace wizard to monitor specifici Oracle databases/tablespaces

This is used for the Oracle Query wizard, you can see all of the options with this command:

Code: Select all

/usr/local/nagios/libexec/check_oracle -h

This one should be for Serverspace/Tablespace, you can see all of the options with this command:

Code: Select all

/usr/local/nagios/libexec/check_oracle_health -h

[sneha.irali]

I think this monitors the userID connection which I am using from the tool.

Do we have any other option to do this.

[ssax]

Run through the Oracle Server and Oracle Tablespace wizards with your information and it should monitor them. The Oracle Tablespace wizard is the one that will try to monitor specific databases. You can also use the Oracle Query wizard to run a query against specific database names which will show that the DB is up, functional, and queryable.

[sneha.irali]

Hi,

Can I know using which wizard I can enable oracle database status, since I check for the oracleserver, however i see it shows the connection status for the user id I have used to setup the monitoring.

However this do not suffice my requirement.

[ssax]

I'm investigating this and will update shortly.