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.
Monitor Oracle on Windows Server
Re: Monitor Oracle on Windows Server
Take a look at our exchange (https://exchange.nagios.org) and see if any of the Oracle plugins there will work for you.
Former Nagios Employee
Re: Monitor Oracle on Windows Server
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?
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
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.
variable is set, that ORACLE_HOME/bin is in your PATH, and the
tnsnames.ora file is locatable and is properly configured.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Monitor Oracle on Windows Server
You're saying that I need to install Oracle Client on my Nagios?
Re: Monitor Oracle on Windows Server
Depending on which Oracle Plugin you are using, you may need to install the Oracle Instant Client for it to function.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Monitor Oracle on Windows Server
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
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
Are the settings in your tnsnames.ora correct for the SID you are using correct for your Oracle server?
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: Monitor Oracle on Windows Server
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
# 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
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
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
Be sure to check out our Knowledgebase for helpful articles and solutions!