Oracle tablespace Monitoring

[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 ?

[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.

[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.

[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.