Page 1 of 1
Oracle tablespace Monitoring
Posted: Tue Oct 22, 2013 1:46 pm
by veenm
I want to monitor the oracle tablespace using check_oracle plugin. I have installed the oracle agent on my nagios core. Please let me know if i want to monitor the tablepace do i require to copy specific tnsnames.ora file from database server to nagio core ?
Re: Oracle tablespace Monitoring
Posted: Tue Oct 22, 2013 2:03 pm
by slansing
No you do not need to copy it, that file is for your tnslistener on your oracle server, contact your DBA and get the name of one of the running listener services nagios can use, then use that with the plugin you downloaded after the required flag.
Re: Oracle tablespace Monitoring
Posted: Thu Oct 24, 2013 6:46 am
by veenm
Hi,
When i run the below command i am getting the error.
root@CNPUDAS011 libexec]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib ORACLE_HOME=/usr/lib/oracle/12.1/client64 ./check_oracle_health --mode list-tablespaces --connect=xxx/yyy@UPRR
CRITICAL - cannot connect to xxx/***@UPRR. ORA-12518: TNS:listener could not hand off client connection (DBD ERROR: OCIServerAttach)
How can i resolve this.
Re: Oracle tablespace Monitoring
Posted: Thu Oct 24, 2013 11:03 am
by sreinhardt
According to the error, you have an incorrect name or listening service. As slansing mentioned, please speak with your DBA about the currently available names that you can connect to. They are probably your best resource for oracle or configuration issues in this case.