Page 1 of 1
Monitor Oracle on Windows Server
Posted: Sun May 22, 2016 8:22 am
by 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.
Re: Monitor Oracle on Windows Server
Posted: Mon May 23, 2016 9:33 am
by rkennedy
Take a look at our exchange (
https://exchange.nagios.org) and see if any of the Oracle plugins there will work for you.
Re: Monitor Oracle on Windows Server
Posted: Mon May 23, 2016 10:43 am
by 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?
Re: Monitor Oracle on Windows Server
Posted: Mon May 23, 2016 3:20 pm
by 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.
Re: Monitor Oracle on Windows Server
Posted: Tue May 24, 2016 12:44 am
by stevros
You're saying that I need to install Oracle Client on my Nagios?
Re: Monitor Oracle on Windows Server
Posted: Tue May 24, 2016 9:47 am
by tgriep
Depending on which Oracle Plugin you are using, you may need to install the Oracle Instant Client for it to function.
Re: Monitor Oracle on Windows Server
Posted: Tue May 24, 2016 10:17 am
by 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
Re: Monitor Oracle on Windows Server
Posted: Tue May 24, 2016 4:31 pm
by tgriep
Are the settings in your tnsnames.ora correct for the SID you are using correct for your Oracle server?
Re: Monitor Oracle on Windows Server
Posted: Wed May 25, 2016 12:13 am
by 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
Re: Monitor Oracle on Windows Server
Posted: Wed May 25, 2016 11:05 am
by 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