Monitor Oracle on Windows Server

[stevros]

Hello to all,
I am a novice in Nagios and Linux world, but for curiosity and necessity, I have configured a CentOS server with Nagios Core (latest versions).

Without incurring in particular problems, I configured everything and implemented the basic controls of my server.

Now I have the need to monitor the Oracle instances, I found a variety of configurations, but none of it seems to me that indicated in my case.

Can someone help me?

Thank you

Sorry for my bad English.

[rkennedy]

Take a look at our exchange (https://exchange.nagios.org) and see if any of the Oracle plugins there will work for you.

[stevros]

Thank you so much.

I decided to use the standard plug-in check_oracle, for practice. I configured a simple:

Check_oracle --tns MYORACLESID

but I get the following error:

"Cannot determine ORACLE_HOME for sid MYORACLESID"

The SID is correct and case sensitive.

Can you help me?

[tgriep]

If the plugin doesn't work, check that the ORACLE_HOME environment
variable is set, that ORACLE_HOME/bin is in your PATH, and the
tnsnames.ora file is locatable and is properly configured.

[stevros]

You're saying that I need to install Oracle Client on my Nagios?

[tgriep]

Depending on which Oracle Plugin you are using, you may need to install the Oracle Instant Client for it to function.

[stevros]

I have installed and configured the Oracle Instant Client as in this guide (versione 12.1):

http://www.unixmen.com/install-oracle-client-centos/

but manually running the command

./check_oracle --tns MYORACLESID

I can not connect to the DB

[tgriep]

Are the settings in your tnsnames.ora correct for the SID you are using correct for your Oracle server?

[stevros]

I have copied the tnsnames.ora from my Windows Oracle:

# TNSNAMES.ORA Network Configuration File: #C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

GST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhostname)(PORT = mytcpport))
)
(CONNECT_DATA =
(SERVICE_NAME = GST)
)
)

Thanks

[tgriep]

Which plugin did you choose? Can you provide a link to it?
What are you trying to monitor on your Oracle Server?
Tale a look at this plugin, and see if this is better suited for what you are trying to monitor.
https://labs.consol.de/nagios/check_ora ... index.html